Lines Matching refs:temp

26   CREATE TABLE   temp.n1(x, y); INSERT INTO temp.n1 VALUES('temp', 'n1');
27   CREATE TRIGGER temp.n3 AFTER INSERT ON n1 BEGIN SELECT 1; END;
28   CREATE INDEX   temp.n4 ON n1(x, y);
56 # object reference, then SQLite searches the main, temp and all attached
57 # databases for an object with a matching name. The temp database is
63 do_execsql_test 1.1 { SELECT * FROM n1 } {temp n1}
69 # object reference, it must be either "main", or "temp" or the
76 do_execsql_test 2.1.2 { SELECT * FROM temp.n1 } {temp n1}
87 do_execsql_test 3.2 { SELECT * FROM tEmP.n1 } {temp n1}
94 do_catchsql_test 4.1 { SELECT * FROM temp.n2 } {1 {no such table: temp.n2}}
104 #   The temp and main databases both contain triggers and indexes named
124 do_catchsql_test 6.2.1 { SELECT * FROM temp.t1 } {1 {no such table: temp.t1}}