Stanislav Zabka wrote: > When conflict occurs, no import performs, but PK is incremented nevertheless.
<https://www.sqlite.org/autoinc.html> says: | Note that "monotonically increasing" does not imply that the ROWID | always increases by exactly one. One is the usual increment. However, | if an insert fails due to (for example) a uniqueness constraint, the | ROWID of the failed insertion attempt might not be reused on | subsequent inserts, resulting in gaps in the ROWID sequence. | AUTOINCREMENT guarantees that automatically chosen ROWIDs will be | increasing but not that they will be sequential. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
