sqlite/dist/sqlite3.c

19271 #define JT_OUTER     0x20    /* The "OUTER" keyword is present */
32480       sqlite3_str_appendf(&x, " FULL-OUTER-JOIN");
114723 ** the ON or USING clauses of OUTER JOINS) are excluded from the analysis.
142008 **     LEFT     OUTER      -                 JT_LEFT|JT_OUTER
142010 **     RIGHT    OUTER      -                 JT_RIGHT|JT_OUTER
142012 **     FULL     OUTER      -                 JT_LEFT|JT_RIGHT|JT_OUTER
142015 **     NATURAL  LEFT     OUTER               JT_NATURAL|JT_LEFT|JT_OUTER
142017 **     NATURAL  RIGHT    OUTER               JT_NATURAL|JT_RIGHT|JT_OUTER
142019 **     NATURAL  FULL     OUTER               JT_NATRUAL|JT_LEFT|JT_RIGHT
142029 **          OUTER LEFT JOIN         ->   same as LEFT JOIN
142032 **          RIGHT OUTER FULL JOIN   ->   same as FULL JOIN
142037 **    *   "INNER" cannot appear together with "OUTER", "LEFT", "RIGHT",
142040 **    *   "CROSS" cannot appear together with "OUTER", "LEFT", "RIGHT,
142043 **    *   If "OUTER" is present then there must also be one of
142178 ** the OUTER JOIN processing logic that this term is part of the
145570 ** position in the parent that NULL-able due to an OUTER JOIN.  Either the
146177   **         t1 LEFT OUTER JOIN (t2 JOIN t3)
146181   **         (t1 LEFT OUTER JOIN t2) JOIN t3
146903 **            of a join (either an INNER or an OUTER join), and
149193     ** "OUTER JOIN strength reduction" in the SQLite documentation.
155608   int iLeftJoin;        /* Memory cell used to implement LEFT OUTER JOIN */
156487 ** if it controls a LEFT OUTER JOIN and it did not originate in the ON
156498 ** of a LEFT OUTER JOIN.  In (1), the term is not disabled.
157563   /* If this is the right table of a LEFT OUTER JOIN, allocate and
158755   /* For a RIGHT OUTER JOIN, record the fact that the current row has
158796   /* For a LEFT OUTER JOIN, generate code that will record the fact that
158823     ** to the results of the OUTER JOIN.  The following loop generates the
159851 **   3.  Not originating in the ON clause of an OUTER JOIN
163621         ** operand, or if the loop is not an OUTER JOIN.
166807 ** OUTER JOINS
167015   **        no RIGHT or FULL OUTER joins in pTabList.
176844 ** 112: ORDER OUTER
176951     testcase( i==68 ); /* OUTER */