Lines Matching refs:main

109 } {0 main 1 temp 2 db2 3 db3 4 db4 5 db5 6 db6 7 db7 8 db8 9 db9}
127     ATTACH 'test.db' as main;
129 } {1 {database main 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}
185     DETACH main;
187 } {1 {cannot detach database main}}
208 } {0 main 1 temp}
244     SELECT * FROM main.tx;
254 } {0 main 1 temp 2 db2}
273 } {0 main 1 temp 2 db2}
319 # Even though main has a transaction, test2.db should not be locked.
407     SELECT * FROM main.t3;
433       INSERT INTO t4 VALUES('main.' || NEW.a);
435     INSERT INTO main.t3 VALUES(11,12);
436     SELECT * FROM main.t4;
438 } {main.11}
443     SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
445 } {db2.6 db2.13 main.11}
448     INSERT INTO main.t3 VALUES(15,16);
449     SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
451 } {db2.6 db2.13 main.11 main.15}
475     SELECT * FROM main.v3;