Closed druvv closed 2 years ago
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)
Received the following error while migrating https://www.dolthub.com/repositories/dolthub/logo-2k-extended