Lines Matching defs:pLimit
18838 Expr *pLimit; /* LIMIT expression. NULL means not used. */
31614 if( p->pLimit ) n++;
31667 if( p->pLimit ){
31669 sqlite3TreeViewExpr(pView, p->pLimit->pLeft, p->pLimit->pRight!=0);
31670 if( p->pLimit->pRight ){
31672 sqlite3TreeViewExpr(pView, p->pLimit->pRight, 0);
32343 const Expr *pLimit,
32354 if( pLimit ) n++;
32376 if( pLimit ){
32379 sqlite3TreeViewExpr(pView, pLimit, 0);
32471 const Expr *pLimit,
32492 if( pLimit ) n++;
32518 if( pLimit ){
32521 sqlite3TreeViewExpr(pView, pLimit, 0);
103552 if( sqlite3WalkExpr(pWalker, p->pLimit) ) return WRC_Abort;
105409 if( sqlite3ResolveExprNames(&sNC, p->pLimit) ){
106563 heightOfExpr(p->pLimit, pnHeight);
107551 pNew->pLimit = sqlite3ExprDup(db, p->pLimit, flags);
108411 if( p->pLimit ) return 0; /* Has no LIMIT clause */
109070 Expr *pLimit; /* New limit expression */
109139 if( pSel->pLimit ){
109143 pLimit = sqlite3Expr(db, TK_INTEGER, "0");
109144 if( pLimit ){
109145 pLimit->affExpr = SQLITE_AFF_NUMERIC;
109146 pLimit = sqlite3PExpr(pParse, TK_NE,
109147 sqlite3ExprDup(db, pSel->pLimit->pLeft, 0), pLimit);
109149 sqlite3ExprDeferredDelete(pParse, pSel->pLimit->pLeft);
109150 pSel->pLimit->pLeft = pLimit;
109153 pLimit = sqlite3Expr(pParse->db, TK_INTEGER, "1");
109154 pSel->pLimit = sqlite3PExpr(pParse, TK_LIMIT, pLimit, 0);
123840 Expr *pLimit, /* Optional LIMIT clause */
123858 SF_IncludeHidden, pLimit);
123879 Expr *pLimit, /* The LIMIT clause. May be null */
123892 if( pOrderBy && pLimit==0 ) {
123902 if( pLimit == 0 ) {
123956 pOrderBy,0,pLimit
123979 Expr *pLimit /* LIMIT clause. May be null */
124054 pOrderBy, pLimit, pTrigger);
124061 pParse, pTabList, pWhere, pOrderBy, pLimit, "DELETE"
124064 pLimit = 0;
124116 pWhere, pOrderBy, pLimit, iTabCur
124120 pLimit = 0;
124374 sqlite3ExprDelete(db, pLimit);
131439 if( pSelect->pLimit ){
138298 sqlite3ExprDelete(db, p->pLimit);
138341 Expr *pLimit /* LIMIT value. NULL means not used */
138371 pNew->pLimit = pLimit;
140633 ** pLimit expressions. pLimit->pLeft and pLimit->pRight hold the expressions
140641 ** a limit or offset is defined by pLimit->pLeft and pLimit->pRight. iLimit
140649 ** Only if pLimit->pLeft!=0 do the limit registers get
140659 Expr *pLimit = p->pLimit;
140669 if( pLimit ){
140670 assert( pLimit->op==TK_LIMIT );
140671 assert( pLimit->pLeft!=0 );
140675 if( sqlite3ExprIsInteger(pLimit->pLeft, &n) ){
140685 sqlite3ExprCode(pParse, pLimit->pLeft, iLimit);
140690 if( pLimit->pRight ){
140693 sqlite3ExprCode(pParse, pLimit->pRight, iOffset);
140824 Expr *pLimit; /* Saved LIMIT and OFFSET */
140841 pLimit = p->pLimit;
140844 p->pLimit = 0;
140951 p->pLimit = pLimit;
140986 int bShowAll = p->pLimit==0;
141074 assert( pPrior->pLimit==0 );
141126 assert( !pPrior->pLimit );
141129 pPrior->pLimit = p->pLimit;
141132 pPrior->pLimit = 0;
141154 if( p->pLimit
141155 && sqlite3ExprIsInteger(p->pLimit->pLeft, &nLimit)
141170 Expr *pLimit; /* Saved values of p->nLimit */
141181 assert( p->pLimit==0 ); /* Not allowed on leftward elements */
141216 pLimit = p->pLimit;
141217 p->pLimit = 0;
141231 sqlite3ExprDelete(db, p->pLimit);
141232 p->pLimit = pLimit;
141260 Expr *pLimit;
141294 pLimit = p->pLimit;
141295 p->pLimit = 0;
141307 sqlite3ExprDelete(db, p->pLimit);
141308 p->pLimit = pLimit;
141810 sqlite3ExprDelete(db, p->pLimit);
141811 p->pLimit = 0;
142521 if( pSub->pLimit && p->pLimit ) return 0; /* Restriction (13) */
142522 if( pSub->pLimit && pSub->pLimit->pRight ) return 0; /* Restriction (14) */
142523 if( (p->selFlags & SF_Compound)!=0 && pSub->pLimit ){
142528 if( pSub->pLimit && (pSrc->nSrc>1 || isAgg) ){
142535 if( pSub->pLimit && p->pWhere ) return 0; /* Restriction (19) */
142536 if( pSub->pLimit && (p->selFlags & SF_Distinct)!=0 ){
142704 Expr *pLimit = p->pLimit;
142710 p->pLimit = 0;
142712 p->pLimit = pLimit;
142887 if( pSub->pLimit ){
142888 pParent->pLimit = pSub->pLimit;
142889 pSub->pLimit = 0;
143332 if( pSubq->pLimit!=0 ){
143596 pNew->pLimit = 0;
144812 if( pSub->pLimit ) return 0; /* No LIMIT clause */
145094 && pSub->pLimit==0 /* Condition (1) */
145467 if( p->pLimit ) computeLimitRegisters(pParse, p, iEnd);
147990 ** Assuming both the pLimit and pOrderBy parameters are NULL, this function
147999 ** Or, if pLimit and pOrderBy are not NULL, and pTab is not a view:
148004 ** ORDER BY pOrderBy LIMIT pLimit
148035 Expr *pLimit /* LIMIT clause */
148051 if( pOrderBy && pLimit==0 ) {
148056 pLimit2 = sqlite3ExprDup(db, pLimit, 0);
148059 UNUSED_PARAMETER(pLimit);
148076 if( pLimit ){
148092 if( pLimit ){
148131 Expr *pLimit, /* LIMIT clause. May be null */
148226 onError, pOrderBy, pLimit, pUpsert, pTrigger);
148240 pParse, pTabList, pWhere, pOrderBy, pLimit, "UPDATE"
148243 pLimit = 0;
148477 pWhere, pOrderBy, pLimit, iDataCur
148480 pLimit = 0;
148540 pParse, iEph, pPk, pChanges, pTabList, pWhere, pOrderBy, pLimit
148988 sqlite3ExprDelete(db, pLimit);
156302 assert( p!=0 && p->pLimit!=0 ); /* 1 -- checked by caller */
156334 assert( p->pLimit->op==TK_LIMIT );
156335 whereAddLimitExpr(pWC, p->iLimit, p->pLimit->pLeft,
156338 whereAddLimitExpr(pWC, p->iOffset, p->pLimit->pRight,
162325 if( pSelect && pSelect->pLimit ){
166326 Expr *pLimit
166334 sqlite3ExprDelete(pParse->db, pLimit);
166356 if( pLoop->pOrderBy || pLoop->pLimit ){