Line 23 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. Lines 18 and 20 attempted to access non-existent table T1 so 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. Line 16 attempted to select from the non-existent table T1, you got an error message, and nothing was done. Line 14 did a rollack of the outer transaction to BEFORE the creation of table T1 and "got rid of" savepoint locations "A" and "B" in that transaction. 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 4 created a savepoint "B" representing the location in the transaction after table T1 was created.
Line 1 created the outer transaction and named the state immediately after opening the outer transaction "A".
I think the behavior is different from what I've understood, and I think it isn't compliant with what is stipulated on this page Save as 't1.sql' and execute sqlite3 t1.db < t1.sqlĮrror: near line 9: cannot start a transaction within a transactionĮrror: near line 16: no such table: T1 (→ Rolled the database back to save point AĮrror: near line 17: cannot commit - no transaction is activeĮrror: near line 21: cannot rollback - no transaction is active
CANT DRAG DB.SQLITE3 TO DB BROWSER FOR SQLITE CODE
Here is my code for the experiment:Ģ CREATE TABLE T1 (X TEXT NOT NULL DEFAULT "") Let me recap what I've understood what has been said:ī) save points may have a begin-instruction.
0 kommentar(er)
