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 */
37334 ** greater than or equal to iLimit. Any pinned pages that meet this
37341 unsigned int iLimit /* Drop pages with this pgno or larger */
37350 if( pPage->iKey>=iLimit ){
37749 ** or greater than parameter iLimit. Any pinned pages with a page number
37750 ** equal to or greater than iLimit are implicitly unpinned.
37752 static void pcache1Truncate(sqlite3_pcache *p, unsigned int iLimit){
37755 if( iLimit<=pCache->iMaxKey ){
37756 pcache1TruncateUnsafe(pCache, iLimit);
37757 pCache->iMaxKey = iLimit-1;
39719 const i64 iLimit = pPager->journalSizeLimit; /* Local cache of jsl */
39722 if( doTruncate || iLimit==0 ){
39738 if( rc==SQLITE_OK && iLimit>0 ){
39741 if( rc==SQLITE_OK && sz>iLimit ){
39742 rc = sqlite3OsTruncate(pPager->jfd, iLimit);
45097 SQLITE_PRIVATE i64 sqlite3PagerJournalSizeLimit(Pager *pPager, i64 iLimit){
45098 if( iLimit>=-1 ){
45099 pPager->journalSizeLimit = iLimit;
45100 sqlite3WalLimit(pPager->pWal, iLimit);
46245 int iLimit = 0; /* Zero values greater than this */
46267 iLimit = pWal->hdr.mxFrame - iZero;
46268 assert( iLimit>0 );
46270 if( aHash[i]>iLimit ){
46278 nByte = (int)((char *)aHash - (char *)&aPgno[iLimit+1]);
46279 memset((void *)&aPgno[iLimit+1], 0, nByte);
46285 if( iLimit ){
46288 for(i=1; i<=iLimit; i++){
46653 SQLITE_PRIVATE void sqlite3WalLimit(Wal *pWal, i64 iLimit){
46654 if( pWal ) pWal->mxWalSize = iLimit;
59046 int iLimit; /* Maximum allowed string or blob size */
59059 iLimit = pMem->db->aLimit[SQLITE_LIMIT_LENGTH];
59061 iLimit = SQLITE_MAX_LENGTH;
59067 for(nByte=0; nByte<=iLimit && z[nByte]; nByte++){}
59069 for(nByte=0; nByte<=iLimit && (z[nByte] | z[nByte+1]); nByte+=2){}
59083 if( nByte>iLimit ){
59112 if( nByte>iLimit ){
75354 pNew->iLimit = 0;
75467 ** If the expression list pEList contains more than iLimit elements,
76065 pExpr->x.pSelect->iLimit = 0;
76166 pSel->iLimit = 0;
92686 i64 iLimit = -2;
92688 sqlite3Atoi64(zRight, &iLimit, 1000000, SQLITE_UTF8);
92689 if( iLimit<-1 ) iLimit = -1;
92691 iLimit = sqlite3PagerJournalSizeLimit(pPager, iLimit);
92692 returnSingleInt(pParse, "journal_size_limit", iLimit);
92765 int iLimit, addr;
92769 if( zRight==0 || !sqlite3GetInt32(zRight, &iLimit) || iLimit<=0 ){
92770 iLimit = 0x7fffffff;
92773 sqlite3VdbeAddOp2(v, OP_Integer, iLimit, 1);
94942 if( pSelect->iLimit ){
94944 int iLimit;
94946 iLimit = pSelect->iOffset+1;
94948 iLimit = pSelect->iLimit;
94950 addr1 = sqlite3VdbeAddOp1(v, OP_IfZero, iLimit);
94951 sqlite3VdbeAddOp2(v, OP_AddImm, iLimit, -1);
95239 if( pOrderBy==0 && p->iLimit ){
95240 sqlite3VdbeAddOp3(v, OP_IfZero, p->iLimit, iBreak, -1);
95929 ** Compute the iLimit and iOffset fields of the SELECT based on the
95932 ** keywords. Or NULL if those keywords are omitted. iLimit and iOffset
95935 ** iLimit and iOffset are negative.
95937 ** This routine changes the values of iLimit and iOffset only if
95938 ** a limit or offset is defined by pLimit and pOffset. iLimit and
95948 int iLimit = 0;
95951 if( p->iLimit ) return;
95962 p->iLimit = iLimit = ++pParse->nMem;
95966 sqlite3VdbeAddOp2(v, OP_Integer, n, iLimit);
95974 sqlite3ExprCode(pParse, p->pLimit, iLimit);
95975 sqlite3VdbeAddOp1(v, OP_MustBeInt, iLimit);
95977 sqlite3VdbeAddOp2(v, OP_IfZero, iLimit, iBreak);
95988 sqlite3VdbeAddOp3(v, OP_Add, iLimit, iOffset, iOffset+1);
95990 addr1 = sqlite3VdbeAddOp1(v, OP_IfPos, iLimit);
96149 p->iLimit = pPrior->iLimit;
96151 if( p->iLimit ){
96152 addr = sqlite3VdbeAddOp1(v, OP_IfZero, p->iLimit);
96243 p->iLimit = 0;
96431 ** If the LIMIT found in p->iLimit is reached, jump immediately to
96559 if( p->iLimit ){
96560 sqlite3VdbeAddOp3(v, OP_IfZero, p->iLimit, iBreak, -1);
96685 int savedLimit; /* Saved value of p->iLimit */
96819 if( p->iLimit && op==TK_ALL ){
96822 sqlite3VdbeAddOp2(v, OP_Copy, p->iOffset ? p->iOffset+1 : p->iLimit,
96853 pPrior->iLimit = regLimitA;
96865 savedLimit = p->iLimit;
96867 p->iLimit = regLimitB;
96871 p->iLimit = savedLimit;
98493 if( p->iLimit==0 && addrSortIndex>=0 ){
