Hi Pierce, Yes, I already knew about this problem and documentation. That's why I do it in a transaction. My question was about be unsure my code example do it correctly in Pharo. Thanks Hilaire Le 20/07/2016 21:09, Pierce Ng a écrit :
On Sat, Jul 16, 2016 at 02:19:37PM +0800, Hilaire wrote:
In a multi-thread context use of Sqlite, I try to find out how one will fetch securely the automatically last row index of a Primary key.
The problem seems to be that between the insert of rows in a table and the moment you request the last row id, you may have another insert from another thread in the same database. Hi Hilaire,
See http://www.sqlite.org/c3ref/last_insert_rowid.html, especially last paragraph:
If a separate thread performs a new INSERT on the same database connection while the sqlite3_last_insert_rowid() function is running and thus changes the last insert rowid, then the value returned by sqlite3_last_insert_rowid() is unpredictable and might not equal either the old or the new last insert rowid.
Pierce
-- Dr. Geo http://drgeo.eu