gitlab.com/CoiaPrant/sqlite3@v1.19.1/testdata/tcl/jrnlmode2.test (about) 1 # 2009 March 24 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 13 set testdir [file dirname $argv0] 14 source $testdir/tester.tcl 15 16 ifcapable {!pager_pragmas} { 17 finish_test 18 return 19 } 20 21 if {[atomic_batch_write test.db]} { 22 finish_test 23 return 24 } 25 26 #------------------------------------------------------------------------- 27 # The tests in this file check that the following two bugs (both now fixed) 28 # do not reappear. 29 # 30 # jrnlmode2-1.*: Demonstrate bug #3745: 31 # 32 # In persistent journal mode, if: 33 # 34 # * There is a persistent journal in the file-system, AND 35 # * there exists a connection with a shared lock on the db file, 36 # 37 # then a second connection cannot open a read-transaction on the database. 38 # The reason is because while determining that the persistent-journal is 39 # not a hot-journal, SQLite currently grabs an exclusive lock on the 40 # database file. If this fails because another connection has a shared 41 # lock, then SQLITE_BUSY is returned to the user. 42 # 43 # jrnlmode2-2.*: Demonstrate bug #3751: 44 # 45 # If a connection is opened in SQLITE_OPEN_READONLY mode, the underlying 46 # unix file descriptor on the database file is opened in O_RDONLY mode. 47 # 48 # When SQLite queries the database file for the schema in order to compile 49 # the SELECT statement, it sees the empty journal in the file system, it 50 # attempts to obtain an exclusive lock on the database file (this is a 51 # bug). The attempt to obtain an exclusive (write) lock on a read-only file 52 # fails at the OS level. Under unix, fcntl() reports an EBADF - "Bad file 53 # descriptor" - error. 54 # 55 56 do_test jrnlmode2-1.1 { 57 execsql { 58 PRAGMA journal_mode = persist; 59 CREATE TABLE t1(a, b); 60 INSERT INTO t1 VALUES(1, 2); 61 } 62 } {persist} 63 64 do_test jrnlmode2-1.2 { 65 file exists test.db-journal 66 } {1} 67 68 do_test jrnlmode2-1.3 { 69 sqlite3 db2 test.db 70 execsql { SELECT * FROM t1 } db2 71 } {1 2} 72 73 do_test jrnlmode2-1.4 { 74 execsql { 75 INSERT INTO t1 VALUES(3, 4); 76 } 77 execsql { 78 BEGIN; 79 SELECT * FROM t1; 80 } 81 execsql { PRAGMA lock_status } 82 } {main shared temp closed} 83 84 do_test jrnlmode2-1.5 { 85 file exists test.db-journal 86 } {1} 87 88 do_test jrnlmode2-1.6 { 89 catchsql { SELECT * FROM t1 } db2 90 } {0 {1 2 3 4}} 91 92 do_test jrnlmode2-1.7 { 93 execsql { COMMIT } 94 catchsql { SELECT * FROM t1 } db2 95 } {0 {1 2 3 4}} 96 97 98 99 do_test jrnlmode2-2.1 { 100 db2 close 101 execsql { PRAGMA journal_mode = truncate } 102 execsql { INSERT INTO t1 VALUES(5, 6) } 103 } {} 104 105 do_test jrnlmode2-2.2 { 106 file exists test.db-journal 107 } {1} 108 109 do_test jrnlmode2-2.3 { 110 file size test.db-journal 111 } {0} 112 113 do_test jrnlmode2-2.4 { 114 sqlite3 db2 test.db -readonly 1 115 catchsql { SELECT * FROM t1 } db2 116 } {0 {1 2 3 4 5 6}} 117 118 do_test jrnlmode2-2.5 { 119 db close 120 delete_file test.db-journal 121 } {} 122 do_test jrnlmode2-2.6 { 123 sqlite3 db2 test.db -readonly 1 124 catchsql { SELECT * FROM t1 } db2 125 } {0 {1 2 3 4 5 6}} 126 127 catch { db2 close } 128 finish_test