Lines Matching defs:iOffset
433 if( pSelect->iOffset ){
434 iLimit = pSelect->iOffset+1;
456 if( p->iOffset && iContinue!=0 ){
458 sqlite3VdbeAddOp2(v, OP_AddImm, p->iOffset, -1);
459 addr = sqlite3VdbeAddOp1(v, OP_IfNeg, p->iOffset);
1399 ** Compute the iLimit and iOffset fields of the SELECT based on the
1402 ** keywords. Or NULL if those keywords are omitted. iLimit and iOffset
1405 ** iLimit and iOffset are negative.
1407 ** This routine changes the values of iLimit and iOffset only if
1409 ** iOffset should have been preset to appropriate default values
1419 int iOffset;
1450 p->iOffset = iOffset = ++pParse->nMem;
1452 sqlite3ExprCode(pParse, p->pOffset, iOffset);
1453 sqlite3VdbeAddOp1(v, OP_MustBeInt, iOffset);
1455 addr1 = sqlite3VdbeAddOp1(v, OP_IfPos, iOffset);
1456 sqlite3VdbeAddOp2(v, OP_Integer, 0, iOffset);
1458 sqlite3VdbeAddOp3(v, OP_Add, iLimit, iOffset, iOffset+1);
1461 sqlite3VdbeAddOp2(v, OP_Integer, -1, iOffset+1);
1616 p->iOffset = pPrior->iOffset;
1710 p->iOffset = 0;
2152 int savedOffset; /* Saved value of p->iOffset */
2288 sqlite3VdbeAddOp2(v, OP_Copy, p->iOffset ? p->iOffset+1 : p->iLimit,
2332 savedOffset = p->iOffset;
2334 p->iOffset = 0;
2338 p->iOffset = savedOffset;