Lines Matching refs:iTable
14839 Pgno iTable, /* Index of root page */
17620 int iTable; /* Cursor number of the source table */ member
17755 int iTable; /* TK_COLUMN: cursor number of table holding column member
17869 #define EXPR_REDUCEDSIZE offsetof(Expr,iTable) /* Common features */
30679 pExpr->iTable, pExpr->iColumn, zFlgs);
30683 if( pExpr->iTable<0 ){
30696 pExpr->iTable, pExpr->iColumn,
30747 sqlite3TreeViewLine(pView,"REGISTER(%d)", pExpr->iTable);
30932 pExpr->iTable ? "NEW" : "OLD", pExpr->iColumn);
30958 pExpr->iTable, pExpr->iColumn, zFlgs);
30971 pExpr->iColumn, pExpr->iTable-1,
30978 sqlite3TreeViewLine(pView, "IF-NULL-ROW %d", pExpr->iTable);
64862 Pgno iTable; /* Root page of table */
65811 && (pLock->iTable==iTab || (pLock->eLock==WRITE_LOCK && pLock->iTable==1))
65903 if( pIter->pBtree!=p && pIter->iTable==iTab && pIter->eLock!=eLock ){
65934 static int setSharedCacheTableLock(Btree *p, Pgno iTable, u8 eLock){
65952 assert( SQLITE_OK==querySharedCacheTableLock(p, iTable, eLock) );
65956 if( pIter->iTable==iTable && pIter->pBtree==p ){
65970 pLock->iTable = iTable;
66012 assert( pLock->iTable!=1 || pLock==&p->lock );
66013 if( pLock->iTable!=1 ){
67987 p->lock.iTable = 1;
69097 assert( p->lock.pBtree==p && p->lock.iTable==1 );
70006 Pgno iTable, /* Root page of table to open */
70024 assert( hasSharedCacheTableLock(p, iTable, pKeyInfo!=0, (wrFlag?2:1))
70025 || iTable<1 );
70026 assert( wrFlag==0 || !hasReadConflicts(p, iTable) );
70038 if( iTable<=1 ){
70039 if( iTable<1 ){
70043 iTable = 0;
70049 pCur->pgnoRoot = iTable;
70059 if( pX->pgnoRoot==iTable ){
70071 Pgno iTable, /* Root page of table to open */
70078 rc = btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
70084 Pgno iTable, /* Root page of table to open */
70090 return btreeCursorWithLock(p, iTable, wrFlag, pKeyInfo, pCur);
70092 return btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
75208 SQLITE_PRIVATE int sqlite3BtreeClearTable(Btree *p, int iTable, i64 *pnChange){
75214 rc = saveAllCursors(pBt, (Pgno)iTable, 0);
75221 invalidateIncrblobCursors(p, (Pgno)iTable, 0, 1);
75223 rc = clearDatabasePage(pBt, (Pgno)iTable, 0, pnChange);
75258 static int btreeDropTable(Btree *p, Pgno iTable, int *piMoved){
75265 assert( iTable>=2 );
75266 if( iTable>btreePagecount(pBt) ){
75270 rc = sqlite3BtreeClearTable(p, iTable, 0);
75272 rc = btreeGetPage(pBt, (Pgno)iTable, &pPage, 0);
75288 if( iTable==maxRootPgno ){
75308 rc = relocatePage(pBt, pMove, PTRMAP_ROOTPAGE, 0, iTable, 0);
75343 SQLITE_PRIVATE int sqlite3BtreeDropTable(Btree *p, int iTable, int *piMoved){
75346 rc = btreeDropTable(p, iTable, piMoved);
80749 sqlite3_str_appendf(p, "r[%d]", pExpr->iTable);
99851 pExpr->iTable = -1;
99950 pExpr->iTable = pMatch->iCursor;
99978 pExpr->iTable = op!=TK_DELETE;
99982 pExpr->iTable = 1;
99985 pExpr->iTable = 0;
99995 pExpr->iTable = EXCLUDED_TABLE_NUMBER;
100023 if( pExpr->iTable==EXCLUDED_TABLE_NUMBER ){
100031 pExpr->iTable = pNC->uNC.pUpsert->regData +
100042 pExpr->iTable = pNC->uNC.iBaseReg + (pTab->nCol+1)*pExpr->iTable +
100050 }else if( pExpr->iTable==0 ){
100275 p->iTable = pItem->iCursor;
100392 pExpr->iTable = pItem->iCursor;
100521 pExpr->iTable = exprProbability(pList->a[1].pExpr);
100522 if( pExpr->iTable<0 ){
100538 pExpr->iTable = pDef->zName[0]=='u' ? 8388608 : 125829120;
101715 assert( pExpr->iColumn < pExpr->iTable );
101716 assert( pExpr->iTable==pExpr->pLeft->x.pSelect->pEList->nExpr );
102161 pRet->iTable = nField;
102230 return pVector->iTable+iField;
103532 pFirst->iTable = pColumns->nId;
103840 if( pWalker->eCode==3 && pExpr->iTable==pWalker->u.iCur ){
104139 assert( p->iTable>=0 ); /* p cannot be part of a CHECK constraint */
104198 assert( pRes->iTable==pSrc->a[0].iCursor ); /* Not a correlated subquery */
104669 sqlite3VdbeAddOp2(v, OP_OpenDup, iTab, pExpr->iTable);
104693 pExpr->iTable = iTab;
104694 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pExpr->iTable, nVal);
104849 return pExpr->iTable;
104927 pExpr->iTable = rReg = dest.iSDParm;
105417 int iTable, /* The cursor pointing to the table */
105422 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pTab, iTable, iColumn, iReg);
105448 p->iTable = iReg;
105580 sqlite3ExprImpliesNonNullRow(pFarg->a[0].pExpr,pA1->iTable),
105667 int iTab = pExpr->iTable;
105812 return pExpr->iTable;
106083 sqlite3VdbeAddOp3(v, OP_Offset, pArg->iTable, pArg->iColumn, target);
106122 if( pExpr->pLeft->iTable==0 ){
106123 pExpr->pLeft->iTable = sqlite3CodeSubselect(pParse, pExpr->pLeft);
106127 if( pExpr->iTable!=n ){
106129 pExpr->iTable, n);
106131 return pExpr->pLeft->iTable + pExpr->iColumn;
106202 p1 = pExpr->iTable * (pTab->nCol+1) + 1
106205 assert( pExpr->iTable==0 || pExpr->iTable==1 );
106212 (pExpr->iTable ? "new" : "old"),
106243 addrINR = sqlite3VdbeAddOp1(v, OP_IfNullRow, pExpr->iTable);
107153 if( pA->op!=TK_IN && pA->iTable!=pB->iTable && pA->iTable!=iTab ){
107365 if( pWalker->u.iCur==pExpr->iTable ){
107487 && pExpr->iTable==pWalker->u.pIdxCover->iCur
107587 if( pExpr->iTable==pSrc->a[i].iCursor ){
107592 for(i=0; i<p->nExclude && p->aiExclude[i]!=pExpr->iTable; i++){}
107757 if( pExpr->iTable==pItem->iCursor ){
107767 if( pCol->iTable==pExpr->iTable &&
107778 pCol->iTable = pExpr->iTable;
107790 if( pE->op==TK_COLUMN && pE->iTable==pExpr->iTable &&
112928 if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
116268 static void destroyRootPage(Parse *pParse, int iTable, int iDb){
116271 if( iTable<2 ) sqlite3ErrorMsg(pParse, "corrupt schema");
116272 sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb);
116287 pParse->db->aDb[iDb].zDbSName, iTable, r1, r1);
123030 pExpr->iTable = regBase + sqlite3TableColumnToStorage(pTab,iCol) + 1;
123036 pExpr->iTable = regBase;
123057 pExpr->iTable = iCursor;
133613 pEq->iRightJoinTable = pE2->iTable;
133644 SQLITE_PRIVATE void sqlite3SetJoinExpr(Expr *p, int iTable){
133649 p->iRightJoinTable = iTable;
133655 sqlite3SetJoinExpr(p->x.pList->a[i].pExpr, iTable);
133659 sqlite3SetJoinExpr(p->pLeft, iTable);
133670 static void unsetJoinExpr(Expr *p, int iTable){
133673 && (iTable<0 || p->iRightJoinTable==iTable) ){
133676 if( p->op==TK_COLUMN && p->iTable==iTable ){
133684 unsetJoinExpr(p->x.pList->a[i].pExpr, iTable);
133688 unsetJoinExpr(p->pLeft, iTable);
134210 if( pSort->aDefer[j].iCsr==pExpr->iTable ) break;
134226 pNew->iTable = pExpr->iTable;
134234 pSort->aDefer[nDefer].iCsr = pExpr->iTable;
135046 for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
136862 int iTable; /* Replace references to this table */
136891 && pExpr->iRightJoinTable==pSubst->iTable
136896 && pExpr->iTable==pSubst->iTable
136918 ifNullRow.iTable = pSubst->iNewTable;
136949 if( pExpr->op==TK_IF_NULL_ROW && pExpr->iTable==pSubst->iTable ){
136950 pExpr->iTable = pSubst->iNewTable;
137019 if( pItem->iCursor!=pExpr->iTable ) return WRC_Continue;
137094 renumberCursorDoMapping(pWalker, &pExpr->iTable);
137663 x.iTable = iParent;
137754 if( pE2->iTable==pColumn->iTable
137828 if( pColumn->iTable!=pExpr->iTable ) continue;
138122 x.iTable = iCursor;
140445 pCol->pTab, pCol->iTable, pCol->iColumn, r1);
143895 sCol[1].iTable = pTabList->a[0].iCursor;
146991 pTerm->pExpr->iTable = iTab;
147289 && pExpr->iTable==pHint->iTabCur
147351 if( pExpr->iTable!=pHint->iTabCur ){
147355 pExpr->iTable = reg;
147357 pExpr->iTable = pHint->iIdxCur;
147610 pExpr->iTable = pX->iIdxCur;
147629 if( pExpr->iTable==pX->iTabCur && pExpr->iColumn==pX->iTabCol ){
147633 pExpr->iTable = pX->iIdxCur;
147908 pRight->iTable = iReg+j+2;
149059 pTerm->truthProb = sqlite3LogEst(p->iTable) - 270;
149997 aiCurCol[0] = pExpr->iTable;
150233 pNewTerm->leftCursor = pLeft->iTable;
150426 pNewTerm->leftCursor = pLeft->iTable;
150531 return sqlite3WhereGetMask(pMaskSet, p->iTable);
150536 mask = (p->op==TK_IF_NULL_ROW) ? sqlite3WhereGetMask(pMaskSet, p->iTable) : 0;
150622 pColRef->iTable = pItem->iCursor;
150943 if( pScan->aiCur[j]==pX->iTable
150949 pScan->aiCur[j] = pX->iTable;
150973 && pX->iTable==pScan->aiCur[0]
151151 && p->iTable==iBase
151215 if( p->iTable==iBase && p->iColumn<0 ) return 1;
151643 if( pExpr->op!=TK_COLUMN || pExpr->iTable!=pSrc->iCursor ) break;
153088 || pLhs->iTable!=iCur
153543 if( pExpr->op==TK_COLUMN && pExpr->iTable==iCursor ){
154527 if( pOBExpr->iTable!=iCur ) continue;
154664 if( pOBExpr->iTable!=iCur ) continue;
157123 if( pExpr->iTable==p->pSrc->a[i].iCursor ) break;
157173 pExpr->iTable = p->pWin->iEphCsr;
159637 p->iTable = 0;
163777 if( yymsp[0].minor.yy626 ) sqlite3GetInt32(&t.z[1], &yymsp[0].minor.yy626->iTable);