Lines Matching refs:inner
3497 ** is the name of the inner-most trigger or view that is responsible for
5716 ** out of inner loops.
18374 #define EP_InnerON 0x000002 /* Originates in ON/USING of an inner join */
18658 #define JT_INNER 0x01 /* Any kind of inner or cross join */
18688 #define WHERE_ORDERBY_LIMIT 0x0800 /* ORDERBY+LIMIT on the inner loop */
18710 ** NameContexts can be nested. When resolving names, the inner-most
31830 sqlite3_str_appendf(&x, " inner.iJoin=%d", pExpr->w.iJoin);
66542 ** For the reasons above, the if(...) condition featured in the inner
80590 ** That saves a few cycles in inner loops. */
103703 ** outer query into an inner subquery.
103968 /* Start at the inner-most context and move outward until a match is found */
104729 ** This allows them to be factored out of inner loops. */
117704 /* Code constant expressions that where factored out of inner loops.
138481 /* (5) inner */ { 23, 5, JT_INNER },
139206 ** This function is called as part of inner-loop generation for a SELECT
139291 ** This routine generates the code for the inside of the inner loop
139307 int iBreak /* Jump here to break out of the inner loop */
139858 ** If the inner loop was generated using a non-null pOrderBy argument,
142479 int iFrom, /* Index in p->pSrc->a[] of the inner subquery */
142484 Select *pSub; /* The inner query or "subquery" */
142876 /* The flattened query is a compound if either the inner or the
143228 ** The hope is that the terms added to the inner query will make it more
143241 ** (2) The inner query is the recursive part of a common table expression.
143243 ** (3) The inner query has a LIMIT clause (since the changes to the WHERE
143246 ** (4) The inner query is the right operand of a LEFT JOIN and the
143264 ** of the inner query could change the window over which window
143268 ** (6a) The inner query uses multiple incompatible window partitions.
143270 ** (6b) The inner query is a compound and uses window-functions.
143278 ** (7) The inner query is a Common Table Expression (CTE) that should
143616 ** WITH contexts, from inner to outermost. If the table identified by
143647 ** with the inner-most WITH clause being at the top of the stack.
145540 VdbeNoopComment((v, "inner-loop subroutine"));
145545 VdbeComment((v, "end inner-loop subroutine"));
145550 /* Use the standard inner loop. */
146029 ** will contain 0 the first time the inner loop runs, and 1 thereafter.
151377 ** WhereInfo.a[WhereInfo.nLevel-1] being the inner loop.
151789 unsigned bOrderedInnerLoop:1;/* True if only the inner-most loop is ordered */
152248 ** Disabling a term causes that term to not be tested in the inner loop
152250 ** by indices, we disable them to prevent redundant tests in the inner
153177 ** checks to see if there are additional Bloom filters in inner loops that
153179 ** inner-loop Bloom filters, then evaluate those filters now, before the
153184 ** We know that an inner loop uses a Bloom filter because it has the
153185 ** WhereLevel.regFilter set. If an inner-loop Bloom filter is checked,
153187 ** from being checked a second time when the inner loop is evaluated.
153193 int addrNxt, /* Jump here to bypass inner loops */
156624 ** In the ORDER BY LIMIT optimization, if the inner-most loop is known
156626 ** inner-most loop did not fit within the sorter, then we can skip all
156627 ** subsequent rows for the current iteration of the inner loop (because they
156628 ** will not fit in the sorter either) and continue with the second inner
156629 ** loop - the loop immediately outside the inner-most.
156636 ** be the continuation for the second-inner-most loop. If the ORDER BY
156638 ** be the continuation for the inner-most loop.
156641 ** inner-most loop, in the sense that a correct answer will result.
156642 ** Returning the continuation the second inner loop is an optimization
156650 ** continuation of the inner-most loop. */
157588 ** If there are inner loops within pLevel that have the WHERE_BLOOMFILTER
160936 Bitmask ready; /* Mask of inner loops */
161217 } /* End the loop over all WhereLoops from outer-most down to inner-most */
162136 ** inner loops (or around the "..." if the test occurs within the inner-