SQLite Forum

Recover Database
Login
The result is exactly correct.

Line 1 created the outer transaction and named the state immediately after opening the outer transaction "A".

Line 4 created a savepoint "B" representing the location in the transaction after table T1 was created.

Line 9 attempted to open an outer transaction, but a transaction was already in progress, so you were presented with an error message and nothing was done.

Line 14 did a rollback of the outer transaction to BEFORE the creation of table T1 and "got rid of" savepoint locations "A" and "B" in that transaction.

Line 16 attempted to select from the non-existent table T1, you got an error message, and nothing was done.

Line 17 attempted to commit a transaction, but no transaction was in progress, so you got an error message and nothing was done.

Lines 18 and 20 attempted to access non-existent table T1 so you got an error message and nothing was done.

Line 21 attempted to rollback a non-existent transaction, so you got an error message and nothing was done.

Line 23 attempted to access non-existent table T1 so you got an error message and nothing was done.