Lines Matching refs:t2
40 CREATE TABLE t2(x,y);
41 INSERT INTO t2 VALUES(1,'x');
42 INSERT INTO t2 VALUES(2,'y');
43 SELECT * FROM t2;
49 SELECT * FROM two.t2;
54 SELECT * FROM t2;
65 SELECT * FROM t2;
67 } {1 {no such table: t2}}
70 SELECT * FROM two.t2;
72 } {1 {no such table: two.t2}}
213 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
221 UPDATE t2 SET x=x+10;
238 UPDATE db2.t2 SET x=x+10;
251 } {table t2 t2 table tx tx trigger r1 t2}
257 CREATE INDEX i2 ON t2(x);
258 SELECT * FROM t2 WHERE x>5;
265 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
268 # SELECT * FROM t2 WHERE x>5;
276 SELECT * FROM t2 WHERE x>5;
288 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
296 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
309 SELECT * FROM t2
311 } {1 {no such table: t2}}
315 SELECT * FROM t2
323 SELECT * FROM t2;
329 execsql {SELECT * FROM t2}
331 SELECT * FROM t2;
338 UPDATE t2 SET x=x+1 WHERE x=50;
341 SELECT * FROM t2;
347 execsql {SELECT * FROM t2} db2
352 catchsql {SELECT * FROM t2}
355 catchsql {SELECT * FROM t2} db2
367 catchsql {UPDATE t2 SET x=x+1 WHERE x=50}