Lines Matching refs:w2

1561   CREATE TABLE w2(a, b TEXT);
1564   INSERT INTO w2 VALUES(1, 4.1);
1568   1  { SELECT a FROM w1 UNION SELECT a FROM w2 } {1 1}
1569   2  { SELECT a FROM w2 UNION SELECT a FROM w1 } {1 1}
1570   3  { SELECT b FROM w1 UNION SELECT b FROM w2 } {4.1 4.1}
1571   4  { SELECT b FROM w2 UNION SELECT b FROM w1 } {4.1 4.1}
1573   5  { SELECT a FROM w1 INTERSECT SELECT a FROM w2 } {}
1574   6  { SELECT a FROM w2 INTERSECT SELECT a FROM w1 } {}
1575   7  { SELECT b FROM w1 INTERSECT SELECT b FROM w2 } {}
1576   8  { SELECT b FROM w2 INTERSECT SELECT b FROM w1 } {}
1578   9  { SELECT a FROM w1 EXCEPT SELECT a FROM w2 } {1}
1579   10 { SELECT a FROM w2 EXCEPT SELECT a FROM w1 } {1}
1580   11 { SELECT b FROM w1 EXCEPT SELECT b FROM w2 } {4.1}
1581   12 { SELECT b FROM w2 EXCEPT SELECT b FROM w1 } {4.1}