Lines Matching refs:db2
38 sqlite db2 test2.db
44 } db2
90 ATTACH 'test.db' AS db2;
109 } {0 main 1 temp 2 db2 3 db3 4 db4 5 db5 6 db6 7 db7 8 db8 9 db9}
112 ATTACH 'test.db' as db2;
114 } {1 {database db2 is already in use}}
156 } {0 main 1 temp 2 db2 3 db3 4 db4 5 db11 6 db6 7 db7 8 db8 9 db9 10 db10}
203 DETACH db2;
217 } db2;
223 } db2;
233 ATTACH 'test2.db' AS db2;
238 UPDATE db2.t2 SET x=x+10;
239 SELECT * FROM db2.tx;
249 SELECT type, name, tbl_name FROM db2.sqlite_master;
254 } {0 main 1 temp 2 db2}
259 } db2
264 } db2
273 } {0 main 1 temp 2 db2}
286 SELECT type, name, tbl_name FROM db2.sqlite_master;
293 ATTACH 'test2.db' AS db2;
294 SELECT type, name, tbl_name FROM db2.sqlite_master;
300 db2 close
302 sqlite db2 test2.db
314 ATTACH DATABASE 'test2.db' AS db2;
324 } db2;
327 # Reading from db2 should not lock test2.db
332 } db2;
335 # Making a change to db2 causes test2.ddb to become locked.
342 } db2;
347 execsql {SELECT * FROM t2} db2
351 execsql BEGIN db2
355 catchsql {SELECT * FROM t2} db2
375 execsql COMMIT db2
381 execsql {DETACH db2}
382 db2 close
383 sqlite db2 test2.db
389 } db2;
401 ATTACH DATABASE 'test2.db' AS db2;
402 SELECT * FROM db2.t3;
412 INSERT INTO db2.t3 VALUES(9,10);
413 SELECT * FROM db2.t3;
418 DETACH db2;
423 INSERT INTO t4 VALUES('db2.' || NEW.x);
427 } db2
428 } {db2.6}
441 ATTACH DATABASE 'test2.db' AS db2;
442 INSERT INTO db2.t3 VALUES(13,14);
443 SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
445 } {db2.6 db2.13 main.11}
449 SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
451 } {db2.6 db2.13 main.11 main.15}
454 DETACH DATABASE db2;
459 } db2
469 ATTACH DATABASE 'test2.db' AS db2;
470 SELECT * FROM db2.v3;
484 db2 close
486 sqlite db2 test2.db
492 } db2
500 } db2
508 } db2
516 } db2
523 } db2
530 } db2
537 } db2
544 } db2
551 } db2
558 } db2