dynamobi/dynamobi — Issue #338: [FRG-429] generated...as sequence does not continue properly after version upgrade
Author: dynamobi-build
Created: 2011-12-30 02:33:22+00:00
State: open
Labels: Catalog, FRG

[reporter="ksecretan", created="Fri, 8 Jul 2011 18:05:23 -0500 (GMT-05:00)"]
From an original luciddb 0.9.3, a table foobar.blah (c1 int, c2 int) was created with c1 being an auto increment column. Inserted some data, properly goes from 0 to 5. After doing an upgrade to a 0.9.4 candidate, the table is still there but the auto increment restarted at 1000. My current best-guess of what is happening is that the pre-allocated sequence 0-1000 has been marked invalid during the transition, and so the allocator class allocated the next block of 1000 to 1999 and started there. Why it's doing that, I don't know.