AUTOINCREMENT by value

(1) By Deyan (dido__) on 2021-07-30 10:03:44 [link] [source]

Hello,

does SQLTIE support an AUTOINCREMENT by value feature similar to MYSQL?

I am trying to port a MYSQL db app to run on SQLITE but stumbled upon a table that has an AUTOINCREMENT primary key with the increment value of 2.

If this one is not supported, is there a chance to request this feature to be implemented in SQLTIE?

(2) By anonymous on 2021-07-30 13:40:55 in reply to 1 [link] [source]

What should be the benefit?

(3) By Keith Medcalf (kmedcalf) on 2021-07-30 19:28:29 in reply to 1 [link] [source]

Can you not merely "pretend" that everything is twice as big as it needs to be?

(4) By Gunter Hick (gunter_hick) on 2021-07-30 19:49:56 in reply to 1 [source]

If you are picky about the exact values of rowids, you should be assigning them yourself.

Also note that AUTOINCREMENT does not guarantee that successive rowids will be adjacent, only monotonously ascending; the increment of a rowid may be committed, even if the record to be inserted is rolled back for any reason, including a constraint violation.