Lines Matching refs:UNION

15 # focus of this file is testing UNION, INTERSECT and EXCEPT operators
52     UNION ALL
61       UNION ALL
72       UNION ALL
82     UNION ALL
90       UNION ALL
99       (SELECT DISTINCT log FROM t1 UNION ALL
107     UNION ALL
112 } {1 {ORDER BY clause should come after UNION ALL not before}}
119     UNION
127       (SELECT DISTINCT log FROM t1 UNION
135     UNION
140 } {1 {ORDER BY clause should come after UNION not before}}
204     SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
213       SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
224       SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
250 # Various error messages while processing UNION or INTERSECT
255     UNION ALL
264     UNION ALL
273     UNION ALL
282     UNION ALL
300     UNION ALL
309     UNION ALL
317     UNION ALL
325     UNION ALL
333     UNION ALL
341     UNION ALL
349     UNION ALL
357     UNION ALL
362 } {1 {SELECTs to the left and right of UNION ALL do not have the same number of result columns}}
366     UNION ALL
368     UNION ALL
370     UNION ALL
380     UNION
388     UNION
394 # NULLs are indistinct for the UNION operator.
395 # Make sure the UNION operator recognizes this
399     SELECT NULL UNION SELECT NULL UNION
400     SELECT 1 UNION SELECT 2 AS 'x'
406     SELECT NULL UNION ALL SELECT NULL UNION ALL
407     SELECT 1 UNION ALL SELECT 2 AS 'x'
417        SELECT NULL, 1 UNION ALL SELECT NULL, 1
424        SELECT NULL, 1 UNION ALL SELECT NULL, 1
431        SELECT 1,2  UNION ALL SELECT 1,2
468     SELECT * FROM t1 WHERE n IN (SELECT n FROM t1 UNION SELECT x FROM t2)