Lines Matching refs:LEFT
17207 #define SQLITE_SimplifyJoin 0x00002000 /* Convert LEFT JOIN to JOIN */
29898 sqlite3_str_appendf(&x, " LEFT-JOIN");
102789 ** of a LEFT JOIN, and
105078 ** that derive from the right-hand table of a LEFT JOIN. The
105081 ** on a LEFT JOIN NULL row.
105090 ** of a LEFT JOIN. */
106256 ** the ON or USING clauses of LEFT JOINS) are excluded from the analysis.
106258 ** This routine is used to check if a LEFT JOIN can be converted into
106260 ** clause requires that some column of the right table of the LEFT JOIN
106261 ** be non-NULL, then the LEFT JOIN can be safely converted into an
131523 ** the LEFT OUTER JOIN processing logic that this term is part of the
131534 ** SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.b AND t1.x=5
131564 ** This happens when a LEFT JOIN is simplified into an ordinary JOIN.
133813 ExplainQueryPlan((pParse, 1, "LEFT-MOST SUBQUERY"));
134499 ExplainQueryPlan((pParse, 1, "LEFT"));
134936 ** (3) If the subquery is the right operand of a LEFT JOIN then
134992 ** (17f) the subquery must not be the RHS of a LEFT JOIN.
135065 int isLeftJoin = 0; /* True if pSub is the right side of a LEFT JOIN */
135119 ** If the subquery is the right operand of a LEFT JOIN, then the
135123 ** t1 LEFT OUTER JOIN (t2 JOIN t3)
135127 ** (t1 LEFT OUTER JOIN t2) JOIN t3
135131 ** If the subquery is the right operand of a LEFT JOIN, then the outer
135134 ** the LEFT JOIN table should be all-NULL.
135594 ** part of a ON clause from a LEFT JOIN, then throughout the query
135713 ** (4) The inner query is the right operand of a LEFT JOIN and the
135715 ** on that LEFT JOIN.
135718 ** of a LEFT JOIN where iCursor is not the right-hand table of that
135724 ** LEFT JOIN (SELECT 8 AS c3 UNION ALL SELECT 9) AS cc ON (b2=2);
135757 int isLeftJoin /* True if pSubq is the right term of a LEFT JOIN */
137289 /* Convert LEFT JOIN into JOIN if there are terms of the right table
137290 ** of the LEFT JOIN used in the WHERE clause.
137297 ("LEFT-JOIN simplifies to JOIN on term %d\n",i));
143370 int iLeftJoin; /* Memory cell used to implement LEFT OUTER JOIN */
144163 ** if it controls a LEFT OUTER JOIN and it did not originate in the ON
144168 ** (1) SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.x WHERE t2.z='ok'
144169 ** (2) SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.x AND t2.z='ok'
144174 ** of a LEFT OUTER JOIN. In (1), the term is not disabled.
144754 ** of a LEFT JOIN. Set Walker.eCode to non-zero before returning if the
144864 /* Any terms specified as part of the ON(...) clause for any LEFT
144868 ** If this table is the rhs of a LEFT JOIN, "IS" or "IS NULL" terms
144872 ** SELECT ... t1 LEFT JOIN t2 ON (t1.a=t2.b) WHERE t2.c IS NULL;
145253 /* If this is the right table of a LEFT OUTER JOIN, allocate and
145263 VdbeComment((v, "init LEFT JOIN no-match flag"));
145870 ** Do not do this for the RHS of a LEFT JOIN. This is because the
145890 ** for a LEFT JOIN.
145899 ** a LEFT JOIN: */
146017 ** is required in a few obscure LEFT JOIN cases where control jumps
146044 ** ON or USING clause of a LEFT JOIN, and terms that are usable as
146048 ** is not contained in the ON clause of a LEFT JOIN.
146368 /* For a LEFT OUTER JOIN, generate code that will record the fact that
146374 VdbeComment((v, "record LEFT JOIN hit"));
147715 Bitmask extraRight = 0; /* Extra dependencies on LEFT JOIN */
147754 ** on left table of a LEFT JOIN. Ticket #3015 */
148113 /* Prevent ON clause terms of a LEFT JOIN from being used to drive
149016 ** the RHS of a LEFT JOIN. Such a term can only be used if it is from
149084 || pLoop->prereq!=0 ); /* table of a LEFT JOIN */
149327 ** right-hand table of a LEFT JOIN. See tag-20191211-001 for the
150831 ** be used by the right table of a LEFT JOIN. Only constraints in the
151176 int isLeft, /* True if iTab is the right table of a LEFT JOIN */
151690 ** If there are no LEFT or CROSS JOIN joins in the query, both mPrereq and
151693 ** separated from it by at least one LEFT or CROSS JOIN. Similarly, the
151695 ** virtual table and are separated from it by at least one LEFT or
151700 ** ... FROM t1, t2 LEFT JOIN t3, t4, vt CROSS JOIN t5, t6;
151981 ** right-hand-side of a LEFT or CROSS JOIN. */
153336 ** 2) The table must be the RHS of a LEFT JOIN.
153352 ** LEFT JOIN t2 ON (t1.ipk=t2.ipk)
153353 ** LEFT JOIN t3 ON (t1.ipk=t3.ipk)
153358 ** LEFT JOIN t2
153359 ** LEFT JOIN t3 ON (t1.ipk=t3.ipk)
153725 /* For LEFT JOIN queries, cursor pIn->iCur may not have been
162736 ** 105: OR LAST LEFT
162803 testcase( i==20 ); /* LEFT */