sqlite3 - sqlite - autoincrement field generates negative numbers -


i have strange issue sqlite. if run query , add record autoinc field functions properly. numbers go in sequence.

however, if use grid , dbnavigator add record directly inside grid , autoinc field not follow sequence of numbers adds -1 newly added record.

is bug or kind of normal behavior unaware off ?


Comments