Lines Matching refs:db2
40 sqlite3 db2 test2.db
46 } db2
111 ATTACH 'test.db' AS db2;
131 } {0 main 2 db2 3 db3 4 db4 5 db5 6 db6 7 db7 8 db8 9 db9}
135 ATTACH 'test.db' as db2;
137 } {1 {database db2 is already in use}}
188 } {0 main 2 db2 3 db3 4 db4 5 db6 6 db7 7 db8 8 db9 9 db10 10 db11}
255 DETACH db2;
278 } db2;
284 } db2;
294 ATTACH 'test2.db' AS db2;
299 UPDATE db2.t2 SET x=x+10;
300 SELECT * FROM db2.tx;
310 SELECT type, name, tbl_name FROM db2.sqlite_master;
317 } {0 main 1 temp 2 db2}
322 } {0 main 2 db2}
329 } db2
334 } db2
345 } {0 main 1 temp 2 db2}
349 } {0 main 2 db2}
364 SELECT type, name, tbl_name FROM db2.sqlite_master;
371 ATTACH 'test2.db' AS db2;
372 SELECT type, name, tbl_name FROM db2.sqlite_master;
379 db2 close
381 sqlite3 db2 test2.db
391 db2 eval {
411 ATTACH DATABASE 'test2.db' AS db2;
417 # a lock on test2.db so 'db2' should be readable.
422 } db2;
426 # prevent test2.db from being read by db2.
431 } db2;
435 # a reserved lock. It should still be accessible through db2.
442 } db2;
447 execsql {SELECT * FROM t2} db2
450 # Start transactions on both db and db2. Once again, just because
451 # we make a change to test2.db using db2, only a RESERVED lock is
456 execsql BEGIN db2
457 execsql {UPDATE t2 SET x=0 WHERE 0} db2
461 # It is also still accessible from db2.
463 catchsql {SELECT * FROM t2} db2
477 # db2 has a RESERVED lock on test2.db, so db cannot write to any tables
487 # db is able to reread its schema because db2 still only holds a
493 execsql COMMIT db2
499 execsql {DETACH db2}
500 db2 close
501 sqlite3 db2 test2.db
507 } db2;
519 ATTACH DATABASE 'test2.db' AS db2;
520 SELECT * FROM db2.t3;
530 INSERT INTO db2.t3 VALUES(9,10);
531 SELECT * FROM db2.t3;
535 DETACH db2;
542 INSERT INTO t4 VALUES('db2.' || NEW.x);
546 } db2
547 } {db2.6}
566 INSERT INTO t4 VALUES('db2.6');
567 INSERT INTO t4 VALUES('db2.13');
568 } db2
578 # the schema for both main and db2 is valid before starting to execute
587 ATTACH DATABASE 'test2.db' AS db2;
588 INSERT INTO db2.t3 VALUES(13,14);
589 SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
591 } {db2.6 db2.13 main.11}
597 SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
599 } {db2.6 db2.13 main.11 main.15}
605 ATTACH DATABASE 'test2.db' AS db2;
606 INSERT INTO db2.t3 VALUES(13,14);
614 DETACH DATABASE db2;
619 } db2
629 ATTACH DATABASE 'test2.db' AS db2;
630 SELECT * FROM db2.v3;
646 db2 close
648 sqlite3 db2 test2.db
654 } db2
662 } db2
670 } db2
679 } db2
688 } db2
695 } db2
702 } db2
709 } db2
716 } db2
723 } db2
729 catch {db2 close}
743 sqlite3 db2 :memory:
744 db2 eval {
824 sqlite3 db2 test2.db
825 db2 eval {CREATE TABLE t1(x); BEGIN EXCLUSIVE}
833 db2 close
904 ATTACH ':memory:' AS db2;
905 CREATE TABLE db2.Table2(col1 INTEGER, col2 INTEGER, col3 INTEGER, col4);
906 CREATE UNIQUE INDEX db2.idx_col1_unique ON Table2 (col1);
907 CREATE UNIQUE INDEX db2.idx_col23_unique ON Table2 (col2, col3);
908 CREATE INDEX db2.idx_col2 ON Table2 (col2);