Lines Matching refs:db2
36 sqlite db2 test2.db
42 } db2
88 ATTACH 'test.db' AS db2;
107 } {0 main 1 temp 2 db2 3 db3 4 db4 5 db5 6 db6 7 db7 8 db8 9 db9}
110 ATTACH 'test.db' as db2;
112 } {1 {database db2 is already in use}}
154 } {0 main 1 temp 2 db2 3 db3 4 db4 5 db11 6 db6 7 db7 8 db8 9 db9 10 db10}
201 DETACH db2;
215 } db2;
221 } db2;
231 ATTACH 'test2.db' AS db2;
236 UPDATE db2.t2 SET x=x+10;
237 SELECT * FROM db2.tx;
247 SELECT type, name, tbl_name FROM db2.sqlite_master;
252 } {0 main 1 temp 2 db2}
257 } db2
262 } db2
271 } {0 main 1 temp 2 db2}
284 SELECT type, name, tbl_name FROM db2.sqlite_master;
291 ATTACH 'test2.db' AS db2;
292 SELECT type, name, tbl_name FROM db2.sqlite_master;
298 db2 close
300 sqlite db2 test2.db
312 ATTACH DATABASE 'test2.db' AS db2;
322 } db2;
325 # Reading from db2 should not lock test2.db
330 } db2;
333 # Making a change to db2 causes test2.ddb to become locked.
340 } db2;
345 execsql {SELECT * FROM t2} db2
349 execsql BEGIN db2
353 catchsql {SELECT * FROM t2} db2
373 execsql COMMIT db2
379 execsql {DETACH db2}
380 db2 close
381 sqlite db2 test2.db
387 } db2;
399 ATTACH DATABASE 'test2.db' AS db2;
400 SELECT * FROM db2.t3;
410 INSERT INTO db2.t3 VALUES(9,10);
411 SELECT * FROM db2.t3;
416 DETACH db2;
421 INSERT INTO t4 VALUES('db2.' || NEW.x);
425 } db2
426 } {db2.6}
439 ATTACH DATABASE 'test2.db' AS db2;
440 INSERT INTO db2.t3 VALUES(13,14);
441 SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
443 } {db2.6 db2.13 main.11}
447 SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
449 } {db2.6 db2.13 main.11 main.15}
452 DETACH DATABASE db2;
457 } db2
467 ATTACH DATABASE 'test2.db' AS db2;
468 SELECT * FROM db2.v3;
482 db2 close
484 sqlite db2 test2.db
490 } db2
498 } db2
506 } db2
514 } db2
521 } db2
528 } db2
535 } db2
542 } db2
549 } db2
556 } db2