search

dolthub / dolthub-issues

Issues for dolthub.com
https://dolthub.com
4 stars 1 forks source link

`duplicate primary key given` error #491

Closed liuliu-dev closed 1 year ago

liuliu-dev commented 1 year ago

insert a row into a table without primary keys in spreadsheet editor, and then import the file Screenshot 2023-08-15 at 11 56 40 AM

got duplicate primary key given error in import job https://dolthub-preview-1.awsdev.ld-corp.com/repositories/liuliu/test_query_csv/jobs/77aa4690-5b6a-48ad-aaa1-a0be8774afd0

liuliu-dev commented 1 year ago

this was due to when migrating dbs, max_id did not get updated in allocated_sequential_ids table. fixed now.