Lines Matching refs:ALL
18665 #define SF_All 0x0000002 /* Includes the ALL keyword */
30022 case TK_ALL: zOp = "UNION ALL"; break;
49905 pcacheTrace(("%p.CLEAN-ALL\n",pCache));
132554 case TK_ALL: z = "UNION ALL"; break;
133346 ** redefined. The UNION ALL operator uses this property to force
133467 ** <recursive-table> AS (<setup-query> UNION [ALL] <recursive-query>)
133486 ** discarded. If the operator is UNION ALL, then duplicates are allowed.
133586 ** functions. Mark the recursive elements as UNION ALL even if they
133668 ** (2) All terms are UNION ALL
133720 ** two or more separate queries using UNION, UNION ALL, EXCEPT, or
133843 ExplainQueryPlan((pParse, 1, "UNION ALL"));
134254 ** <operator> is one of UNION ALL, UNION, EXCEPT, or INTERSECT. The idea
134265 ** UNION ALL. EXCEPT and INSERTSECT never output a row that
134282 ** UNION ALL UNION EXCEPT INTERSECT
134311 ** outB: output one row of B (UNION and UNION ALL only)
134390 /* For operators other than UNION ALL we have to make sure that
134440 ** operator is UNION, EXCEPT, or INTERSECT (but not UNION ALL).
134984 ** (17a) all compound operators must be a UNION ALL, and
134997 ** operator other than UNION ALL because all the other compound
135058 Select *pParent; /* Current UNION ALL term of the other query */
135159 ** use only the UNION ALL operator. And none of the simple select queries
135227 ** 17 and 18 above) it must be a UNION ALL and the parent query must
135235 ** using UNION ALL operators. In this case N is the number of simple
135242 ** UNION ALL
135244 ** UNION ALL
135251 ** UNION ALL
135253 ** UNION ALL
135722 ** FROM (SELECT 1 AS a1 UNION ALL SELECT 2) AS aa
135723 ** JOIN (SELECT 1 AS b2 UNION ALL SELECT 2) AS bb ON (a1=b2)
135724 ** LEFT JOIN (SELECT 8 AS c3 UNION ALL SELECT 9) AS cc ON (b2=2);
135969 ** The UNION ALL operator works fine with multiSelectOrderBy() even when
136141 int bMayRecursive; /* True if compound joined by UNION [ALL] */
137066 ** SELECT count(*) FROM (SELECT x FROM t1 UNION ALL SELECT y FROM t2)
137074 ** * The subquery is a UNION ALL of two or more terms
137100 if( pSub->op!=TK_ALL && pSub->pPrior ) return 0; /* Must be UNION ALL */
158326 0, /* ALL => nothing */
158597 /* 134 */ "ALL",
158874 /* 88 */ "multiselect_op ::= UNION ALL",
158881 /* 95 */ "distinct ::= ALL",
159780 239, /* (88) multiselect_op ::= UNION ALL */
159787 240, /* (95) distinct ::= ALL */
160183 -2, /* (88) multiselect_op ::= UNION ALL */
160190 -1, /* (95) distinct ::= ALL */
160860 case 88: /* multiselect_op ::= UNION ALL */
160900 case 95: /* distinct ::= ALL */
162699 ** 68: GROUPS ALL
162928 testcase( i==145 ); /* ALL */
201387 "UNION ALL "
205026 " UNION ALL "
206591 "SELECT 0, 'tbl', '', 0, '', 1 UNION ALL "
206592 "SELECT 1, 'idx', '', 0, '', 2 UNION ALL "