Lines Matching refs:db2
32 sqlite3 db2 test.db
40 catchsql { INSERT INTO t1 VALUES(3, 4) } db2
44 db2 unlock_notify {
45 set zScript "db2 eval { INSERT INTO t1 VALUES(3, 4) }"
71 catchsql { INSERT INTO t1 VALUES(3, 4) } db2
75 db2 unlock_notify {
76 set zScript "db2 eval { INSERT INTO t1 VALUES(3, 4) }"
84 db2 unlock_notify
104 # 1. Grab a write-lock on t1 with [db]. Then grab a read-lock on t2 with [db2].
105 # 2. Try to grab a read-lock on t1 with [db2] (fails).
106 # 3. Have [db2] wait on the read-lock it failed to obtain in step 2.
109 # would be deadlocked (since [db2] is already waiting on [db], and this
110 # operation would have [db] wait on [db2]).
120 } db2
123 catchsql { SELECT * FROM t1 } db2
126 db2 unlock_notify {lappend unlock_notify db2}
138 # connections: db, db2 and db3.
142 db2 close
144 foreach con {db db2 db3} {
157 execsql { BEGIN ; INSERT INTO t2 VALUES(1, 2) } db2
164 catchsql { SELECT * FROM t3 } db2
172 db2 unlock_notify {lappend lUnlock db2}
187 execsql { COMMIT } db2
193 } {db3 db db2}
195 catch { db2 close }
298 foreach conn {db db2 db3} {
309 } db2
331 execsql { COMMIT } db2
339 } db2
365 execsql { COMMIT } db2
372 db2 close
383 foreach conn {db db2 db3} {
392 catchsql { SELECT * FROM t1 } db2
399 db2 unlock_notify unlock_notify
419 catchsql { SELECT * FROM t1 } db2
422 sqlite3_extended_errcode db2
430 catchsql { SELECT * FROM t1 } db2
433 sqlite3_extended_errcode db2
448 } db2
463 execsql { COMMIT } db2
474 } db2
493 execsql { COMMIT } db2
497 db2 close