Lines Matching refs:y

42   CREATE TABLE a2(x BLOB, y BLOB);
43   INSERT INTO a2(x, y) VALUES(1, 1);
44   INSERT INTO a2(x, y) VALUES(2, '2');
45   INSERT INTO a2(x, y) VALUES('3', 3);
46   INSERT INTO a2(x, y) VALUES('4', '4');
50   SELECT x, typeof(x), y, typeof(y) FROM a2 ORDER BY rowid
59   SELECT (SELECT rowid FROM a1 WHERE a=x AND b=y) FROM a2
62   SELECT (SELECT rowid FROM a1 WHERE (a, b) = (x, y)) FROM a2
66   SELECT a1.rowid FROM a1, a2 WHERE a=x AND b=y;
69   SELECT a1.rowid FROM a1, a2 WHERE (a, b) = (x, y)
74   SELECT a1.rowid FROM a1, a2 WHERE coalesce(NULL,x)=a AND coalesce(NULL,y)=b
78   WHERE (coalesce(NULL,x), coalesce(NULL,y)) = (a, b)
82   SELECT a1.rowid FROM a1, a2 WHERE +x=a AND +y=b
85   SELECT a1.rowid FROM a1, a2 WHERE (+x, +y) = (a, b)
89   SELECT (SELECT rowid FROM a1 WHERE a=+x AND b=+y) FROM a2
92   SELECT (SELECT rowid FROM a1 WHERE (a, b) = (+x, +y)) FROM a2
95   SELECT (SELECT rowid FROM a1 WHERE (+x, +y) = (a, b)) FROM a2
99   SELECT a1.rowid FROM a1 WHERE (a, b) IN (SELECT x, y FROM a2)
103     SELECT 1 FROM a1 WHERE a=x AND b=y
126   CREATE TABLE c2(x BLOB, y BLOB);
130   SELECT * FROM c1 WHERE (a, b) IN (SELECT x, y FROM c2)
134   SELECT * FROM c1 WHERE (a, b) IN (SELECT x, y FROM c2)
137   SELECT * FROM c1 WHERE (a, +b) IN (SELECT x, y FROM c2)
141   SELECT c1.rowid FROM c1 WHERE b = (SELECT y FROM c2);
144   SELECT c1.rowid FROM c1 WHERE (a, b) = (SELECT x, y FROM c2);
152   CREATE TABLE d2(x BLOB, y BLOB);
174     CREATE INDEX idx1 ON d2(x, y);
179     CREATE UNIQUE INDEX idx2 ON d2(x, y) ;
194     SELECT rowid FROM d1 WHERE (a, c) IN (SELECT x, y FROM d2);
198     SELECT rowid FROM d1 WHERE (c, a) IN (SELECT x, y FROM d2);
202     SELECT rowid FROM d1 WHERE (+c, a) IN (SELECT x, y FROM d2);
207       SELECT x, y FROM d2 WHERE d2.rowid=d1.rowid
212     SELECT d1.rowid FROM d1, d2 WHERE a = y;
217       SELECT y FROM d2 where d2.rowid=d1.rowid
224   CREATE TABLE e2(x BLOB, y BLOB);
236   SELECT rowid FROM e1 WHERE (a, c) IN (SELECT x, y FROM e2);
275   CREATE TABLE g2(x, y);
283   SELECT * FROM g2 WHERE (x, y) IN (
289   SELECT * FROM g2 WHERE (x, y) IN (
295   SELECT * FROM g2 WHERE (x, y) IN (