Lines Matching refs:t3
166 CREATE TABLE t3(a,b,c);
167 INSERT INTO t3 VALUES(1+2+3,4,5);
168 SELECT * FROM t3;
173 INSERT INTO t3 VALUES((SELECT max(a) FROM t3)+1,5,6);
174 SELECT * FROM t3 ORDER BY a;
179 INSERT INTO t3 VALUES((SELECT max(a) FROM t3)+1,t3.a,6);
180 SELECT * FROM t3 ORDER BY a;
182 } {1 {no such column: t3.a}}
185 INSERT INTO t3 VALUES((SELECT b FROM t3 WHERE a=0),6,7);
186 SELECT * FROM t3 ORDER BY a;
191 SELECT b,c FROM t3 WHERE a IS NULL;
196 INSERT INTO t3 VALUES(notafunc(2,3),2,3);
201 INSERT INTO t3 VALUES(min(1,2,3),max(1,2,3),99);
202 SELECT * FROM t3 WHERE c=99;