Lines Matching refs:db2

38   sqlite3 db2 test2.db
39   db2 eval {
60   # db2 just RESERVES the database.  It does not obtain a write-lock until
62   db2 eval {BEGIN}
63   db2 eval {UPDATE t1 SET a = 0 WHERE 0}
74 db2 eval {COMMIT}
86   db2 eval BEGIN
87   db2 eval {UPDATE t1 SET a = 0 WHERE 0}
123   db2 eval ROLLBACK
181   sqlite3 db2 test.db
183   execsql {ATTACH 'test2.db' as file2} db2
187 lock_status 4.1.2 db2 {main unlocked temp closed file2 unlocked}
195   #    db2 -
199 lock_status 4.2.2 db2 {main unlocked temp closed file2 unlocked}
202   # The read lock held by db does not prevent db2 from reading test.db
203   execsql {SELECT * FROM t1} db2
207 lock_status 4.3.2 db2 {main unlocked temp closed file2 unlocked}
211   # to commit a write to test.db from db2
214   } db2 
218 lock_status 4.4.2 db2 {main unlocked temp closed file2 unlocked}
230   # Handle 'db2' reserves file2.
231   execsql {BEGIN} db2
232   execsql {INSERT INTO file2.t1 VALUES(1, 2)} db2
235   #    db2 - reserved(file2)
239 lock_status 4.5.2 db2 {main unlocked temp closed file2 reserved}
248   #    db2 - reserved(file2)
252 lock_status 4.6.1.2 db2 {main unlocked temp closed file2 reserved}
262 lock_status 4.6.2.2 db2 {main unlocked temp closed file2 reserved}
269   } db2 
273 lock_status 4.7.2 db2 {main reserved temp closed file2 reserved}
276   # We should still be able to read test.db from db2
277   execsql {SELECT * FROM t1} db2
281 lock_status 4.8.2 db2 {main reserved temp closed file2 reserved}
291 lock_status 4.9.2 db2 {main reserved temp closed file2 reserved}
294   # We cannot commit db2 while db is holding a read-lock
295   catchsql {COMMIT} db2
299 lock_status 4.10.2 db2 {main pending temp closed file2 reserved}
308 lock_status 4.11.2 db2 {main pending temp closed file2 reserved}
311   # Now we can commit db2
312   catchsql {COMMIT} db2
316 lock_status 4.12.2 db2 {main unlocked temp closed file2 unlocked}
325   execsql {SELECT * FROM t1} db2
329 db2 close
342     ATTACH 'test.db2' AS aux;
355 } {test.db test.db2}
366 } {test.db test.db2}