Lines Matching refs:t

22   CREATE TABLE t(i,j,k,m,n);
23   CREATE INDEX ijk ON t(i,j,k);
24   CREATE INDEX jmn ON t(j,m,n);
26   INSERT INTO t VALUES(3, 3, 'three', 3, 'tres');
27   INSERT INTO t VALUES(2, 2, 'two', 2, 'dos');
28   INSERT INTO t VALUES(1, 1, 'one', 1, 'uno');
29   INSERT INTO t VALUES(4, 4, 'four', 4, 'cuatro');
33   SELECT k FROM t WHERE (i=1 AND j=1) OR (i=2 AND j=2);
36   SELECT k FROM t WHERE (i=1 AND j=1) OR (+i=2 AND j=2);
39   SELECT n FROM t WHERE (i=1 AND j=1) OR (i=2 AND j=2);
42   SELECT k, n FROM t WHERE (i=1 AND j=1) OR (i=2 AND j=2);
45   SELECT k FROM t WHERE (i=1 AND j=1) OR (i=2 AND j=2) OR (i=3 AND j=3);
48   SELECT n FROM t WHERE (i=1 AND j=1) OR (i=2 AND j=2) OR (i=3 AND j=3);
51   SELECT k FROM t WHERE (i=1 AND j=1) OR (j=2 AND m=2);
54   SELECT k FROM t WHERE (i=1 AND j=1) OR (i=2 AND j=2) OR (j=3 AND m=3);
57   SELECT n FROM t WHERE (i=1 AND j=1) OR (i=2 AND j=2) OR (j=3 AND m=3);
60   SELECT k FROM t WHERE (i=1 AND j=1) OR (j=2 AND m=2) OR (i=3 AND j=3);
63   SELECT n FROM t WHERE (i=1 AND j=1) OR (j=2 AND m=2) OR (i=3 AND j=3);
66   SELECT k FROM t WHERE (j=1 AND m=1) OR (i=2 AND j=2) OR (i=3 AND j=3);
69   SELECT k FROM t WHERE (i=1 AND j=1) OR (j=2 AND i=2) OR (i=3 AND j=3);
72   SELECT k FROM t WHERE (i=1 AND j=2) OR (i=2 AND j=1) OR (i=3 AND j=4);
75   SELECT k FROM t WHERE (i=1 AND (j=1 or j=2)) OR (i=3 AND j=3);
223   DROP TABLE IF EXISTS t;
224   CREATE TABLE t(c0,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17);
225   CREATE INDEX tc0 ON t(c0);
226   CREATE INDEX tc1 ON t(c1);
227   CREATE INDEX tc2 ON t(c2);
228   CREATE INDEX tc3 ON t(c3);
229   CREATE INDEX tc4 ON t(c4);
230   CREATE INDEX tc5 ON t(c5);
231   CREATE INDEX tc6 ON t(c6);
232   CREATE INDEX tc7 ON t(c7);
233   CREATE INDEX tc8 ON t(c8);
234   CREATE INDEX tc9 ON t(c9);
235   CREATE INDEX tc10 ON t(c10);
236   CREATE INDEX tc11 ON t(c11);
237   CREATE INDEX tc12 ON t(c12);
238   CREATE INDEX tc13 ON t(c13);
239   CREATE INDEX tc14 ON t(c14);
240   CREATE INDEX tc15 ON t(c15);
241   CREATE INDEX tc16 ON t(c16);
242   CREATE INDEX tc17 ON t(c17);
244   INSERT INTO t(c0, c16) VALUES (1,1);
246   SELECT * FROM t WHERE
254   DELETE FROM t;
255   INSERT INTO t(c0,c17) VALUES(1,1);
256   SELECT * FROM t WHERE
264   DELETE FROM t;
265   INSERT INTO t(c0,c15) VALUES(1,1);
266   SELECT * FROM t WHERE