Lines Matching refs:iTable
16669 Pgno iTable, /* Index of root page */
16907 int iTable; /* Ephemeral table generated by the subroutine */ member
19266 int iTable; /* Cursor number of the source table */ member
19423 int iTable; /* TK_COLUMN: cursor number of table holding column member
19544 #define EXPR_REDUCEDSIZE offsetof(Expr,iTable) /* Common features */
33687 pExpr->iTable, pExpr->iColumn, zFlgs); in sqlite3TreeViewExpr()
33691 if( pExpr->iTable<0 ){ in sqlite3TreeViewExpr()
33704 pExpr->iTable, pExpr->iColumn, in sqlite3TreeViewExpr()
33755 sqlite3TreeViewLine(pView,"REGISTER(%d)", pExpr->iTable); in sqlite3TreeViewExpr()
33910 if( pExpr->iTable ) sqlite3_str_appendf(pStr, " iTable=%d",pExpr->iTable); in sqlite3TreeViewExpr()
33961 pExpr->iTable ? "NEW" : "OLD", pExpr->iColumn); in sqlite3TreeViewExpr()
33988 pExpr->iTable, pExpr->iColumn, zFlgs); in sqlite3TreeViewExpr()
34001 pExpr->iColumn, pExpr->iTable-1, in sqlite3TreeViewExpr()
34008 sqlite3TreeViewLine(pView, "IF-NULL-ROW %d", pExpr->iTable); in sqlite3TreeViewExpr()
70831 Pgno iTable; /* Root page of table */ member
71734 printf(" %p/%u%s", pLock->pBtree, pLock->iTable,
71738 printf(",%u%s", pLock->iTable, pLock->eLock==READ_LOCK ? "R" : "W");
71831 && (pLock->iTable==iTab || (pLock->eLock==WRITE_LOCK && pLock->iTable==1))
71923 if( pIter->pBtree!=p && pIter->iTable==iTab && pIter->eLock!=eLock ){
71954 static int setSharedCacheTableLock(Btree *p, Pgno iTable, u8 eLock){
71959 SHARED_LOCK_TRACE(pBt,"setLock", iTable, eLock);
71974 assert( SQLITE_OK==querySharedCacheTableLock(p, iTable, eLock) );
71978 if( pIter->iTable==iTable && pIter->pBtree==p ){
71992 pLock->iTable = iTable;
72036 assert( pLock->iTable!=1 || pLock==&p->lock );
72037 if( pLock->iTable!=1 ){
74135 p->lock.iTable = 1;
75272 assert( p->lock.pBtree==p && p->lock.iTable==1 );
76211 Pgno iTable, /* Root page of table to open */
76229 assert( hasSharedCacheTableLock(p, iTable, pKeyInfo!=0, (wrFlag?2:1))
76230 || iTable<1 );
76231 assert( wrFlag==0 || !hasReadConflicts(p, iTable) );
76239 if( iTable<=1 ){
76240 if( iTable<1 ){
76244 iTable = 0;
76250 pCur->pgnoRoot = iTable;
76259 if( pX->pgnoRoot==iTable ){
76278 Pgno iTable, /* Root page of table to open */
76285 rc = btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
76291 Pgno iTable, /* Root page of table to open */
76297 return btreeCursorWithLock(p, iTable, wrFlag, pKeyInfo, pCur);
76299 return btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
81759 SQLITE_PRIVATE int sqlite3BtreeClearTable(Btree *p, int iTable, i64 *pnChange){
81765 rc = saveAllCursors(pBt, (Pgno)iTable, 0);
81772 invalidateIncrblobCursors(p, (Pgno)iTable, 0, 1);
81774 rc = clearDatabasePage(pBt, (Pgno)iTable, 0, pnChange);
81809 static int btreeDropTable(Btree *p, Pgno iTable, int *piMoved){
81816 assert( iTable>=2 );
81817 if( iTable>btreePagecount(pBt) ){
81818 return SQLITE_CORRUPT_PGNO(iTable);
81821 rc = sqlite3BtreeClearTable(p, iTable, 0);
81823 rc = btreeGetPage(pBt, (Pgno)iTable, &pPage, 0);
81839 if( iTable==maxRootPgno ){
81859 rc = relocatePage(pBt, pMove, PTRMAP_ROOTPAGE, 0, iTable, 0);
81894 SQLITE_PRIVATE int sqlite3BtreeDropTable(Btree *p, int iTable, int *piMoved){
81897 rc = btreeDropTable(p, iTable, piMoved);
87739 sqlite3_str_appendf(p, "r[%d]", pExpr->iTable);
91323 assert( (pWalker->u.aMem[pExpr->iTable].flags & MEM_Undefined)==0 );
108250 pNew->iTable = pMatch->iCursor;
108340 pExpr->iTable = -1;
108537 pExpr->iTable = pMatch->iCursor;
108565 pExpr->iTable = op!=TK_DELETE;
108569 pExpr->iTable = 1;
108572 pExpr->iTable = 0;
108582 pExpr->iTable = EXCLUDED_TABLE_NUMBER;
108605 if( pExpr->iTable==EXCLUDED_TABLE_NUMBER ){
108613 pExpr->iTable = pNC->uNC.pUpsert->regData +
108626 pExpr->iTable = pNC->uNC.iBaseReg + (pTab->nCol+1)*pExpr->iTable +
108634 }else if( pExpr->iTable==0 ){
108901 p->iTable = pItem->iCursor;
109020 pExpr->iTable = pItem->iCursor;
109174 pExpr->iTable = exprProbability(pList->a[1].pExpr);
109175 if( pExpr->iTable<0 ){
109191 pExpr->iTable = pDef->zName[0]=='u' ? 8388608 : 125829120;
110414 assert( pExpr->iColumn < pExpr->iTable );
110416 assert( pExpr->iTable==pExpr->pLeft->x.pSelect->pEList->nExpr );
110947 pRet->iTable = nField;
111016 return pVector->iTable+iField;
112477 pFirst->iTable = pColumns->nId;
112840 if( pWalker->eCode==3 && pExpr->iTable==pWalker->u.iCur ){
113285 assert( p->iTable>=0 ); /* p cannot be part of a CHECK constraint */
113359 assert( pRes->iTable==pSrc->a[0].iCursor ); /* Not a correlated subquery */
113809 pExpr->iTable = pSig->iTable;
113896 assert( iTab!=pExpr->iTable );
113897 sqlite3VdbeAddOp2(v, OP_OpenDup, iTab, pExpr->iTable);
113917 pSig->iTable = iTab;
113931 pExpr->iTable = iTab;
113932 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pExpr->iTable, nVal);
114112 return pExpr->iTable;
114187 pExpr->iTable = rReg = dest.iSDParm;
114689 int iTable, /* The cursor pointing to the table */
114696 sqlite3ExprCodeGetColumnOfTable(pParse->pVdbe, pTab, iTable, iColumn, iReg);
114722 assert( p->iTable==iReg );
114726 p->iTable = iReg;
114822 if( pArg->op==TK_COLUMN && pArg->iTable>=0 ){
114823 sqlite3VdbeAddOp3(v, OP_Offset, pArg->iTable, pArg->iColumn, target);
114869 sqlite3ExprImpliesNonNullRow(pFarg->a[0].pExpr,pA1->iTable,1),
115034 if( pExpr->iColumn==p->iIdxCol && pExpr->iTable==p->iDataCur ){
115133 sqlite3VdbeAddOp3(v, OP_Column, pExpr->iTable, pExpr->iColumn, target);
115140 int iTab = pExpr->iTable;
115285 return pExpr->iTable;
115585 if( pLeft->iTable==0 || pParse->withinRJSubrtn > pLeft->op2 ){
115586 pLeft->iTable = sqlite3CodeSubselect(pParse, pLeft);
115591 if( pExpr->iTable!=n ){
115593 pExpr->iTable, n);
115595 return pLeft->iTable + pExpr->iColumn;
115682 p1 = pExpr->iTable * (pTab->nCol+1) + 1
115685 assert( pExpr->iTable==0 || pExpr->iTable==1 );
115692 (pExpr->iTable ? "new" : "old"),
115738 addrINR = sqlite3VdbeAddOp3(v, OP_IfNullRow, pExpr->iTable, 0, target);
116638 && pB->iTable<0 && pA->iTable==iTab
116688 if( pA->op!=TK_IN && pA->iTable!=pB->iTable && pA->iTable!=iTab ){
116978 if( pWalker->u.iCur==pExpr->iTable ){
117118 && pExpr->iTable==pWalker->u.pIdxCover->iCur
117218 if( pExpr->iTable==pSrc->a[i].iCursor ){
117223 for(i=0; i<p->nExclude && p->aiExclude[i]!=pExpr->iTable; i++){}
117390 if( pCol->iTable==pExpr->iTable
117410 pCol->iTable = pExpr->iTable;
117422 && pE->iTable==pExpr->iTable
117485 tmp.iTable = pIEpr->iIdxCur;
117508 if( pExpr->iTable==pItem->iCursor ){
122903 if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
126270 static void destroyRootPage(Parse *pParse, int iTable, int iDb){
126273 if( iTable<2 ) sqlite3ErrorMsg(pParse, "corrupt schema");
126274 sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb);
126289 pParse->db->aDb[iDb].zDbSName, iTable, r1, r1);
133813 pExpr->iTable = regBase + sqlite3TableColumnToStorage(pTab,iCol) + 1;
133819 pExpr->iTable = regBase;
133840 pExpr->iTable = iCursor;
145278 SQLITE_PRIVATE void sqlite3SetJoinExpr(Expr *p, int iTable, u32 joinFlag){
145284 p->w.iJoin = iTable;
145290 sqlite3SetJoinExpr(p->x.pList->a[i].pExpr, iTable, joinFlag);
145294 sqlite3SetJoinExpr(p->pLeft, iTable, joinFlag);
145313 static void unsetJoinExpr(Expr *p, int iTable, int nullable){
145315 if( iTable<0 || (ExprHasProperty(p, EP_OuterON) && p->w.iJoin==iTable) ){
145317 if( iTable>=0 ) ExprSetProperty(p, EP_InnerON);
145319 if( p->op==TK_COLUMN && p->iTable==iTable && !nullable ){
145328 unsetJoinExpr(p->x.pList->a[i].pExpr, iTable, nullable);
145332 unsetJoinExpr(p->pLeft, iTable, nullable);
145488 pEq->w.iJoin = pE2->iTable;
145929 if( pSort->aDefer[j].iCsr==pExpr->iTable ) break;
145945 pNew->iTable = pExpr->iTable;
145953 pSort->aDefer[nDefer].iCsr = pExpr->iTable;
146803 for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
148707 int iTable; /* Replace references to this table */
148737 && pExpr->w.iJoin==pSubst->iTable
148743 && pExpr->iTable==pSubst->iTable
148766 && (pCopy->op!=TK_COLUMN || pCopy->iTable!=pSubst->iNewTable)
148771 ifNullRow.iTable = pSubst->iNewTable;
148814 if( pExpr->op==TK_IF_NULL_ROW && pExpr->iTable==pSubst->iTable ){
148815 pExpr->iTable = pSubst->iNewTable;
148886 if( pItem->iCursor!=pExpr->iTable ) return WRC_Continue;
148963 renumberCursorDoMapping(pWalker, &pExpr->iTable);
149609 x.iTable = iParent;
149702 if( pE2->iTable==pColumn->iTable
149782 if( pColumn->iTable!=pExpr->iTable ) continue;
150194 x.iTable = pSrc->iCursor;
151415 pCol->iTable, pCol->iColumn, pAggInfo->iFirstReg+ii,
151535 pExpr->iTable = pCol->iTable;
156949 sCol[1].iTable = pTabList->a[0].iCursor;
160656 && pExpr->iTable==pHint->iTabCur
160719 if( pExpr->iTable!=pHint->iTabCur ){
160723 pExpr->iTable = reg;
160725 pExpr->iTable = pHint->iIdxCur;
160734 pExpr->iTable = reg;
161270 pRight->iTable = iReg+j+2;
162624 pTerm->truthProb = sqlite3LogEst(p->iTable) - 270;
163609 aiCurCol[0] = pExpr->iTable;
163883 pNewTerm->leftCursor = pLeft->iTable;
164085 pNewTerm->leftCursor = pLeft->iTable;
164174 pVal->iTable = iReg;
164241 if( pExpr->iTable!=iCsr ) return;
164350 mask = (p->op==TK_IF_NULL_ROW) ? sqlite3WhereGetMask(pMaskSet, p->iTable) : 0;
164373 return sqlite3WhereGetMask(pMaskSet, p->iTable);
164446 pColRef->iTable = pItem->iCursor;
164850 if( pScan->aiCur[j]==pX->iTable
164856 pScan->aiCur[j] = pX->iTable;
164888 && pX->iTable==pScan->aiCur[0]
165066 && p->iTable==iBase
165130 if( p->iTable==iBase && p->iColumn<0 ) return 1;
165954 if( pExpr->op==TK_COLUMN && pExpr->iTable==pSrc->iCursor ){
165963 && pE2->iTable==pSrc->iCursor
167546 || pLhs->iTable!=iCur
168044 && pExpr->iTable==iCursor
168155 if( pExpr->iTable!=pCk->iTabCur ) return WRC_Continue;
169439 if( pOBExpr->iTable!=iCur ) break;
169583 if( pOBExpr->iTable!=iCur ) continue;
169729 if( pOBExpr->iTable!=iCur ) continue;
172920 if( pExpr->iTable==p->pSrc->a[i].iCursor ) break;
172971 pExpr->iTable = p->pWin->iEphCsr;
175459 p->iTable = 0;
179733 if( yymsp[0].minor.yy590 ) sqlite3GetInt32(&t.z[1], &yymsp[0].minor.yy590->iTable);