Lines Matching refs:db2

89   sqlite3 db2 test.db
102   } db2
114   } db2
122   } db2
130   } db2
153   } db2
173   # Start read transactions on db and db2 (the shared pager cache). Ensure
182   } db2
185   } db2
190   # db2 should not be able to read def (because of the write-lock).
193 # has started a write-transaction on db2 (should this be so?). This 
195 # db2 transaction back and replace it with a new read transaction.
200   } db2
208     catchsql { SELECT * FROM def; } db2
212   # Commit the open transaction on db. db2 still holds a read-transaction.
225 catchsql COMMIT db2
237   execsql {SELECT * FROM sqlite_master} db2
238   execsql {PRAGMA read_uncommitted = 1} db2
241   db2 eval {SELECT i FROM seq ORDER BY i} {
258   db2 eval {SELECT i FROM seq} {
271 catch {db2 close}
286 # Open two database handles db and db2. Each has a single attach database
291 #     db2.main  ->   ./test2.db
292 #     db2.test  ->   ./test.db
298 sqlite3 db2 test2.db
309   execsql {ATTACH 'test.db' AS test} db2
315 # db2 can "see" the new table immediately. A handle using a seperate pager
329   } db2
340   } db2
358   # Cleanup: commit the transaction opened by db2.
361   } db2
389     } db2
394   set ::DB2 [sqlite3_connection_pointer db2]
420 catch {db2 close}
431   sqlite3 db2 test.db
441   } db2
468   } db2
474     } db2
481     } db2
487   } db2
515     } db2
519   # Establish a write lock on table t2 via connection db2. Then make a 
529   } db2
543   } db2
556 catch {db2 close}
572   sqlite3 db2 test.db
623     } db2
637 catch {db2 close}
658     sqlite3 db2 test.db
662     } db2
670     db2 close
684     sqlite3 db2 test2.db
688     } db2
689     string range [execsql {PRAGMA encoding;} db2] 0 end-2
693   catch {db2 close}
732 catch {db2 close}
743   sqlite3 db2 test.db
758   } db2
762   db2 close
772   # Create a small sample database with two connections to it (db and db2).
775   sqlite3 db2 test.db
795   } db2
815   db2 close
818   # Test that the db2 transaction has been automatically rolled back.
825   # Closing db2 should have dropped the shared-cache back to a read-lock.
856   sqlite3 db2 test.db
865   catchsql {BEGIN;} db2
866   catchsql {SELECT * FROM abc;} db2
869   catchsql {BEGIN} db2
872   catchsql {SELECT * FROM abc2;} db2
875   catchsql {INSERT INTO abc2 VALUES(1, 2, 3);} db2
884   } db2
894   db2 eval {
914   db2 close
1004   sqlite3 db2 test.db
1006 } {db1 db2 db3 db4 db5 db6 db7 db8 db9 db10 db11 db12 db13 db14}
1011       db2 close
1016 } {db1 db2 db3 db4 db5 db6 db7 db8 db9 db10 db11 db12 db13 db14}
1022 # [db2]. This is to try to find any points where shared-schema elements
1031   sqlite3 db2 test.db -fullmutex 1
1054   execsql { DROP TABLE t1 } db2
1057 db2 close
1063   sqlite3 db2 file::memory: -uri 1
1067   db2 eval {
1072   db2 eval {
1086   db2 close
1088   sqlite3 db2 :memory:
1094   } db2
1101   db2 close
1104   sqlite3 db2 file:test.db?mode=memory -uri 1
1108   db2 eval {
1113   db2 eval {
1129   db2 close
1132   sqlite3 db2 file:test2.db?mode=memory -uri 1
1138   } db2
1149     db2 close
1159     sqlite3 db2 test2.db -uri 1 
1166     db2 eval { 
1178   db2 close