Lines Matching refs:x

24     CREATE TABLE t1(x TEXT);
25 CREATE TABLE t2(x INTEGER);
26 CREATE TABLE t3(x INTEGER PRIMARY KEY);
34 SELECT * FROM t1 WHERE x<0
39 SELECT * FROM t1 WHERE x<=0
44 SELECT * FROM t1 WHERE x=0
49 SELECT * FROM t1 WHERE x>=0
54 SELECT * FROM t1 WHERE x>0
59 SELECT * FROM t1 WHERE x<>0
64 SELECT * FROM t1 WHERE x<NULL
69 SELECT * FROM t1 WHERE x<=NULL
74 SELECT * FROM t1 WHERE x=NULL
79 SELECT * FROM t1 WHERE x>=NULL
84 SELECT * FROM t1 WHERE x>NULL
89 SELECT * FROM t1 WHERE x!=NULL
94 SELECT * FROM t1 WHERE x IS NULL
99 SELECT * FROM t1 WHERE x IS NOT NULL
106 SELECT * FROM t2 WHERE x<0
111 SELECT * FROM t2 WHERE x<=0
116 SELECT * FROM t2 WHERE x=0
121 SELECT * FROM t2 WHERE x>=0
126 SELECT * FROM t2 WHERE x>0
131 SELECT * FROM t2 WHERE x<>0
136 SELECT * FROM t2 WHERE x<NULL
141 SELECT * FROM t2 WHERE x<=NULL
146 SELECT * FROM t2 WHERE x=NULL
151 SELECT * FROM t2 WHERE x>=NULL
156 SELECT * FROM t2 WHERE x>NULL
161 SELECT * FROM t2 WHERE x!=NULL
166 SELECT * FROM t2 WHERE x IS NULL
171 SELECT * FROM t2 WHERE x IS NOT NULL
178 SELECT * FROM t3 WHERE x<0
183 SELECT * FROM t3 WHERE x<=0
188 SELECT * FROM t3 WHERE x=0
193 SELECT * FROM t3 WHERE x>=0
198 SELECT * FROM t3 WHERE x>0
203 SELECT * FROM t3 WHERE x<>0
208 SELECT * FROM t3 WHERE x<NULL
213 SELECT * FROM t3 WHERE x<=NULL
218 SELECT * FROM t3 WHERE x=NULL
223 SELECT * FROM t3 WHERE x>=NULL
228 SELECT * FROM t3 WHERE x>NULL
233 SELECT * FROM t3 WHERE x!=NULL
238 SELECT * FROM t3 WHERE x IS NULL
243 SELECT * FROM t3 WHERE x IS NOT NULL
249 SELECT x<NULL FROM t3
254 SELECT x<=NULL FROM t3
259 SELECT x==NULL FROM t3
264 SELECT x>NULL FROM t3
269 SELECT x>=NULL FROM t3
274 SELECT x!=NULL FROM t3
279 SELECT x IS NULL FROM t3
284 SELECT x IS NOT NULL FROM t3