Lines Matching refs:q1

1424   CREATE TABLE q1(a TEXT, b INTEGER, c);
1428   INSERT INTO q1 VALUES(16, -87.66, NULL);
1429   INSERT INTO q1 VALUES('legible', 94, -42.47);
1430   INSERT INTO q1 VALUES('beauty', 36, NULL);
1441   1   {SELECT a FROM q1 UNION ALL SELECT d FROM q2}
1444   2   {SELECT * FROM q1 WHERE a=16 UNION ALL SELECT 'x', * FROM q2 WHERE oid=1}
1447   3   {SELECT count(*) FROM q1 UNION ALL SELECT min(e) FROM q2} 
1459   1   {SELECT a FROM q1 UNION SELECT d FROM q2}
1462   2   {SELECT * FROM q1 WHERE a=16 UNION SELECT 'x', * FROM q2 WHERE oid=1}
1465   3   {SELECT count(*) FROM q1 UNION SELECT min(e) FROM q2} 
1476   1   {SELECT a FROM q1 INTERSECT SELECT d FROM q2} {beauty legible}
1485   1   {SELECT a FROM q1 EXCEPT SELECT d FROM q2} {16}
1498   2   {SELECT * FROM q3 EXCEPT SELECT a,b FROM q1}  {beauty 2}
1523   13  {SELECT c FROM q1 UNION ALL SELECT g FROM q3} {null -42.47 null 2 2}
1524   14  {SELECT c FROM q1 UNION     SELECT g FROM q3} {null -42.47 2}
1525   15  {SELECT c FROM q1 INTERSECT SELECT g FROM q3} {}
1526   16  {SELECT c FROM q1 EXCEPT    SELECT g FROM q3} {null -42.47}