Lines Matching full:t2
38 CREATE TABLE t2(x,y);
39 INSERT INTO t2 VALUES(1,'x');
40 INSERT INTO t2 VALUES(2,'y');
41 SELECT * FROM t2;
47 SELECT * FROM two.t2;
52 SELECT * FROM t2;
63 SELECT * FROM t2;
65 } {1 {no such table: t2}}
68 SELECT * FROM two.t2;
70 } {1 {no such table: two.t2}}
211 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
219 UPDATE t2 SET x=x+10;
236 UPDATE db2.t2 SET x=x+10;
249 } {table t2 t2 table tx tx trigger r1 t2}
255 CREATE INDEX i2 ON t2(x);
256 SELECT * FROM t2 WHERE x>5;
263 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
266 # SELECT * FROM t2 WHERE x>5;
274 SELECT * FROM t2 WHERE x>5;
286 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
294 } {table t2 t2 table tx tx trigger r1 t2 index i2 t2}
307 SELECT * FROM t2
309 } {1 {no such table: t2}}
313 SELECT * FROM t2
321 SELECT * FROM t2;
327 execsql {SELECT * FROM t2}
329 SELECT * FROM t2;
336 UPDATE t2 SET x=x+1 WHERE x=50;
339 SELECT * FROM t2;
345 execsql {SELECT * FROM t2} db2
350 catchsql {SELECT * FROM t2}
353 catchsql {SELECT * FROM t2} db2
365 catchsql {UPDATE t2 SET x=x+1 WHERE x=50}