1# 2007 Dec 4 2# 3# The author disclaims copyright to this source code. In place of 4# a legal notice, here is a blessing: 5# 6# May you do good and not evil. 7# May you find forgiveness for yourself and forgive others. 8# May you share freely, never taking more than you give. 9# 10#*********************************************************************** 11# 12# This file is to test that ticket #2820 has been fixed. 13# Ticket #2820 observes that a DROP TABLE statement that 14# occurs while a query is in process will fail with a 15# "database is locked" error, but the entry in the sqlite_master 16# table will still be removed. This is incorrect. The 17# entry in the sqlite_master table should persist when 18# the DROP fails due to an error. 19# 20# $Id: tkt2820.test,v 1.1 2007/12/04 16:54:53 drh Exp $ 21# 22 23set testdir [file dirname $argv0] 24source $testdir/tester.tcl 25 26proc test_schema_change {testid init ddl res} { 27 db close 28 file delete -force test.db test.db-journal 29 sqlite3 db test.db 30 execsql $init 31 do_test tkt2820-$testid.1 { 32 set STMT [sqlite3_prepare db {SELECT * FROM sqlite_master} -1 DUMMY] 33 sqlite3_step $STMT 34 } {SQLITE_ROW} 35#if {$testid==3} {execsql {PRAGMA vdbe_trace=ON}} 36 do_test tkt2820-$testid.2 "catchsql [list $ddl]" \ 37 {1 {database table is locked}} 38 do_test tkt2820-$testid.3 { 39 sqlite3_finalize $STMT 40 execsql {SELECT name FROM sqlite_master ORDER BY 1} 41 } $res 42 integrity_check tkt2820-$testid.4 43 db close 44 sqlite3 db test.db 45 integrity_check tkt2820-$testid.5 46} 47 48test_schema_change 1 { 49 CREATE TABLE t1(a); 50} { 51 DROP TABLE t1 52} {t1} 53test_schema_change 2 { 54 CREATE TABLE t1(a); 55 CREATE TABLE t2(b); 56} { 57 DROP TABLE t2 58} {t1 t2} 59test_schema_change 3 { 60 CREATE TABLE t1(a); 61 CREATE INDEX i1 ON t1(a); 62} { 63 DROP INDEX i1 64} {i1 t1} 65 66# We further observe that prior to the fix associated with ticket #2820, 67# no statement journal would be created on an SQL statement that was run 68# while a second statement was active, as long as we are in autocommit 69# mode. This is incorrect. 70# 71do_test tkt2820-4.1 { 72 db close 73 file delete -force test.db test.db-journal 74 sqlite3 db test.db 75 db eval { 76 CREATE TABLE t1(a INTEGER PRIMARY KEY); 77 INSERT INTO t1 VALUES(1); 78 INSERT INTO t1 VALUES(2); 79 } 80 81 # The INSERT statement within the loop should fail on a 82 # constraint violation on the second inserted row. This 83 # should cause the entire INSERT to rollback using a statement 84 # journal. 85 # 86 db eval {SELECT name FROM sqlite_master} { 87 catch {db eval { 88 INSERT INTO t1 SELECT a+1 FROM t1 ORDER BY a DESC 89 }} 90 } 91 db eval {SELECT a FROM t1 ORDER BY a} 92} {1 2} 93 94finish_test 95