Lines Matching refs:UNION
17269 #define SQLITE_FlttnUnionAll 0x00800000 /* Disable the UNION ALL flattener */
18958 #define SRT_Except 2 /* Remove result from a UNION index */
31678 const char *zOp = "UNION";
31680 case TK_ALL: zOp = "UNION ALL"; break;
91067 /*** INSERT STACK UNION HERE ***/
139818 case TK_ALL: z = "UNION ALL"; break;
139821 default: z = "UNION"; break;
140650 ** redefined. The UNION ALL operator uses this property to force
140771 ** <recursive-table> AS (<setup-query> UNION [ALL] <recursive-query>)
140787 ** If the compound query operator is UNION then no duplicate rows are ever
140790 ** discarded. If the operator is UNION ALL, then duplicates are allowed.
140818 int iDistinct = 0; /* To ensure unique results if UNION */
140890 ** functions. Mark the recursive elements as UNION ALL even if they
140891 ** are really UNION because the distinctness will be enforced by the
140971 ** (2) All terms are UNION ALL
141023 ** two or more separate queries using UNION, UNION ALL, EXCEPT, or
141035 ** SELECT a FROM t1 UNION SELECT b FROM t2 UNION SELECT c FROM t3
141130 SELECTTRACE(1, pParse, p, ("multiSelect UNION ALL left...\n"));
141147 ExplainQueryPlan((pParse, 1, "UNION ALL"));
141148 SELECTTRACE(1, pParse, p, ("multiSelect UNION ALL right...\n"));
141201 SELECTTRACE(1, pParse, p, ("multiSelect EXCEPT/UNION left...\n"));
141221 SELECTTRACE(1, pParse, p, ("multiSelect EXCEPT/UNION right...\n"));
141455 /* Suppress duplicates for UNION, EXCEPT, and INTERSECT
141568 ** <operator> is one of UNION ALL, UNION, EXCEPT, or INTERSECT. The idea
141578 ** of the compound query. (Only generated for UNION and
141579 ** UNION ALL. EXCEPT and INSERTSECT never output a row that
141596 ** UNION ALL UNION EXCEPT INTERSECT
141613 ** Duplicate removal in the UNION, EXCEPT, and INTERSECT cases is handled
141625 ** outB: output one row of B (UNION and UNION ALL only)
141705 /* For operators other than UNION ALL we have to make sure that
141752 ** operator is UNION, EXCEPT, or INTERSECT (but not UNION ALL).
142393 ** (17a) all compound operators must be a UNION ALL, and
142411 ** operator other than UNION ALL because all the other compound
142483 Select *pParent; /* Current UNION ALL term of the other query */
142578 ** use only the UNION ALL operator. And none of the simple select queries
142669 ** 17 and 18 above) it must be a UNION ALL and the parent query must
142677 ** using UNION ALL operators. In this case N is the number of simple
142684 ** UNION ALL
142686 ** UNION ALL
142693 ** UNION ALL
142695 ** UNION ALL
143255 ** FROM (SELECT 1 AS a1 UNION ALL SELECT 2) AS aa
143256 ** JOIN (SELECT 1 AS b2 UNION ALL SELECT 2) AS bb ON (a1=b2)
143257 ** LEFT JOIN (SELECT 8 AS c3 UNION ALL SELECT 9) AS cc ON (b2=2);
143282 ** (8) The subquery may not be a compound that uses UNION, INTERSECT,
143536 ** This transformation is only needed for EXCEPT, INTERSECT, and UNION.
143537 ** The UNION ALL operator works fine with multiSelectOrderBy() even when
143733 int bMayRecursive; /* True if compound joined by UNION [ALL] */
144774 ** SELECT count(*) FROM (SELECT x FROM t1 UNION ALL SELECT y FROM t2)
144782 ** * The subquery is a UNION ALL of two or more terms
144810 if( pSub->op!=TK_ALL && pSub->pPrior ) return 0; /* Must be UNION ALL */
167588 0, /* UNION => nothing */
167861 /* 134 */ "UNION",
168142 /* 89 */ "multiselect_op ::= UNION",
168143 /* 90 */ "multiselect_op ::= UNION ALL",
169053 242, /* (89) multiselect_op ::= UNION */
169054 242, /* (90) multiselect_op ::= UNION ALL */
169463 -1, /* (89) multiselect_op ::= UNION */
169464 -2, /* (90) multiselect_op ::= UNION ALL */
170161 case 89: /* multiselect_op ::= UNION */
170165 case 90: /* multiselect_op ::= UNION ALL */
172017 ** 28: LIKE UNION VIRTUAL REFERENCES
172278 testcase( i==137 ); /* UNION */
190216 /* 27 */ "SELECT ? UNION SELECT level / (1024 * ?) FROM %Q.'%q_segdir'",
211220 "UNION ALL "
214958 " UNION ALL "
216536 "SELECT 0, 'tbl', '', 0, '', 1 UNION ALL "
216537 "SELECT 1, 'idx', '', 0, '', 2 UNION ALL "