Lines Matching refs:iLimit
9102 void (*xTruncate)(sqlite3_pcache*, unsigned iLimit);
9123 void (*xTruncate)(sqlite3_pcache*, unsigned iLimit);
17769 int iLimit, iOffset; /* Memory registers holding LIMIT & OFFSET counters */ member
38210 int iLimit = 0;
38228 if( zBuf[nBuf-2]!=0 || (iLimit++)>10 ) return SQLITE_ERROR;
46994 sqlite3_int64 iLimit = *(sqlite3_int64*)pArg;
46995 if( iLimit<p->sz ){
46996 if( iLimit<0 ){
46997 iLimit = p->szMax;
46999 iLimit = p->sz;
47002 p->szMax = iLimit;
47003 *(sqlite3_int64*)pArg = iLimit;
49299 unsigned int iLimit /* Drop pages with this pgno or larger */
49304 assert( pCache->iMaxKey >= iLimit );
49306 if( pCache->iMaxKey - iLimit < pCache->nHash ){
49311 h = iLimit % pCache->nHash;
49326 if( pPage->iKey>=iLimit ){
49798 static void pcache1Truncate(sqlite3_pcache *p, unsigned int iLimit){
49801 if( iLimit<=pCache->iMaxKey ){
49802 pcache1TruncateUnsafe(pCache, iLimit);
49803 pCache->iMaxKey = iLimit-1;
52006 const i64 iLimit = pPager->journalSizeLimit; /* Local cache of jsl */
52009 if( doTruncate || iLimit==0 ){
52025 if( rc==SQLITE_OK && iLimit>0 ){
52028 if( rc==SQLITE_OK && sz>iLimit ){
52029 rc = sqlite3OsTruncate(pPager->jfd, iLimit);
58013 SQLITE_PRIVATE i64 sqlite3PagerJournalSizeLimit(Pager *pPager, i64 iLimit){
58014 if( iLimit>=-1 ){
58015 pPager->journalSizeLimit = iLimit;
58016 sqlite3WalLimit(pPager->pWal, iLimit);
59310 int iLimit = 0; /* Zero values greater than this */
59334 iLimit = pWal->hdr.mxFrame - sLoc.iZero;
59335 assert( iLimit>0 );
59337 if( sLoc.aHash[i]>iLimit ){
59345 nByte = (int)((char *)sLoc.aHash - (char *)&sLoc.aPgno[iLimit+1]);
59346 memset((void *)&sLoc.aPgno[iLimit+1], 0, nByte);
59352 if( iLimit ){
59355 for(j=1; j<=iLimit; j++){
59735 SQLITE_PRIVATE void sqlite3WalLimit(Wal *pWal, i64 iLimit){
59736 if( pWal ) pWal->mxWalSize = iLimit;
75458 int iLimit; /* Maximum allowed string or blob size */
75471 iLimit = pMem->db->aLimit[SQLITE_LIMIT_LENGTH];
75473 iLimit = SQLITE_MAX_LENGTH;
75481 for(nByte=0; nByte<=iLimit && (z[nByte] | z[nByte+1]); nByte+=2){}
75495 if( nByte>iLimit ){
75527 if( nByte>iLimit ){
98428 pNew->iLimit = 0;
99656 pSelect->iLimit = 0;
99828 pSel->iLimit = 0;
121920 i64 iLimit = -2;
121922 sqlite3DecOrHexToI64(zRight, &iLimit);
121923 if( iLimit<-1 ) iLimit = -1;
121925 iLimit = sqlite3PagerJournalSizeLimit(pPager, iLimit);
121926 returnSingleInt(v, iLimit);
121993 int iLimit, addr;
121994 if( zRight==0 || !sqlite3GetInt32(zRight, &iLimit) || iLimit<=0 ){
121995 iLimit = 0x7fffffff;
121998 sqlite3VdbeAddOp2(v, OP_Integer, iLimit, 1);
124836 pNew->iLimit = 0;
125289 int iLimit; /* LIMIT counter */
125316 assert( pSelect->iOffset==0 || pSelect->iLimit!=0 );
125317 iLimit = pSelect->iOffset ? pSelect->iOffset+1 : pSelect->iLimit;
125361 if( iLimit ){
125362 sqlite3VdbeAddOp2(v, OP_IfNot, iLimit, pSort->labelDone);
125369 if( iLimit ){
125386 sqlite3VdbeAddOp2(v, OP_IfNotZero, iLimit, sqlite3VdbeCurrentAddr(v)+4);
125678 if( p->iLimit
125948 if( pSort==0 && p->iLimit ){
125949 sqlite3VdbeAddOp2(v, OP_DecrJumpZero, p->iLimit, iBreak); VdbeCoverage(v);
126838 int iLimit = 0;
126843 if( p->iLimit ) return;
126854 p->iLimit = iLimit = ++pParse->nMem;
126858 sqlite3VdbeAddOp2(v, OP_Integer, n, iLimit);
126867 sqlite3ExprCode(pParse, pLimit->pLeft, iLimit);
126868 sqlite3VdbeAddOp1(v, OP_MustBeInt, iLimit); VdbeCoverage(v);
126870 sqlite3VdbeAddOp2(v, OP_IfNot, iLimit, iBreak); VdbeCoverage(v);
126878 sqlite3VdbeAddOp3(v, OP_OffsetLimit, iLimit, iOffset+1, iOffset);
127023 regLimit = p->iLimit;
127026 p->iLimit = p->iOffset = 0;
127284 pPrior->iLimit = p->iLimit;
127293 p->iLimit = pPrior->iLimit;
127295 if( p->iLimit ){
127296 addr = sqlite3VdbeAddOp1(v, OP_IfNot, p->iLimit); VdbeCoverage(v);
127300 p->iLimit, p->iOffset+1, p->iOffset);
127385 p->iLimit = 0;
127689 if( p->iLimit ){
127690 sqlite3VdbeAddOp2(v, OP_DecrJumpZero, p->iLimit, iBreak); VdbeCoverage(v);
127926 if( p->iLimit && op==TK_ALL ){
127929 sqlite3VdbeAddOp2(v, OP_Copy, p->iOffset ? p->iOffset+1 : p->iLimit,
127953 pPrior->iLimit = regLimitA;
127965 savedLimit = p->iLimit;
127967 p->iLimit = regLimitB;
127971 p->iLimit = savedLimit;
130725 if( p->iLimit==0 && sSort.addrSortIndex>=0 ){
136090 LogEst iLimit; /* LIMIT if wctrlFlags has WHERE_USE_LIMIT */
144080 if( (pWInfo->wctrlFlags & WHERE_USE_LIMIT)!=0 && pWInfo->iLimit<nRow ){
144081 nRow = pWInfo->iLimit;
144766 pWInfo->iLimit = iAuxArg;
210503 int iLimit;
210511 iLimit = (iOff>9 ? iOff-9 : 0);
210512 for(iOff--; iOff>iLimit; iOff--){