Lines Matching refs:t4
185 CREATE TABLE t4(x,y);
186 INSERT INTO t4 VALUES(1,11);
187 INSERT INTO t4 VALUES(2,NULL);
188 SELECT x FROM t4 WHERE y=NULL;
193 SELECT x FROM t4 WHERE y IN (33,NULL);
198 SELECT x FROM t4 WHERE y<33 ORDER BY x;
203 SELECT x FROM t4 WHERE y>6 ORDER BY x;
208 SELECT x FROM t4 WHERE y!=33 ORDER BY x;
213 CREATE INDEX t4i1 ON t4(y);
214 SELECT x FROM t4 WHERE y=NULL;
219 SELECT x FROM t4 WHERE y IN (33,NULL);
224 SELECT x FROM t4 WHERE y<33 ORDER BY x;
229 SELECT x FROM t4 WHERE y>6 ORDER BY x;
234 SELECT x FROM t4 WHERE y!=33 ORDER BY x;