Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

dolt migrate: differing rows #4603

Closed
druvv opened this issue Oct 24, 2022 · 1 comment
Closed

dolt migrate: differing rows #4603

druvv opened this issue Oct 24, 2022 · 1 comment
Assignees
Labels
bug Something isn't working new format Issues related specifically to the __DOLT__ storage format

Comments

@druvv
Copy link
Contributor

druvv commented Oct 24, 2022

Received the following error while migrating https://www.dolthub.com/repositories/dolthub/logo-2k-extended

job failed: failed to migrate: failed to migrate: migration failed
cause: differing rows for table brands ([A&A,MANAGEMENT CONSULTING SERVICES] != [A-BIKE,TRANSPORTATION])
@druvv druvv added bug Something isn't working new format Issues related specifically to the __DOLT__ storage format labels Oct 24, 2022
@andy-wm-arthur
Copy link
Contributor

I reproduced this locally and ran into a different, but related error:

differing rows for table brands ([H&A LONG ISLAND ELECTRICIAN,BUSINESS SERVICES] != [H. J. HEINZ,FOOD])

It appears that ampersands & are not ordered correctly in the old format:

select * from brands where brand like 'H%' order by brand limit 20 offset 3880;
+------------------------------------+----------------------------+
| brand                              | category                   |
+------------------------------------+----------------------------+
| H/W HARRIS WILLIAMS                | BANKING                    |
| H/WACSS                            | COMPUTER                   |
| H/X                                | NEWSPAPER                  |
| H&                                 | BEVERAGES                  |
| H&A LONG ISLAND ELECTRICIAN        | BUSINESS SERVICES          |
| H&A REPORT                         | TECHNOLOGY                 |
| H&E EQUIPMENT SERVICES         | CONSTRUCTION               |
| H&B                                | BUSINESS                   |
| H&B COLLECTION                     | BEAUTY                     |
| H&B ELECTRONIC                     | COMPUTER                   |
| H&B FITNESS CLUB                   | SPORTS                     |
| H&B WIG FASHION HAIR               | FASHION                    |
| H&B WITH LOVE                      | BUSINESS                   |
| H&C                                | COMPUTER                   |
| H&C - Louis Ng                     | MARKETING & ADVERTISING    |
| H&C - SWIMC LLC                    | HEALTH, WELLNESS & FITNESS |
| H&C - The Sherwin-Williams Company | CHEMICALS                  |
| H&C CONCRETE INSPIRED. - SWIMC LLC | INDUSTRIAL                 |
| H&C HORSE & COUNTRY                | COMMUNICATION              |
| H&C INTERNATIONAL INC. H&C SPORT   | SPORTS                     |
+------------------------------------+----------------------------+
20 rows in set (0.38 sec)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working new format Issues related specifically to the __DOLT__ storage format
Projects
None yet
Development

No branches or pull requests

2 participants