Lines Matching refs:c1

95   CREATE TABLE c1(a, b, c, d);
96   INSERT INTO c1(rowid, a, b) VALUES(1,   NULL, 1);
97   INSERT INTO c1(rowid, a, b) VALUES(2,   2, NULL);
98   INSERT INTO c1(rowid, a, b) VALUES(3,   2, 2);
99   INSERT INTO c1(rowid, a, b) VALUES(4,   3, 3);
101   INSERT INTO c1(rowid, a, b, c, d) VALUES(101, 'a', 'b', 1, 1);
102   INSERT INTO c1(rowid, a, b, c, d) VALUES(102, 'a', 'b', 1, 2);
103   INSERT INTO c1(rowid, a, b, c, d) VALUES(103, 'a', 'b', 1, 3);
104   INSERT INTO c1(rowid, a, b, c, d) VALUES(104, 'a', 'b', 2, 1);
105   INSERT INTO c1(rowid, a, b, c, d) VALUES(105, 'a', 'b', 2, 2);
106   INSERT INTO c1(rowid, a, b, c, d) VALUES(106, 'a', 'b', 2, 3);
107   INSERT INTO c1(rowid, a, b, c, d) VALUES(107, 'a', 'b', 3, 1);
108   INSERT INTO c1(rowid, a, b, c, d) VALUES(108, 'a', 'b', 3, 2);
109   INSERT INTO c1(rowid, a, b, c, d) VALUES(109, 'a', 'b', 3, 3);
115   2 { CREATE INDEX c1ab ON c1(a, b); }
116   3 { CREATE INDEX c1ba ON c1(b, a); }
118   4 { CREATE INDEX c1cd ON c1(c, d); }
119   5 { CREATE INDEX c1dc ON c1(d, c); }
124     1 "SELECT (1, 2) IN (SELECT a, b FROM c1)" {0}
125     2 "SELECT (1, 1) IN (SELECT a, b FROM c1)" {{}}
126     3 "SELECT (2, 1) IN (SELECT a, b FROM c1)" {{}}
127     4 "SELECT (2, 2) IN (SELECT a, b FROM c1)" {1}
128     5 "SELECT c, d FROM c1 WHERE (c, d) IN (SELECT d, c FROM c1)"
131     6 "SELECT c, d FROM c1 WHERE (c,d) IN (SELECT d, c FROM c1) ORDER BY c DESC"
135         SELECT c, d FROM c1 WHERE (c,d) IN (SELECT d, c FROM c1) 
140         SELECT c, d FROM c1 WHERE (c,d) IN (SELECT d, c FROM c1) 
145         SELECT c, d FROM c1 WHERE (c,d) IN (SELECT d, c FROM c1) 
149         SELECT c, d FROM c1 WHERE (c,d) IN (SELECT d, c FROM c1)