Lines Matching refs:t4
183 CREATE TABLE t4(x,y);
184 INSERT INTO t4 VALUES(1,11);
185 INSERT INTO t4 VALUES(2,NULL);
186 SELECT x FROM t4 WHERE y=NULL;
191 SELECT x FROM t4 WHERE y IN (33,NULL);
196 SELECT x FROM t4 WHERE y<33 ORDER BY x;
201 SELECT x FROM t4 WHERE y>6 ORDER BY x;
206 SELECT x FROM t4 WHERE y!=33 ORDER BY x;
211 CREATE INDEX t4i1 ON t4(y);
212 SELECT x FROM t4 WHERE y=NULL;
217 SELECT x FROM t4 WHERE y IN (33,NULL);
222 SELECT x FROM t4 WHERE y<33 ORDER BY x;
227 SELECT x FROM t4 WHERE y>6 ORDER BY x;
232 SELECT x FROM t4 WHERE y!=33 ORDER BY x;