Lines Matching refs:n1
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);
30 CREATE TABLE main.n1(x, y); INSERT INTO main.n1 VALUES('main', 'n1');
35 CREATE TABLE at1.n1(x, y); INSERT INTO at1.n1 VALUES('at1', 'n1');
39 CREATE TABLE at2.n1(x, y); INSERT INTO at2.n1 VALUES('at2', 'n1');
63 do_execsql_test 1.1 { SELECT * FROM n1 } {temp n1}
75 do_execsql_test 2.1.1 { SELECT * FROM main.n1 } {main n1}
76 do_execsql_test 2.1.2 { SELECT * FROM temp.n1 } {temp n1}
77 do_execsql_test 2.1.3 { SELECT * FROM at1.n1 } {at1 n1}
78 do_execsql_test 2.1.4 { SELECT * FROM at2.n1 } {at2 n1}
80 do_catchsql_test 2.2 { SELECT * FROM xxx.n1 } {1 {no such table: xxx.n1}}
86 do_execsql_test 3.1 { SELECT * FROM MAIN.n1 } {main n1}
87 do_execsql_test 3.2 { SELECT * FROM tEmP.n1 } {temp n1}
88 do_execsql_test 3.3 { SELECT * FROM aT1.n1 } {at1 n1}
89 do_execsql_test 3.4 { SELECT * FROM At2.n1 } {at2 n1}