Lines Matching refs:iTable
16255 Pgno iTable, /* Index of root page */
18855 int iTable; /* Cursor number of the source table */ member
19006 int iTable; /* TK_COLUMN: cursor number of table holding column member
19126 #define EXPR_REDUCEDSIZE offsetof(Expr,iTable) /* Common features */
33113 pExpr->iTable, pExpr->iColumn, zFlgs); in sqlite3TreeViewExpr()
33117 if( pExpr->iTable<0 ){ in sqlite3TreeViewExpr()
33130 pExpr->iTable, pExpr->iColumn, in sqlite3TreeViewExpr()
33181 sqlite3TreeViewLine(pView,"REGISTER(%d)", pExpr->iTable); in sqlite3TreeViewExpr()
33336 if( pExpr->iTable ) sqlite3_str_appendf(pStr, " iTable=%d",pExpr->iTable); in sqlite3TreeViewExpr()
33387 pExpr->iTable ? "NEW" : "OLD", pExpr->iColumn); in sqlite3TreeViewExpr()
33413 pExpr->iTable, pExpr->iColumn, zFlgs); in sqlite3TreeViewExpr()
33426 pExpr->iColumn, pExpr->iTable-1, in sqlite3TreeViewExpr()
33433 sqlite3TreeViewLine(pView, "IF-NULL-ROW %d", pExpr->iTable); in sqlite3TreeViewExpr()
69827 Pgno iTable; /* Root page of table */
70724 printf(" %p/%u%s", pLock->pBtree, pLock->iTable,
70728 printf(",%u%s", pLock->iTable, pLock->eLock==READ_LOCK ? "R" : "W");
70821 && (pLock->iTable==iTab || (pLock->eLock==WRITE_LOCK && pLock->iTable==1))
70913 if( pIter->pBtree!=p && pIter->iTable==iTab && pIter->eLock!=eLock ){
70944 static int setSharedCacheTableLock(Btree *p, Pgno iTable, u8 eLock){
70949 SHARED_LOCK_TRACE(pBt,"setLock", iTable, eLock);
70964 assert( SQLITE_OK==querySharedCacheTableLock(p, iTable, eLock) );
70968 if( pIter->iTable==iTable && pIter->pBtree==p ){
70982 pLock->iTable = iTable;
71026 assert( pLock->iTable!=1 || pLock==&p->lock );
71027 if( pLock->iTable!=1 ){
73119 p->lock.iTable = 1;
74249 assert( p->lock.pBtree==p && p->lock.iTable==1 );
75188 Pgno iTable, /* Root page of table to open */
75206 assert( hasSharedCacheTableLock(p, iTable, pKeyInfo!=0, (wrFlag?2:1))
75207 || iTable<1 );
75208 assert( wrFlag==0 || !hasReadConflicts(p, iTable) );
75216 if( iTable<=1 ){
75217 if( iTable<1 ){
75221 iTable = 0;
75227 pCur->pgnoRoot = iTable;
75236 if( pX->pgnoRoot==iTable ){
75255 Pgno iTable, /* Root page of table to open */
75262 rc = btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
75268 Pgno iTable, /* Root page of table to open */
75274 return btreeCursorWithLock(p, iTable, wrFlag, pKeyInfo, pCur);
75276 return btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
80706 SQLITE_PRIVATE int sqlite3BtreeClearTable(Btree *p, int iTable, i64 *pnChange){
80712 rc = saveAllCursors(pBt, (Pgno)iTable, 0);
80719 invalidateIncrblobCursors(p, (Pgno)iTable, 0, 1);
80721 rc = clearDatabasePage(pBt, (Pgno)iTable, 0, pnChange);
80756 static int btreeDropTable(Btree *p, Pgno iTable, int *piMoved){
80763 assert( iTable>=2 );
80764 if( iTable>btreePagecount(pBt) ){
80765 return SQLITE_CORRUPT_PGNO(iTable);
80768 rc = sqlite3BtreeClearTable(p, iTable, 0);
80770 rc = btreeGetPage(pBt, (Pgno)iTable, &pPage, 0);
80786 if( iTable==maxRootPgno ){
80806 rc = relocatePage(pBt, pMove, PTRMAP_ROOTPAGE, 0, iTable, 0);
80841 SQLITE_PRIVATE int sqlite3BtreeDropTable(Btree *p, int iTable, int *piMoved){
80844 rc = btreeDropTable(p, iTable, piMoved);
86670 sqlite3_str_appendf(p, "r[%d]", pExpr->iTable);
90248 assert( (pWalker->u.aMem[pExpr->iTable].flags & MEM_Undefined)==0 );
106940 pNew->iTable = pMatch->iCursor;
107031 pExpr->iTable = -1;
107230 pExpr->iTable = pMatch->iCursor;
107258 pExpr->iTable = op!=TK_DELETE;
107262 pExpr->iTable = 1;
107265 pExpr->iTable = 0;
107275 pExpr->iTable = EXCLUDED_TABLE_NUMBER;
107303 if( pExpr->iTable==EXCLUDED_TABLE_NUMBER ){
107311 pExpr->iTable = pNC->uNC.pUpsert->regData +
107324 pExpr->iTable = pNC->uNC.iBaseReg + (pTab->nCol+1)*pExpr->iTable +
107332 }else if( pExpr->iTable==0 ){
107599 p->iTable = pItem->iCursor;
107718 pExpr->iTable = pItem->iCursor;
107870 pExpr->iTable = exprProbability(pList->a[1].pExpr);
107871 if( pExpr->iTable<0 ){
107887 pExpr->iTable = pDef->zName[0]=='u' ? 8388608 : 125829120;
109080 assert( pExpr->iColumn < pExpr->iTable );
109082 assert( pExpr->iTable==pExpr->pLeft->x.pSelect->pEList->nExpr );
109607 pRet->iTable = nField;
109676 return pVector->iTable+iField;
111131 pFirst->iTable = pColumns->nId;
111494 if( pWalker->eCode==3 && pExpr->iTable==pWalker->u.iCur ){
111915 assert( p->iTable>=0 ); /* p cannot be part of a CHECK constraint */
111995 assert( pRes->iTable==pSrc->a[0].iCursor ); /* Not a correlated subquery */
112470 assert( iTab!=pExpr->iTable );
112471 sqlite3VdbeAddOp2(v, OP_OpenDup, iTab, pExpr->iTable);
112494 pExpr->iTable = iTab;
112495 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pExpr->iTable, nVal);
112658 return pExpr->iTable;
112733 pExpr->iTable = rReg = dest.iSDParm;
113228 int iTable, /* The cursor pointing to the table */
113235 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pTab, iTable, iColumn, iReg);
113262 p->iTable = iReg;
113357 if( pArg->op==TK_COLUMN && pArg->iTable>=0 ){
113358 sqlite3VdbeAddOp3(v, OP_Offset, pArg->iTable, pArg->iColumn, target);
113404 sqlite3ExprImpliesNonNullRow(pFarg->a[0].pExpr,pA1->iTable,1),
113505 if( pExpr->iColumn==p->iIdxCol && pExpr->iTable==p->iDataCur ){
113604 sqlite3VdbeAddOp3(v, OP_Column, pExpr->iTable, pExpr->iColumn, target);
113611 int iTab = pExpr->iTable;
113750 return pExpr->iTable;
114050 if( pLeft->iTable==0 || pParse->withinRJSubrtn > pLeft->op2 ){
114051 pLeft->iTable = sqlite3CodeSubselect(pParse, pLeft);
114056 if( pExpr->iTable!=n ){
114058 pExpr->iTable, n);
114060 return pLeft->iTable + pExpr->iColumn;
114147 p1 = pExpr->iTable * (pTab->nCol+1) + 1
114150 assert( pExpr->iTable==0 || pExpr->iTable==1 );
114157 (pExpr->iTable ? "new" : "old"),
114203 addrINR = sqlite3VdbeAddOp3(v, OP_IfNullRow, pExpr->iTable, 0, target);
115081 && pB->iTable<0 && pA->iTable==iTab
115131 if( pA->op!=TK_IN && pA->iTable!=pB->iTable && pA->iTable!=iTab ){
115366 if( pWalker->u.iCur==pExpr->iTable ){
115506 && pExpr->iTable==pWalker->u.pIdxCover->iCur
115606 if( pExpr->iTable==pSrc->a[i].iCursor ){
115611 for(i=0; i<p->nExclude && p->aiExclude[i]!=pExpr->iTable; i++){}
115776 if( pCol->iTable==pExpr->iTable
115792 pCol->iTable = pExpr->iTable;
115804 && pE->iTable==pExpr->iTable
115866 tmp.iTable = pIEpr->iIdxCur;
115889 if( pExpr->iTable==pItem->iCursor ){
121263 if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
124636 static void destroyRootPage(Parse *pParse, int iTable, int iDb){
124639 if( iTable<2 ) sqlite3ErrorMsg(pParse, "corrupt schema");
124640 sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb);
124655 pParse->db->aDb[iDb].zDbSName, iTable, r1, r1);
131894 pExpr->iTable = regBase + sqlite3TableColumnToStorage(pTab,iCol) + 1;
131900 pExpr->iTable = regBase;
131921 pExpr->iTable = iCursor;
143305 SQLITE_PRIVATE void sqlite3SetJoinExpr(Expr *p, int iTable, u32 joinFlag){
143311 p->w.iJoin = iTable;
143317 sqlite3SetJoinExpr(p->x.pList->a[i].pExpr, iTable, joinFlag);
143321 sqlite3SetJoinExpr(p->pLeft, iTable, joinFlag);
143340 static void unsetJoinExpr(Expr *p, int iTable, int nullable){
143342 if( iTable<0 || (ExprHasProperty(p, EP_OuterON) && p->w.iJoin==iTable) ){
143344 if( iTable>=0 ) ExprSetProperty(p, EP_InnerON);
143346 if( p->op==TK_COLUMN && p->iTable==iTable && !nullable ){
143355 unsetJoinExpr(p->x.pList->a[i].pExpr, iTable, nullable);
143359 unsetJoinExpr(p->pLeft, iTable, nullable);
143507 pEq->w.iJoin = pE2->iTable;
143948 if( pSort->aDefer[j].iCsr==pExpr->iTable ) break;
143964 pNew->iTable = pExpr->iTable;
143972 pSort->aDefer[nDefer].iCsr = pExpr->iTable;
144816 for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
146710 int iTable; /* Replace references to this table */
146740 && pExpr->w.iJoin==pSubst->iTable
146746 && pExpr->iTable==pSubst->iTable
146769 && (pCopy->op!=TK_COLUMN || pCopy->iTable!=pSubst->iNewTable)
146774 ifNullRow.iTable = pSubst->iNewTable;
146817 if( pExpr->op==TK_IF_NULL_ROW && pExpr->iTable==pSubst->iTable ){
146818 pExpr->iTable = pSubst->iNewTable;
146887 if( pItem->iCursor!=pExpr->iTable ) return WRC_Continue;
146962 renumberCursorDoMapping(pWalker, &pExpr->iTable);
147596 x.iTable = iParent;
147689 if( pE2->iTable==pColumn->iTable
147768 if( pColumn->iTable!=pExpr->iTable ) continue;
148178 x.iTable = pSrc->iCursor;
149383 pCol->iTable, pCol->iColumn, pAggInfo->iFirstReg+ii,
149503 pExpr->iTable = pCol->iTable;
154793 sCol[1].iTable = pTabList->a[0].iCursor;
158056 if( pExpr->iTable==0 || !ExprHasProperty(pExpr, EP_Subrtn) ){
158062 pExpr->iTable = iTab;
158368 && pExpr->iTable==pHint->iTabCur
158431 if( pExpr->iTable!=pHint->iTabCur ){
158435 pExpr->iTable = reg;
158437 pExpr->iTable = pHint->iIdxCur;
158446 pExpr->iTable = reg;
158974 pRight->iTable = iReg+j+2;
160322 pTerm->truthProb = sqlite3LogEst(p->iTable) - 270;
161264 aiCurCol[0] = pExpr->iTable;
161538 pNewTerm->leftCursor = pLeft->iTable;
161734 pNewTerm->leftCursor = pLeft->iTable;
161823 pVal->iTable = iReg;
161890 if( pExpr->iTable!=iCsr ) return;
161999 mask = (p->op==TK_IF_NULL_ROW) ? sqlite3WhereGetMask(pMaskSet, p->iTable) : 0;
162022 return sqlite3WhereGetMask(pMaskSet, p->iTable);
162095 pColRef->iTable = pItem->iCursor;
162494 if( pScan->aiCur[j]==pX->iTable
162500 pScan->aiCur[j] = pX->iTable;
162532 && pX->iTable==pScan->aiCur[0]
162710 && p->iTable==iBase
162774 if( p->iTable==iBase && p->iColumn<0 ) return 1;
163509 if( pExpr->op==TK_COLUMN && pExpr->iTable==pSrc->iCursor ){
163518 && pE2->iTable==pSrc->iCursor
165061 || pLhs->iTable!=iCur
165548 && pExpr->iTable==iCursor
165659 if( pExpr->iTable!=pCk->iTabCur ) return WRC_Continue;
166997 if( pOBExpr->iTable!=iCur ) continue;
167134 if( pOBExpr->iTable!=iCur ) continue;
170113 if( pExpr->iTable==p->pSrc->a[i].iCursor ) break;
170164 pExpr->iTable = p->pWin->iEphCsr;
172630 p->iTable = 0;
176873 if( yymsp[0].minor.yy454 ) sqlite3GetInt32(&t.z[1], &yymsp[0].minor.yy454->iTable);