Lines Matching refs:db2

26   sqlite3 db2 ./tempdir/../tempdir/t1/.//t2/../../..//test.db
33   execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name} db2
42   } db2
51 #   catchsql {SELECT * FROM t1} db2
54   catchsql {SELECT * FROM t1} db2
57   execsql {UPDATE t1 SET a=b, b=a} db2
58   execsql {SELECT * FROM t1} db2
69   catchsql {SELECT * FROM t1} db2
82   catchsql {SELECT * FROM t2} db2
85   catchsql {SELECT * FROM t1} db2
88   catchsql {SELECT * FROM t2} db2
151       set r [catch {db2 eval {SELECT a FROM t1}} msg]
166   execsql {BEGIN TRANSACTION} db2
167   set r [catch {execsql {UPDATE t1 SET a = 0 WHERE 0} db2} msg]
168   execsql {ROLLBACK} db2
175   catchsql {SELECT * FROM t2} db2
188   db2 busy callback
189   # db2 does not hold a lock so we should get a busy callback here
190   set r [catch {execsql {UPDATE t1 SET a=b, b=a} db2} msg]
196   execsql {BEGIN; SELECT rowid FROM sqlite_master LIMIT 1} db2
197   # This time db2 does hold a read lock.  No busy callback this time.
198   set r [catch {execsql {UPDATE t1 SET a=b, b=a} db2} msg]
202 catch {execsql {ROLLBACK} db2}
209   db2 busy callback
210   # We get a busy callback because db2 is not holding a lock
211   set r [catch {execsql {UPDATE t1 SET a=b, b=a} db2} msg]
221   db2 busy callback
222   execsql {BEGIN; SELECT rowid FROM sqlite_master LIMIT 1} db2
224   set r [catch {execsql {UPDATE t1 SET a=b, b=a} db2} msg]
228 catch {execsql {ROLLBACK} db2}
235   db2 busy callback
236   set r [catch {execsql {SELECT * FROM t1} db2} msg]
248   db2 timeout 400
251   catchsql {BEGIN EXCLUSIVE;} db2
254   db2 eval {PRAGMA busy_timeout}
257   db2 timeout 0
261   db2 eval {PRAGMA busy_timeout}
265   db2 eval {PRAGMA busy_timeout(400)}
268   catchsql {BEGIN EXCLUSIVE;} db2
271   db2 eval {PRAGMA busy_timeout}
274   db2 eval {PRAGMA busy_timeout(0)}
278   db2 eval {PRAGMA busy_timeout}
297   db2 close
301   sqlite3 db2 ./test.db
302   catchsql {UPDATE t1 SET a=0} db2
306   set rc [catch {db2 eval {UPDATE t1 SET a=0}} msg]
314   db2 busy callback
315   set rc [catch {db2 eval {UPDATE t1 SET a=0}} msg]
326   db2 eval $sql
391   execsql { SELECT * FROM sqlite_master } db2
392   execsql { SELECT * FROM t4 } db2
404   execsql { SELECT * FROM t4 } db2
408   execsql { SELECT a FROM t4 ORDER BY a } db2
412   execsql { PRAGMA integrity_check } db2
450   rename db2 {}