Lines Matching refs:j
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);
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);