I've been doing exactly that. It is, creating a new DB file for each test, and I was having the same problem as you.
I suggested a change to the driver to cover that situation: https://github.com/pharo-rdbms/Pharo-SQLite3/pull/22/files Try applying that change and see if that works. I still prefer to recreate the database, it will give you a full fresh start, and if you want you can halt before the deletion of the db, to analyze its internal state. Best regards! Esteban A. Maringolo On Sat, Aug 7, 2021 at 11:13 PM <vin...@gmail.com> wrote: > > Hi > > Actually I will just do a bunch of > > DROP TABLE IF EXISTS > > instead of dropping the db altogether. > > Thanks, Vince
