Lines Matching refs:z1

48   CREATE TABLE z1(x, y, z);
51   INSERT INTO z1 VALUES('a', 'b', 'c');
52   INSERT INTO z1 VALUES('d', 'e', 'f');
53   INSERT INTO z1 VALUES('g', 'h', 'i');
63   2 { CREATE INDEX z1idx ON z1(x, y) }
64   3 { CREATE UNIQUE INDEX z1idx ON z1(x, y) }
71     SELECT * FROM z1 WHERE x IN (SELECT a FROM kk)
75     SELECT * FROM z1 WHERE (x,y) IN (SELECT a, b FROM kk)
79     SELECT * FROM z1 WHERE (x, +y) IN (SELECT a, b FROM kk)
83     SELECT * FROM z1 WHERE (x, +y) IN (SELECT a, b||'x' FROM kk)
87     SELECT * FROM z1 WHERE (+x, y) IN (SELECT a, b FROM kk)