Lines Matching refs:v2

118   CREATE TABLE t2(k2 INTEGER PRIMARY KEY, v2);
128   SELECT v2 FROM t1 LEFT JOIN t2 USING (k2) LEFT JOIN t3_1 USING (k3);
136   SELECT v2 FROM t1 LEFT JOIN t2 USING (k2) LEFT JOIN t3_2 USING (k3);
149   CREATE TABLE c2(k INTEGER PRIMARY KEY, v2);
161   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
176   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
196   CREATE TABLE c2(k UNIQUE, v2);
208   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
223   SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
349   CREATE VIEW v2(ccc) AS SELECT bbb IS 1234 FROM t2;
350   SELECT ccc, ccc IS NULL AS ddd FROM t1 LEFT JOIN v2;
354   SELECT ccc, ccc IS NULL AS ddd FROM t1 LEFT JOIN v2;