Lines Matching refs:x
25 {SELECT a, b+15, c FROM t1 WHERE d NOT IN (SELECT x FROM t2);}
26 {select a,b+?,c from t1 where d not in(select x from t2);}
48 SELECT x,$::abc(15),y,@abc,z,?99,w FROM t1 /* Trailing comment */}
49 {select x,?,y,?,z,?,w from t1;}
53 SELECT 15 IN (1,2,3,(SELECT * FROM t1),'xyz',x'abcd',22*(x+5),null);}
57 {SELECT x'abc'; -- illegal token}
66 SELECT * FROM t1 WHERE x IN (1,2,3);}
67 {select*from t1 where x in(?,?,?);}
125 CREATE TABLE t1(a,b,c,d,e,"col f",w,x,y,z);
126 CREATE TABLE t2(x,"col y");
140 {SELECT a, b+15, c FROM t1 WHERE d NOT IN (SELECT x FROM t2);}
142 {0 {SELECT a,b+?,c FROM t1 WHERE d NOT IN(SELECT x FROM t2);}}
166 SELECT x,$::abc(15),y,@abc,z,?99,w FROM t1 /* Trailing comment */}
168 {0 {SELECT x,?,y,?,z,?,w FROM t1;}}
172 SELECT 15 IN (1,2,3,(SELECT * FROM t1),'xyz',x'abcd',22*(x+5),null);}
174 {1 {(1) no such column: x}}
177 {SELECT x'abc'; -- illegal token}
179 {1 {(1) unrecognized token: "x'abc'"}}
188 SELECT * FROM t1 WHERE x IN (1,2,3);}
190 {0 {SELECT*FROM t1 WHERE x IN(?,?,?);}}
193 {SELECT a FROM t1 WHERE x IN (1,2,3) AND sqlite_version();}
195 {0 {SELECT a FROM t1 WHERE x IN(?,?,?)AND sqlite_version();}}
198 {SELECT a FROM t1 WHERE x IN (1,2,3) AND hex8();}
203 {SELECT a FROM t1 WHERE x IN (1,2,3) AND hex8('abc');}
205 {0 {SELECT a FROM t1 WHERE x IN(?,?,?)AND hex8(?);}}
208 {SELECT "a" FROM t1 WHERE "x" IN ("1","2",'3');}
210 {0 {SELECT a FROM t1 WHERE x IN(?,?,?);}}
213 {SELECT 'a' FROM t1 WHERE 'x';}
218 {SELECT [a] FROM t1 WHERE [x];}
220 {0 {SELECT a FROM t1 WHERE x;}}
223 {SELECT * FROM t1 WHERE x IN (x);}
225 {0 {SELECT*FROM t1 WHERE x IN(x);}}
228 {SELECT * FROM t1 WHERE x IN (x,a);}
230 {0 {SELECT*FROM t1 WHERE x IN(x,a);}}
233 {SELECT * FROM t1 WHERE x IN ([x],"a");}
235 {0 {SELECT*FROM t1 WHERE x IN(x,a);}}
238 {SELECT * FROM t1 WHERE x IN ([x],"a",'b',sqlite_version());}
240 {0 {SELECT*FROM t1 WHERE x IN(x,a,?,sqlite_version());}}
243 {SELECT * FROM t1 WHERE x IN (SELECT x FROM t1);}
245 {0 {SELECT*FROM t1 WHERE x IN(SELECT x FROM t1);}}
248 {SELECT * FROM t1 WHERE x IN ((SELECT x FROM t1));}
250 {0 {SELECT*FROM t1 WHERE x IN((SELECT x FROM t1));}}
258 {SELECT * FROM t1 WHERE x IN (1);}
260 {0 {SELECT*FROM t1 WHERE x IN(?,?,?);}}
263 {SELECT * FROM t1 WHERE x IN (1,2);}
265 {0 {SELECT*FROM t1 WHERE x IN(?,?,?);}}
268 {SELECT * FROM t1 WHERE x IN (1,2,3);}
270 {0 {SELECT*FROM t1 WHERE x IN(?,?,?);}}
273 {SELECT * FROM t1 WHERE x IN (1,2,3,4);}
275 {0 {SELECT*FROM t1 WHERE x IN(?,?,?);}}
278 {SELECT * FROM t1 WHERE x IN (SELECT x FROM t1);}
280 {0 {SELECT*FROM t1 WHERE x IN(SELECT x FROM t1);}}
283 {SELECT * FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (1,2,3));}
285 {0 {SELECT*FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(?,?,?));}}
288 {SELECT * FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (x));}
290 {0 {SELECT*FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(x));}}
293 {SELECT x FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (
294 SELECT x FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (
295 SELECT x FROM t1 WHERE x IN (x)))));}
297 … {SELECT x FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(SELECT x FRO…
300 {SELECT x FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (
301 SELECT x FROM t1 WHERE x IN (SELECT x FROM t1 WHERE x IN (
302 SELECT x FROM t1 WHERE x IN (1)))));}
304 …{0 {SELECT x FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(SELECT x FROM t1 WHERE x IN(SELECT x F…
307 {SELECT x FROM t1 WHERE x IN (1) UNION ALL SELECT x FROM t1 WHERE x IN (1);}
309 {0 {SELECT x FROM t1 WHERE x IN(?,?,?)UNION ALL SELECT x FROM t1 WHERE x IN(?,?,?);}}
322 {SELECT * FROM ( WITH x AS ( SELECT * FROM t1 WHERE x IN ( 1)) SELECT 10);}
324 {0 {SELECT*FROM(WITH x AS(SELECT*FROM t1 WHERE x IN(?,?,?))SELECT?);}}
332 {SELECT x FROM t1 WHERE x IS NULL;}
334 {0 {SELECT x FROM t1 WHERE x IS NULL;}}
337 {SELECT x FROM t1 WHERE x IS NOT NULL;}
339 {0 {SELECT x FROM t1 WHERE x IS NOT NULL;}}
342 {SELECT x FROM t1 WHERE x = NULL;}
344 {0 {SELECT x FROM t1 WHERE x=?;}}
347 {SELECT x FROM t1 WHERE x IN ([x] IS NOT NULL, NULL, 1, 'a', "b", x'00');}
349 {0 {SELECT x FROM t1 WHERE x IN(x IS NOT NULL,?,?,?,b,?);}}
362 {INSERT INTO t1 (x) VALUES("sl1"), (1), ("sl2"), ('i');}
364 {0 {INSERT INTO t1(x)VALUES(?),(?),(?),(?);}}
367 {UPDATE t1 SET x = "sl1" WHERE x IN (1, "sl2", 'i');}
369 {0 {UPDATE t1 SET x=?WHERE x IN(?,?,?);}}
372 {UPDATE t1 SET x = "y" WHERE x IN (1, "sl1", 'i');}
374 {0 {UPDATE t1 SET x=y WHERE x IN(?,?,?);}}
377 {DELETE FROM t1 WHERE x IN (1, "sl1", 'i');}
379 {0 {DELETE FROM t1 WHERE x IN(?,?,?);}}