Lines Matching refs:iLimit
6266 ** to the value of the iLimit parameter passed to xTruncate(). If any
6287 void (*xTruncate)(sqlite3_pcache*, unsigned iLimit);
10166 int iLimit, iOffset; /* Memory registers holding LIMIT & OFFSET counters */
33838 ** greater than or equal to iLimit. Any pinned pages that meet this
33845 unsigned int iLimit
33854 if( pPage->iKey>=iLimit ){
34161 ** or greater than parameter iLimit. Any pinned pages with a page number
34162 ** equal to or greater than iLimit are implicitly unpinned.
34164 static void pcache1Truncate(sqlite3_pcache *p, unsigned int iLimit){
34167 if( iLimit<=pCache->iMaxKey ){
34168 pcache1TruncateUnsafe(pCache, iLimit);
34169 pCache->iMaxKey = iLimit-1;
36097 const i64 iLimit = pPager->journalSizeLimit; /* Local cache of jsl */
36100 if( doTruncate || iLimit==0 ){
36116 if( rc==SQLITE_OK && iLimit>0 ){
36119 if( rc==SQLITE_OK && sz>iLimit ){
36120 rc = sqlite3OsTruncate(pPager->jfd, iLimit);
41371 SQLITE_PRIVATE i64 sqlite3PagerJournalSizeLimit(Pager *pPager, i64 iLimit){
41372 if( iLimit>=-1 ){
41373 pPager->journalSizeLimit = iLimit;
42471 int iLimit = 0; /* Zero values greater than this */
42493 iLimit = pWal->hdr.mxFrame - iZero;
42494 assert( iLimit>0 );
42496 if( aHash[i]>iLimit ){
42504 nByte = (int)((char *)aHash - (char *)&aPgno[iLimit+1]);
42505 memset((void *)&aPgno[iLimit+1], 0, nByte);
42511 if( iLimit ){
42514 for(i=1; i<=iLimit; i++){
54852 int iLimit; /* Maximum allowed string or blob size */
54865 iLimit = pMem->db->aLimit[SQLITE_LIMIT_LENGTH];
54867 iLimit = SQLITE_MAX_LENGTH;
54873 for(nByte=0; nByte<=iLimit && z[nByte]; nByte++){}
54875 for(nByte=0; nByte<=iLimit && (z[nByte] | z[nByte+1]); nByte+=2){}
54889 if( nByte>iLimit ){
54918 if( nByte>iLimit ){
69751 pNew->iLimit = 0;
69865 ** If the expression list pEList contains more than iLimit elements,
70458 pExpr->x.pSelect->iLimit = 0;
70559 pSel->iLimit = 0;
86050 i64 iLimit = -2;
86052 sqlite3Atoi64(zRight, &iLimit, 1000000, SQLITE_UTF8);
86053 if( iLimit<-1 ) iLimit = -1;
86055 iLimit = sqlite3PagerJournalSizeLimit(pPager, iLimit);
86056 returnSingleInt(pParse, "journal_size_limit", iLimit);
86129 int iLimit, addr;
86133 if( zRight==0 || !sqlite3GetInt32(zRight, &iLimit) || iLimit<=0 ){
86134 iLimit = 0x7fffffff;
86137 sqlite3VdbeAddOp2(v, OP_Integer, iLimit, 1);
88270 if( pSelect->iLimit ){
88272 int iLimit;
88274 iLimit = pSelect->iOffset+1;
88276 iLimit = pSelect->iLimit;
88278 addr1 = sqlite3VdbeAddOp1(v, OP_IfZero, iLimit);
88279 sqlite3VdbeAddOp2(v, OP_AddImm, iLimit, -1);
88567 if( pOrderBy==0 && p->iLimit ){
88568 sqlite3VdbeAddOp3(v, OP_IfZero, p->iLimit, iBreak, -1);
89235 ** Compute the iLimit and iOffset fields of the SELECT based on the
89238 ** keywords. Or NULL if those keywords are omitted. iLimit and iOffset
89241 ** iLimit and iOffset are negative.
89243 ** This routine changes the values of iLimit and iOffset only if
89244 ** a limit or offset is defined by pLimit and pOffset. iLimit and
89254 int iLimit = 0;
89257 if( p->iLimit ) return;
89268 iLimit = iLimit = ++pParse->nMem;
89272 sqlite3VdbeAddOp2(v, OP_Integer, n, iLimit);
89280 sqlite3ExprCode(pParse, p->pLimit, iLimit);
89281 sqlite3VdbeAddOp1(v, OP_MustBeInt, iLimit);
89283 sqlite3VdbeAddOp2(v, OP_IfZero, iLimit, iBreak);
89294 sqlite3VdbeAddOp3(v, OP_Add, iLimit, iOffset, iOffset+1);
89296 addr1 = sqlite3VdbeAddOp1(v, OP_IfPos, iLimit);
89451 p->iLimit = pPrior->iLimit;
89453 if( p->iLimit ){
89454 addr = sqlite3VdbeAddOp1(v, OP_IfZero, p->iLimit);
89545 p->iLimit = 0;
89733 ** If the LIMIT found in p->iLimit is reached, jump immediately to
89861 if( p->iLimit ){
89862 sqlite3VdbeAddOp3(v, OP_IfZero, p->iLimit, iBreak, -1);
89987 int savedLimit; /* Saved value of p->iLimit */
90121 if( p->iLimit && op==TK_ALL ){
90124 sqlite3VdbeAddOp2(v, OP_Copy, p->iOffset ? p->iOffset+1 : p->iLimit,
90155 pPrior->iLimit = regLimitA;
90167 savedLimit = p->iLimit;
90169 p->iLimit = regLimitB;
90173 p->iLimit = savedLimit;
