Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Test that two database connections that use different VFS implementations may not share a cache. (CVS 6426) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
3a92c95644ead7c4728ffec1ec706766 |
User & Date: | danielk1977 2009-04-01 18:25:54.000 |
Context
2009-04-01
| ||
18:40 | Fix a bug in the sqlite3Utf16ByteLen() function so that it computes the correct length even for strings that contain surrogate pairs. Ticket #3766. (CVS 6427) (check-in: 766bb7e59c user: drh tags: trunk) | |
18:25 | Test that two database connections that use different VFS implementations may not share a cache. (CVS 6426) (check-in: 3a92c95644 user: danielk1977 tags: trunk) | |
18:03 | Remove the unused SQLITE_Vtab flag. (CVS 6425) (check-in: fdd78962fc user: danielk1977 tags: trunk) | |
Changes
Changes to test/shared6.test.
1 2 3 4 5 6 7 8 9 10 11 | # 2009 April 01 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # | | | | | | | | | | | | | | | | | | | | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 | # 2009 April 01 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # # $Id: shared6.test,v 1.2 2009/04/01 18:25:54 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl ifcapable !shared_cache { finish_test ; return } do_test shared6-1.1.1 { execsql { CREATE TABLE t1(a, b); CREATE TABLE t2(c, d); CREATE TABLE t3(e, f); } } {} do_test shared6-1.1.2 { set ::enable_shared_cache [sqlite3_enable_shared_cache 1] sqlite3_enable_shared_cache } {1} do_test shared6-1.1.3 { sqlite3 db1 test.db sqlite3 db2 test.db } {} # Exclusive shared-cache locks. Test the following: # # 1.2.1: If [db1] has an exclusive lock, [db2] cannot read. # 1.2.2: If [db1] has an exclusive lock, [db1] can read. # 1.2.3: If [db1] has a non-exclusive write-lock, [db2] can read. # do_test shared6-1.2.1 { execsql { SELECT * FROM t1 } db2 ;# Cache a compiled statement execsql { BEGIN EXCLUSIVE } db1 catchsql { SELECT * FROM t1 } db2 ;# Execute the cached compiled statement } {1 {database table is locked}} do_test shared6-1.2.2 { execsql { SELECT * FROM t1 } db1 } {} do_test shared6-1.2.3 { execsql { COMMIT; BEGIN; INSERT INTO t2 VALUES(3, 4); } db1 execsql { SELECT * FROM t1 } db2 } {} do_test shared6-1.2.X { execsql { COMMIT } db1 } {} # Regular shared-cache locks. Verify the following: # # 1.3.1: If [db1] has a write-lock on t1, [db1] can read from t1. # 1.3.2: If [db1] has a write-lock on t1, [db2] can read from t2. # 1.3.3: If [db1] has a write-lock on t1, [db2] cannot read from t1. # 1.3.4: If [db1] has a write-lock on t1, [db2] cannot write to t1. # 1.3.5: If [db1] has a read-lock on t1, [db2] can read from t1. # 1.3.6: If [db1] has a read-lock on t1, [db2] cannot write to t1. # do_test shared6-1.3.1 { execsql { BEGIN; INSERT INTO t1 VALUES(1, 2); } db1 execsql { SELECT * FROM t1 } db1 } {1 2} do_test shared6-1.3.2 { execsql { SELECT * FROM t2 } db2 } {3 4} do_test shared6-1.3.3 { catchsql { SELECT * FROM t1 } db2 } {1 {database table is locked: t1}} do_test shared6-1.3.4 { catchsql { INSERT INTO t2 VALUES(1, 2) } db2 } {1 {database table is locked}} do_test shared6-1.3.5 { execsql { COMMIT; BEGIN; SELECT * FROM t1; } db1 execsql { SELECT * FROM t1 } db2 } {1 2} do_test shared6-1.3.5 { catchsql { INSERT INTO t1 VALUES(5, 6) } db2 } {1 {database table is locked: t1}} do_test shared6-1.3.X { execsql { COMMIT } db1 } {} # Read-uncommitted mode. # # For these tests, connection [db2] is in read-uncommitted mode. # # 1.4.1: If [db1] has a write-lock on t1, [db2] can still read from t1. # 1.4.2: If [db1] has a write-lock on the db schema (sqlite_master table), # [db2] cannot read from the schema. # 1.4.3: If [db1] has a read-lock on t1, [db2] cannot write to t1. # do_test shared6-1.4.1 { execsql { PRAGMA read_uncommitted = 1 } db2 execsql { BEGIN; INSERT INTO t1 VALUES(5, 6); } db1 execsql { SELECT * FROM t1 } db2 } {1 2 5 6} do_test shared6-1.4.2 { execsql { CREATE TABLE t4(a, b) } db1 catchsql { SELECT * FROM t1 } db2 } {1 {database table is locked}} do_test shared6-1.4.3 { execsql { COMMIT; BEGIN; SELECT * FROM t1; } db1 catchsql { INSERT INTO t1 VALUES(7, 8) } db2 } {1 {database table is locked: t1}} do_test shared6-1.X { db1 close db2 close } {} # The following tests - shared6-2.* - test that two database connections # that connect to the same file using different VFS implementations do # not share a cache. if {$::tcl_platform(platform) eq "unix"} { do_test shared6-2.1 { sqlite3 db1 test.db -vfs unix sqlite3 db2 test.db -vfs unix sqlite3 db3 test.db -vfs unix-none sqlite3 db4 test.db -vfs unix-none } {} do_test shared6-2.2 { execsql { BEGIN; INSERT INTO t1 VALUES(9, 10); } db1 catchsql { SELECT * FROM t1 } db2 } {1 {database table is locked: t1}} do_test shared6-2.3 { execsql { SELECT * FROM t1 } db3 } {1 2 5 6} do_test shared6-2.3 { execsql { COMMIT } db1 execsql { BEGIN; INSERT INTO t1 VALUES(11, 12); } db3 catchsql { SELECT * FROM t1 } db4 } {1 {database table is locked: t1}} do_test shared6-2.4 { execsql { SELECT * FROM t1 } db1 } {1 2 5 6 9 10} do_test shared6-2.5 { execsql { COMMIT } db3 } {} do_test shared6-2.X { db1 close db2 close db3 close db4 close } {} } sqlite3_enable_shared_cache $::enable_shared_cache finish_test |