Lines Matching refs:a1

35   CREATE TABLE a1(c, b INTEGER, a TEXT, PRIMARY KEY(a, b));
37   INSERT INTO a1 (rowid, c, b, a) VALUES(3,  '0x03', 1, 1);
38   INSERT INTO a1 (rowid, c, b, a) VALUES(14, '0x0E', 2, 2);
39   INSERT INTO a1 (rowid, c, b, a) VALUES(15, '0x0F', 3, 3);
40   INSERT INTO a1 (rowid, c, b, a) VALUES(92, '0x5C', 4, 4);
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
77   SELECT a1.rowid FROM a1, a2 
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)
102   SELECT a1.rowid FROM a1, a2 WHERE EXISTS (
103     SELECT 1 FROM a1 WHERE a=x AND b=y