Lines Matching refs:nLimit
33 int nLimit, /* LIMIT value. -1 means not used */
57 pNew->nLimit = nLimit;
1222 ** nLimit and nOffset fields. nLimit and nOffset hold the integers
1230 ** a limit or offset is defined by nLimit and nOffset. iLimit and
1233 ** Only if nLimit>=0 or nOffset>0 do the limit registers get
1240 ** If the comparison is p->nLimit>0 then "LIMIT 0" shows
1242 ** p->nLimit>=0 then "LIMIT 0" show no rows at all.
1248 if( p->nLimit>=0 ){
1252 sqliteVdbeAddOp(v, OP_Integer, -p->nLimit, 0);
1311 if( pPrior->nLimit>=0 || pPrior->nOffset>0 ){
1334 pPrior->nLimit = p->nLimit;
1341 p->nLimit = -1;
1355 int nLimit, nOffset; /* Saved values of p->nLimit and p->nOffset */
1359 if( eDest==priorOp && p->pOrderBy==0 && p->nLimit<0 && p->nOffset==0 ){
1396 nLimit = p->nLimit;
1397 p->nLimit = -1;
1403 p->nLimit = nLimit;
1440 int nLimit, nOffset;
1464 nLimit = p->nLimit;
1465 p->nLimit = -1;
1470 p->nLimit = nLimit;
1663 if( (pSub->isDistinct || pSub->nLimit>=0) && (pSrc->nSrc>1 || isAgg) ){
1666 if( (p->isDistinct || p->nLimit>=0) && subqueryIsAgg ) return 0;
1811 if( pSub->nLimit>=0 ){
1812 if( p->nLimit<0 ){
1813 p->nLimit = pSub->nLimit;
1814 }else if( p->nLimit+p->nOffset > pSub->nLimit+pSub->nOffset ){
1815 p->nLimit = pSub->nLimit + pSub->nOffset - p->nOffset;