Lines Matching refs:t3
168 CREATE TABLE t3(a,b,c);
169 INSERT INTO t3 VALUES(1+2+3,4,5);
170 SELECT * FROM t3;
175 INSERT INTO t3 VALUES((SELECT max(a) FROM t3)+1,5,6);
176 SELECT * FROM t3 ORDER BY a;
181 INSERT INTO t3 VALUES((SELECT max(a) FROM t3)+1,t3.a,6);
182 SELECT * FROM t3 ORDER BY a;
184 } {1 {no such column: t3.a}}
187 INSERT INTO t3 VALUES((SELECT b FROM t3 WHERE a=0),6,7);
188 SELECT * FROM t3 ORDER BY a;
193 SELECT b,c FROM t3 WHERE a IS NULL;
198 INSERT INTO t3 VALUES(notafunc(2,3),2,3);
203 INSERT INTO t3 VALUES(min(1,2,3),max(1,2,3),99);
204 SELECT * FROM t3 WHERE c=99;