10268         int iCur;              /* The VDBE cursor used by this IN operator */
11082 SQLITE_PRIVATE void sqlite3OpenTable(Parse*, int iCur, int iDb, Table*, int);
62001 ** Allocate VdbeCursor number iCur.  Return a pointer to it.  Return NULL
62006   int iCur,             /* Index of the new VdbeCursor */
62029   Mem *pMem = &p->aMem[p->nMem-iCur];
62038   assert( iCur<p->nCursor );
62039   if( p->apCsr[iCur] ){
62040     sqlite3VdbeFreeCursor(p, p->apCsr[iCur]);
62041     p->apCsr[iCur] = 0;
62044     p->apCsr[iCur] = pCx = (VdbeCursor*)pMem->z;
81150   int iCur             /* Cursor number for ephemerial table */
81173   sqlite3SelectDestInit(&dest, SRT_EphemTab, iCur);
81292   int iCur;              /* VDBE Cursor number for pTab */
81357   iCur = pTabList->a[0].iCursor = pParse->nTab++;
81382     sqlite3MaterializeView(pParse, pTab, pWhere, iCur);
81433     regRowid = sqlite3ExprCodeGetColumn(pParse, pTab, -1, iCur, iRowid);
81450       sqlite3OpenTableAndIndices(pParse, pTab, iCur, OP_OpenWrite);
81466       sqlite3GenerateRowDelete(pParse, pTab, iCur, iRowid, count, pTrigger, OE_Default);
81476         sqlite3VdbeAddOp2(v, OP_Close, iCur + i, pIdx->tnum);
81478       sqlite3VdbeAddOp1(v, OP_Close, iCur);
81524 **       to be deleted, must be opened as cursor number $iCur.
81538   int iCur,          /* Cursor number for the table */
81551   /* Seek cursor iCur to the row to delete. If this row no longer exists 
81555   sqlite3VdbeAddOp3(v, OP_NotExists, iCur, iLabel, iRowid);
81577         sqlite3ExprCodeGetColumnOfTable(v, pTab, iCur, iCol, iOld+iCol+1);
81590     sqlite3VdbeAddOp3(v, OP_NotExists, iCur, iLabel, iRowid);
81602     sqlite3GenerateRowIndexDelete(pParse, pTab, iCur, 0);
81603     sqlite3VdbeAddOp2(v, OP_Delete, iCur, (count?OPFLAG_NCHANGE:0));
81633 **       to be deleted, must be opened as cursor number "iCur".
81636 **       cursor number iCur+i for the i-th index.
81638 **   3.  The "iCur" cursor must be pointing to the row that is to be
81644   int iCur,          /* Cursor number for the table */
81653     r1 = sqlite3GenerateIndexKey(pParse, pIdx, iCur, 0, 0);
81654     sqlite3VdbeAddOp3(pParse->pVdbe, OP_IdxDelete, iCur+i, r1,pIdx->nColumn+1);
81661 ** iCur is the index of a cursor open on the pTab table and pointing to
81672   int iCur,          /* Cursor number for the pIdx->pTable table */
81684   sqlite3VdbeAddOp2(v, OP_Rowid, iCur, regBase+nCol);
81690       sqlite3VdbeAddOp3(v, OP_Column, iCur, idx, regBase+j);
83619   int iCur = pParse->nTab - 1;              /* Cursor number to use */
83660       sqlite3OpenTable(pParse, iCur, iDb, pTab, OP_OpenRead);
83661       sqlite3VdbeAddOp3(v, OP_NotExists, iCur, 0, regTemp);
83672       sqlite3VdbeAddOp3(v, OP_OpenRead, iCur, pIdx->tnum, iDb);
83694       sqlite3VdbeAddOp4Int(v, OP_Found, iCur, iOk, regRec, 0);
83718   sqlite3VdbeAddOp1(v, OP_Close, iCur);
84505   int iCur,       /* The cursor number of the table */
84515   sqlite3VdbeAddOp3(v, opcode, iCur, pTab->tnum, iDb);
85639   int iCur;           /* Table cursor number */
85796   for(iCur=0, pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext, iCur++){
85800     if( aRegIdx[iCur]==0 ) continue;  /* Skip unused indices */
85813     sqlite3VdbeAddOp3(v, OP_MakeRecord, regIdx, pIdx->nColumn+1, aRegIdx[iCur]);
85836     j3 = sqlite3VdbeAddOp4(v, OP_IsUnique, baseCur+iCur+1, 0,
95801   int iCur;              /* VDBE Cursor number of pTab */
95876   pTabList->a[0].iCursor = iCur = pParse->nTab++;
95998     sqlite3MaterializeView(pParse, pTab, pWhere, iCur);
96018   sqlite3VdbeAddOp2(v, OP_Rowid, iCur, regOldRowid);
96042     if( !okOnePass ) sqlite3OpenTable(pParse, iCur, iDb, pTab, OP_OpenWrite); 
96057         sqlite3VdbeAddOp4(v, OP_OpenWrite, iCur+i+1, pIdx->tnum, iDb,
96059         assert( pParse->nTab>iCur+i+1 );
96073   /* Make cursor iCur point to the record that is being updated. If
96076   sqlite3VdbeAddOp3(v, OP_NotExists, iCur, addr, regOldRowid);
96097         sqlite3ExprCodeGetColumnOfTable(v, pTab, iCur, i, regOld+i);
96138         sqlite3VdbeAddOp3(v, OP_Column, iCur, i, regNew+i);
96159     sqlite3VdbeAddOp3(v, OP_NotExists, iCur, addr, regOldRowid);
96168         sqlite3VdbeAddOp3(v, OP_Column, iCur, i, regNew+i);
96178     sqlite3GenerateConstraintChecks(pParse, pTab, iCur, regNewRowid,
96187     j1 = sqlite3VdbeAddOp3(v, OP_NotExists, iCur, 0, regOldRowid);
96188     sqlite3GenerateRowIndexDelete(pParse, pTab, iCur, aRegIdx);
96192       sqlite3VdbeAddOp2(v, OP_Delete, iCur, 0);
96201     sqlite3CompleteInsertion(pParse, pTab, iCur, regNewRowid, aRegIdx, 1, 0, 0);
96229       sqlite3VdbeAddOp2(v, OP_Close, iCur+i+1, 0);
96232   sqlite3VdbeAddOp2(v, OP_Close, iCur, 0);
98216 ** where X is a reference to the iColumn of table iCur and <op> is one of
98222   int iCur,             /* Cursor number of LHS */
98230   assert( iCur>=0 );
98233     if( pTerm->leftCursor==iCur
99285   const int iCur = pSrc->iCursor;   /* The cursor of the table to be accessed */
99286   const Bitmask maskSrc = getMask(pWC->pMaskSet, iCur);  /* Bitmask for pSrc */
99318         }else if( pOrTerm->leftCursor==iCur ){
100348   int iCur = pSrc->iCursor;   /* The cursor of the table to be accessed */
100496       pTerm = findTerm(pWC, iCur, j, notReady, eqTermMask, pIdx);
100522       if( findTerm(pWC, iCur, j, notReady, WO_LT|WO_LE|WO_GT|WO_GE, pIdx) ){
100523         WhereTerm *pTop = findTerm(pWC, iCur, j, notReady, WO_LT|WO_LE, pIdx);
100524         WhereTerm *pBtm = findTerm(pWC, iCur, j, notReady, WO_GT|WO_GE, pIdx);
100553         && isSortingIndex(pParse, pWC->pMaskSet, pProbe, iCur, pOrderBy,
100702       thisTab = getMask(pWC->pMaskSet, iCur);
100956       pIn->iCur = iTab;
101022   int iCur = pLevel->iTabCur;   /* The cursor of the table */
101050     pTerm = findTerm(pWC, iCur, k, notReady, pLevel->plan.wsFlags, pIdx);
101250   int iCur;            /* The VDBE cursor for the table */
101270   iCur = pTabItem->iCursor;
101325     sqlite3VdbeAddOp4(v, OP_VFilter, iCur, addrBrk, iReg, pVtabIdx->idxStr,
101335     pLevel->p1 = iCur;
101349     pTerm = findTerm(pWC, iCur, -1, notReady, WO_EQ|WO_IN, 0);
101352     assert( pTerm->leftCursor==iCur );
101358     sqlite3VdbeAddOp3(v, OP_NotExists, iCur, addrNxt, iRowidReg);
101359     sqlite3ExprCacheStore(pParse, iCur, -1, iRowidReg);
101371     pStart = findTerm(pWC, iCur, -1, notReady, WO_GT|WO_GE, 0);
101372     pEnd = findTerm(pWC, iCur, -1, notReady, WO_LT|WO_LE, 0);
101398       assert( pStart->leftCursor==iCur );
101400       sqlite3VdbeAddOp3(v, aMoveOp[pX->op-TK_GT], iCur, addrBrk, r1);
101406       sqlite3VdbeAddOp2(v, bRev ? OP_Last : OP_Rewind, iCur, addrBrk);
101412       assert( pEnd->leftCursor==iCur );
101425     pLevel->p1 = iCur;
101434       sqlite3VdbeAddOp2(v, OP_Rowid, iCur, iRowidReg);
101435       sqlite3ExprCacheStore(pParse, iCur, -1, iRowidReg);
101529       pRangeEnd = findTerm(pWC, iCur, k, notReady, (WO_LT|WO_LE), pIdx);
101533       pRangeStart = findTerm(pWC, iCur, k, notReady, (WO_GT|WO_GE), pIdx);
101662       sqlite3ExprCacheStore(pParse, iCur, -1, iRowidReg);
101663       sqlite3VdbeAddOp2(v, OP_Seek, iCur, iRowidReg);  /* Deferred seek */
101781       if( pOrTerm->leftCursor==iCur || pOrTerm->eOperator==WO_AND ){
101794             r = sqlite3ExprCodeGetColumn(pParse, pTabItem->pTab, -1, iCur, 
101831     pLevel->p1 = iCur;
101832     pLevel->p2 = 1 + sqlite3VdbeAddOp2(v, aStart[bRev], iCur, addrBrk);
101835   notReady &= ~getMask(pWC->pMaskSet, iCur);
102397       int iCur = pTabItem->iCursor;
102398       sqlite3VdbeAddOp4(v, OP_VOpen, iCur, 0, 0, pVTab, P4_VTAB);
102542         sqlite3VdbeAddOp2(v, OP_Next, pIn->iCur, pIn->addrInTop);

Indexes created Thu Nov 06 06:13:30 CET 2014