SQLite. Data Editor. Creating a new record.
With Valentina Studio Pro 10.6.3 and earlier versions the primary key would automatically autoincrement, even though it wasn't set to do so.
With Valentina Studio Pro 12.4.3, the primary key appears to be automatically choosing the lowest number that no longer exists.
My understanding is the primary key would choose the lowest number that no longer exists, but having never seen it happen until using 12.4.3 ....
Is my understanding correct? Is the difference in behavior intended?
Thanks.