Lines Matching defs:iLimit
6801 ** to the value of the iLimit parameter passed to xTruncate(). If any
6831 void (*xTruncate)(sqlite3_pcache*, unsigned iLimit);
6852 void (*xTruncate)(sqlite3_pcache*, unsigned iLimit);
10948 int iLimit, iOffset; /* Memory registers holding LIMIT & OFFSET counters */
37362 ** greater than or equal to iLimit. Any pinned pages that meet this
37369 unsigned int iLimit /* Drop pages with this pgno or larger */
37378 if( pPage->iKey>=iLimit ){
37777 ** or greater than parameter iLimit. Any pinned pages with a page number
37778 ** equal to or greater than iLimit are implicitly unpinned.
37780 static void pcache1Truncate(sqlite3_pcache *p, unsigned int iLimit){
37783 iLimit<=pCache->iMaxKey ){
37784 pcache1TruncateUnsafe(pCache, iLimit);
37785 pCache->iMaxKey = iLimit-1;
39747 const i64 iLimit = pPager->journalSizeLimit; /* Local cache of jsl */
39750 if( doTruncate || iLimit==0 ){
39766 if( rc==SQLITE_OK && iLimit>0 ){
39769 if( rc==SQLITE_OK && sz>iLimit ){
39770 rc = sqlite3OsTruncate(pPager->jfd, iLimit);
45125 SQLITE_PRIVATE i64 sqlite3PagerJournalSizeLimit(Pager *pPager, i64 iLimit){
45126 if( iLimit>=-1 ){
45127 pPager->journalSizeLimit = iLimit;
45128 sqlite3WalLimit(pPager->pWal, iLimit);
46273 int iLimit = 0; /* Zero values greater than this */
46295 iLimit = pWal->hdr.mxFrame - iZero;
46296 assert( iLimit>0 );
46298 if( aHash[i]>iLimit ){
46306 nByte = (int)((char *)aHash - (char *)&aPgno[iLimit+1]);
46307 memset((void *)&aPgno[iLimit+1], 0, nByte);
46313 if( iLimit ){
46316 for(i=1; i<=iLimit; i++){
46681 SQLITE_PRIVATE void sqlite3WalLimit(Wal *pWal, i64 iLimit){
46682 if( pWal ) pWal->mxWalSize = iLimit;
59074 int iLimit; /* Maximum allowed string or blob size */
59087 iLimit = pMem->db->aLimit[SQLITE_LIMIT_LENGTH];
59089 iLimit = SQLITE_MAX_LENGTH;
59095 for(nByte=0; nByte<=iLimit && z[nByte]; nByte++){}
59097 for(nByte=0; nByte<=iLimit && (z[nByte] | z[nByte+1]); nByte+=2){}
59111 if( nByte>iLimit ){
59140 if( nByte>iLimit ){
75390 pNew->iLimit = 0;
75503 ** If the expression list pEList contains more than iLimit elements,
76101 pExpr->x.pSelect->iLimit = 0;
76202 pSel->iLimit = 0;
92722 i64 iLimit = -2;
92724 sqlite3Atoi64(zRight, &iLimit, 1000000, SQLITE_UTF8);
92725 if( iLimit<-1 ) iLimit = -1;
92727 iLimit = sqlite3PagerJournalSizeLimit(pPager, iLimit);
92728 returnSingleInt(pParse, "journal_size_limit", iLimit);
92801 int iLimit, addr;
92805 if( zRight==0 || !sqlite3GetInt32(zRight, &iLimit) || iLimit<=0 ){
92806 iLimit = 0x7fffffff;
92809 sqlite3VdbeAddOp2(v, OP_Integer, iLimit, 1);
94978 if( pSelect->iLimit ){
94980 int iLimit;
94982 iLimit = pSelect->iOffset+1;
94984 iLimit = pSelect->iLimit;
94986 addr1 = sqlite3VdbeAddOp1(v, OP_IfZero, iLimit);
94987 sqlite3VdbeAddOp2(v, OP_AddImm, iLimit, -1);
95275 if( pOrderBy==0 && p->iLimit ){
95276 sqlite3VdbeAddOp3(v, OP_IfZero, p->iLimit, iBreak, -1);
95965 ** Compute the iLimit and iOffset fields of the SELECT based on the
95968 ** keywords. Or NULL if those keywords are omitted. iLimit and iOffset
95971 ** iLimit and iOffset are negative.
95973 ** This routine changes the values of iLimit and iOffset only if
95974 ** a limit or offset is defined by pLimit and pOffset. iLimit and
95984 int iLimit = 0;
95987 if( p->iLimit ) return;
95998 p->iLimit = iLimit = ++pParse->nMem;
96002 sqlite3VdbeAddOp2(v, OP_Integer, n, iLimit);
96010 sqlite3ExprCode(pParse, p->pLimit, iLimit);
96011 sqlite3VdbeAddOp1(v, OP_MustBeInt, iLimit);
96013 sqlite3VdbeAddOp2(v, OP_IfZero, iLimit, iBreak);
96024 sqlite3VdbeAddOp3(v, OP_Add, iLimit, iOffset, iOffset+1);
96026 addr1 = sqlite3VdbeAddOp1(v, OP_IfPos, iLimit);
96185 p->iLimit = pPrior->iLimit;
96187 if( p->iLimit ){
96188 addr = sqlite3VdbeAddOp1(v, OP_IfZero, p->iLimit);
96279 p->iLimit = 0;
96467 ** If the LIMIT found in p->iLimit is reached, jump immediately to
96595 if( p->iLimit ){
96596 sqlite3VdbeAddOp3(v, OP_IfZero, p->iLimit, iBreak, -1);
96721 int savedLimit; /* Saved value of p->iLimit */
96855 if( p->iLimit && op==TK_ALL ){
96858 sqlite3VdbeAddOp2(v, OP_Copy, p->iOffset ? p->iOffset+1 : p->iLimit,
96889 pPrior->iLimit = regLimitA;
96901 savedLimit = p->iLimit;
96903 p->iLimit = regLimitB;
96907 p->iLimit = savedLimit;
98529 if( p->iLimit==0 && addrSortIndex>=0 ){
