contrib/sqlite3/sqlite3.c

17886 ** The r1 and r2 fields are the values to return if this key is less than
17911   i8 r1;              /* Value to return if (lhs < rhs) */
73750         r.r1 = 0;
77175 ** This function assumes that i was obtained by assignment from r1.
77178 ** comparison of "r1==(double)i" you sometimes get an answer of false even
77179 ** though the r1 and (double)i values are bit-for-bit the same.
77181 SQLITE_PRIVATE int sqlite3RealSameAsInt(double r1, sqlite3_int64 i){
77183   return r1==0.0
77184       || (memcmp(&r1, &r2, sizeof(r1))==0
82254     static const double r1 = 1.0;
82257     assert( sizeof(r1)==sizeof(t2) && memcmp(&r1, &t2, sizeof(r1))==0 );
83140     res = pPKey2->r1;
83179     res = pPKey2->r1;      /* (pKey1/nKey1) is a number or a null */
83198       res = pPKey2->r1;
83211         res = pPKey2->r1;
83248       p->r1 = 1;
83251       p->r1 = -1;
101295     int r1, r2;
101297     r1 = exprVectorRegister(pParse, pLeft, i, regLeft, &pL, &regFree1);
101299     codeCompare(pParse, pL, pR, opx, r1, r2, dest, p5, isCommuted);
103637     int r1, r2;
103650     r1 = sqlite3GetTempReg(pParse);
103667       sqlite3ExprCode(pParse, pE2, r1);
103668       sqlite3VdbeAddOp4(v, OP_MakeRecord, r1, 1, r2, &affinity, 1);
103669       sqlite3VdbeAddOp4Int(v, OP_IdxInsert, iTab, r2, r1, 1);
103671     sqlite3ReleaseTempReg(pParse, r1);
103920   ** at r1.
104486   int r1, r2;               /* Various register numbers */
104699         r1 = sqlite3ExprCodeTemp(pParse, pLeft, &regFree1);
104702             r1, r2, inReg, SQLITE_STOREP2 | p5,
104738       r1 = sqlite3ExprCodeTemp(pParse, pExpr->pLeft, &regFree1);
104740       sqlite3VdbeAddOp3(v, op, r2, r1, target);
104762         r1 = sqlite3ExprCodeTemp(pParse, &tempX, &regFree1);
104764         sqlite3VdbeAddOp3(v, OP_Subtract, r2, r1, target);
104773       r1 = sqlite3ExprCodeTemp(pParse, pExpr->pLeft, &regFree1);
104775       sqlite3VdbeAddOp2(v, op, r1, inReg);
104781       r1 = sqlite3ExprCodeTemp(pParse, pExpr->pLeft, &regFree1);
104787       sqlite3VdbeAddOp4Int(v, OP_IsTrue, r1, inReg, !isTrue, isTrue ^ bNormal);
104796       r1 = sqlite3ExprCodeTemp(pParse, pExpr->pLeft, &regFree1);
104798       addr = sqlite3VdbeAddOp1(v, op, r1);
104876           r1 = pParse->nMem+1;
104879           r1 = sqlite3GetTempRange(pParse, nFarg);
104901         sqlite3ExprCodeExprList(pParse, pFarg, r1, 0,
104904         r1 = 0;
104940         sqlite3VdbeAddFunctionCall(pParse, constMask, r1, target, nFarg,
104945           sqlite3ReleaseTempRange(pParse, r1, nFarg);
104947           sqlite3VdbeReleaseRegisters(pParse, r1, nFarg, constMask, 1);
105101     **   CASE x WHEN e1 THEN r1 WHEN e2 THEN r2 ... WHEN eN THEN rN ELSE y END
105104     **   CASE WHEN e1 THEN r1 WHEN e2 THEN r2 ... WHEN eN THEN rN ELSE y END
105107     **   CASE WHEN x=e1 THEN r1 WHEN x=e2 THEN r2 ...
105303     int r1 = sqlite3GetTempReg(pParse);
105304     r2 = sqlite3ExprCodeTarget(pParse, pExpr, r1);
105305     if( r2==r1 ){
105306       *pReg = r1;
105308       sqlite3ReleaseTempReg(pParse, r1);
105537   int r1, r2;
105601       r1 = sqlite3ExprCodeTemp(pParse, pExpr->pLeft, &regFree1);
105604                   r1, r2, dest, jumpIfNull, ExprHasProperty(pExpr,EP_Commuted));
105623       r1 = sqlite3ExprCodeTemp(pParse, pExpr->pLeft, &regFree1);
105624       sqlite3VdbeAddOp2(v, op, r1, dest);
105652         r1 = sqlite3ExprCodeTemp(pParse, pExpr, &regFree1);
105653         sqlite3VdbeAddOp3(v, OP_If, r1, dest, jumpIfNull!=0);
105679   int r1, r2;
105777       r1 = sqlite3ExprCodeTemp(pParse, pExpr->pLeft, &regFree1);
105780                   r1, r2, dest, jumpIfNull,ExprHasProperty(pExpr,EP_Commuted));
105797       r1 = sqlite3ExprCodeTemp(pParse, pExpr->pLeft, &regFree1);
105798       sqlite3VdbeAddOp2(v, op, r1, dest);
105828         r1 = sqlite3ExprCodeTemp(pParse, pExpr, &regFree1);
105829         sqlite3VdbeAddOp3(v, OP_IfNot, r1, dest, jumpIfNull!=0);
107073   int r1;                   /* Temporary registers */
107181     r1 = sqlite3GetTempReg(pParse);
107182     sqlite3VdbeAddOp3(v, OP_ReadCookie, iDb, r1, BTREE_FILE_FORMAT);
107184     sqlite3VdbeAddOp2(v, OP_AddImm, r1, -2);
107185     sqlite3VdbeAddOp2(v, OP_IfPos, r1, sqlite3VdbeCurrentAddr(v)+2);
107188     sqlite3ReleaseTempReg(pParse, r1);
114538   int r1 = sqlite3GetTempReg(pParse);
114540   sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb);
114543   /* OP_Destroy stores an in integer r1. If this integer
114555      pParse->db->aDb[iDb].zDbSName, iTable, r1, r1);
114557   sqlite3ReleaseTempReg(pParse, r1);
118300   int r1 = -1;       /* Register holding an index key */
118315     r1 = sqlite3GenerateIndexKey(pParse, pIdx, iDataCur, 0, 1,
118316         &iPartIdxLabel, pPrior, r1);
118317     sqlite3VdbeAddOp3(v, OP_IdxDelete, iIdxCur+i, r1,
119464       double r1, r2;
119466       r1 = sqlite3_value_double(argv[0]);
119467       sqlite3_snprintf(sizeof(zBuf), zBuf, "%!.15g", r1);
119469       if( r1!=r2 ){
119470         sqlite3_snprintf(sizeof(zBuf), zBuf, "%!.20e", r1);
129195         int r1 = -1;
129265             r1 = sqlite3GenerateIndexKey(pParse, pIdx, iDataCur, 0, 0, &jmp3,
129266                                          pPrior, r1);
129270             jmp2 = sqlite3VdbeAddOp4Int(v, OP_Found, iIdxCur+j, ckUniq, r1,
129291                 sqlite3VdbeAddOp2(v, OP_IsNull, r1+kk, uniqOk);
129297               sqlite3VdbeAddOp4Int(v, OP_IdxGT, iIdxCur+j, uniqOk, r1,
129667           int r1 = sqlite3GetTempReg(pParse);
129668           sqlite3VdbeAddOp4(v, OP_String8, 0, r1, 0, zSubSql, P4_DYNAMIC);
129669           sqlite3VdbeAddOp2(v, OP_ResultRow, r1, 1);
131918   int r1;
131921   r1 = sqlite3GetTempReg(pParse);
131923   sqlite3VdbeAddOp3(v, OP_MakeRecord, iMem, N, r1);
131924   sqlite3VdbeAddOp4Int(v, OP_IdxInsert, iTab, r1, iMem, N);
131926   sqlite3ReleaseTempReg(pParse, r1);
132238       int r1;
132239       r1 = sqlite3GetTempReg(pParse);
132240       sqlite3VdbeAddOp3(v, OP_MakeRecord, regResult, nResultCol, r1);
132241       sqlite3VdbeAddOp4Int(v, OP_IdxInsert, iParm, r1, regResult, nResultCol);
132242       sqlite3ReleaseTempReg(pParse, r1);
132262       int r1 = sqlite3GetTempRange(pParse, nPrefixReg+1);
132267       sqlite3VdbeAddOp3(v, OP_MakeRecord, regResult, nResultCol, r1+nPrefixReg);
132276         sqlite3VdbeAddOp4Int(v, OP_Found, iParm+1, addr, r1, 0);
132278         sqlite3VdbeAddOp4Int(v, OP_IdxInsert, iParm+1, r1,regResult,nResultCol);
132284         pushOntoSorter(pParse, pSort, p, r1+nPrefixReg, regOrig, 1, nPrefixReg);
132288         sqlite3VdbeAddOp3(v, OP_Insert, iParm, r1, r2);
132292       sqlite3ReleaseTempRange(pParse, r1, nPrefixReg+1);
132302         int r1 = sqlite3GetTempReg(pParse);
132310                           regResult+(i2<0), nResultCol-(i2<0), r1);
132312           sqlite3VdbeAddOp3(v, OP_Insert, iParm, r1, regResult);
132314           sqlite3VdbeAddOp4Int(v, OP_IdxInsert, iParm, r1, regResult, i2);
132334         int r1 = sqlite3GetTempReg(pParse);
132337             r1, pDest->zAffSdst, nResultCol);
132338         sqlite3VdbeAddOp4Int(v, OP_IdxInsert, iParm, r1, regResult, nResultCol);
132339         sqlite3ReleaseTempReg(pParse, r1);
132396       int r1, r2, r3;
132402       r1 = sqlite3GetTempReg(pParse);
132424       sqlite3VdbeAddOp3(v, OP_MakeRecord, r2, nKey+2, r1);
132425       sqlite3VdbeAddOp4Int(v, OP_IdxInsert, iParm, r1, r2, nKey+2);
132427       sqlite3ReleaseTempReg(pParse, r1);
132754       int r1 = sqlite3GetTempReg(pParse);
132755       sqlite3VdbeAddOp3(v, OP_MakeRecord,regRow+(i2<0),nColumn-(i2<0),r1);
132757         sqlite3VdbeAddOp3(v, OP_Insert, iParm, r1, regRow);
132759         sqlite3VdbeAddOp4Int(v, OP_IdxInsert, iParm, r1, regRow, i2);
133956         int r1;
134010         r1 = sqlite3GetTempReg(pParse);
134011         iStart = sqlite3VdbeAddOp2(v, OP_RowData, tab1, r1);
134012         sqlite3VdbeAddOp4Int(v, OP_NotFound, tab2, iCont, r1, 0);
134014         sqlite3ReleaseTempReg(pParse, r1);
134165       int r1 = sqlite3GetTempReg(pParse);
134167       sqlite3VdbeAddOp3(v, OP_MakeRecord, pIn->iSdst, pIn->nSdst, r1);
134169       sqlite3VdbeAddOp3(v, OP_Insert, pDest->iSDParm, r1, r2);
134172       sqlite3ReleaseTempReg(pParse, r1);
134180       int r1;
134182       r1 = sqlite3GetTempReg(pParse);
134184           r1, pDest->zAffSdst, pIn->nSdst);
134185       sqlite3VdbeAddOp4Int(v, OP_IdxInsert, pDest->iSDParm, r1,
134187       sqlite3ReleaseTempReg(pParse, r1);
138001             int r1 = j + regBase;
138003                                pCol->pTab, pCol->iTable, pCol->iColumn, r1);
144639     int r1;
144646     r1 = codeEqualityTerm(pParse, pTerm, pLevel, j, bRev, regBase+j);
144647     if( r1!=regBase+j ){
144650         regBase = r1;
144652         sqlite3VdbeAddOp2(v, OP_SCopy, r1, regBase+j);
145421       int r1, rTemp;        /* Registers for holding the start boundary */
145443         r1 = rTemp = sqlite3GetTempReg(pParse);
145444         codeExprOrVector(pParse, pX->pRight, r1, 1);
145455         r1 = sqlite3ExprCodeTemp(pParse, pX->pRight, &rTemp);
145459       sqlite3VdbeAddOp3(v, op, iCur, addrBrk, r1);
146705           int r1 = sqlite3GetTempReg(pParse);
146706           sqlite3ExprCodeTarget(pParse, pRight, r1);
146708           sqlite3ReleaseTempReg(pParse, r1);
153681         int r1 = pParse->nMem+1;
153684           sqlite3VdbeAddOp3(v, OP_Column, pLevel->iIdxCur, j, r1+j);
153688         addrSeek = sqlite3VdbeAddOp4Int(v, op, pLevel->iIdxCur, 0, r1, n);