dolt icon indicating copy to clipboard operation
dolt copied to clipboard

migrate: column type cannot be auto-incremented

Open druvv opened this issue 2 years ago • 2 comments

https://www.dolthub.com/repositories/dolthub/bug-repro/jobs/92959642-55da-48f0-a8dd-c3561b0f634a?refName=main

druvv avatar Nov 09 '22 19:11 druvv

At one point, we were incorrectly serializing the auto-increment on disk. When auto-increment is enabled, we should have been writing a 1 but we were writing a 0.

When the bug was fixed, previously created columns that were non-auto-increment were interpreted as an auto-increment column.

We ended up deleting the above database.

druvv avatar Nov 14 '22 19:11 druvv

We aren't going to fix this issue, but we are leaving it open for visibility. Please reach out to the Dolt team if you run into this issue.

Databases created from a specific time period in the past will have this issue.

druvv avatar Nov 23 '22 23:11 druvv