Lines Matching refs:iTable
8987 int iTable, /* Index of root page */
11252 int iTable; /* Cursor number of the source table */ member
11379 int iTable; /* TK_COLUMN: cursor number of table holding column member
11443 #define EXPR_REDUCEDSIZE offsetof(Expr,iTable) /* Common features */
11938 int iTable; /* Table cursor number */ member
50944 Pgno iTable; /* Root page of table */
51763 && (pLock->iTable==iTab || (pLock->eLock==WRITE_LOCK && pLock->iTable==1))
51855 if( pIter->pBtree!=p && pIter->iTable==iTab && pIter->eLock!=eLock ){
51886 static int setSharedCacheTableLock(Btree *p, Pgno iTable, u8 eLock){
51904 assert( SQLITE_OK==querySharedCacheTableLock(p, iTable, eLock) );
51908 if( pIter->iTable==iTable && pIter->pBtree==p ){
51922 pLock->iTable = iTable;
51964 assert( pLock->iTable!=1 || pLock==&p->lock );
51965 if( pLock->iTable!=1 ){
53374 p->lock.iTable = 1;
54341 assert( p->lock.pBtree==p && p->lock.iTable==1 );
55172 int iTable, /* Root page of table to open */
55186 assert( hasSharedCacheTableLock(p, iTable, pKeyInfo!=0, wrFlag+1) );
55187 assert( wrFlag==0 || !hasReadConflicts(p, iTable) );
55197 if( iTable==1 && btreePagecount(pBt)==0 ){
55199 iTable = 0;
55204 pCur->pgnoRoot = (Pgno)iTable;
55221 int iTable, /* Root page of table to open */
55228 rc = btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
59021 SQLITE_PRIVATE int sqlite3BtreeClearTable(Btree *p, int iTable, int *pnChange){
59027 rc = saveAllCursors(pBt, (Pgno)iTable, 0);
59034 rc = clearDatabasePage(pBt, (Pgno)iTable, 0, pnChange);
59069 static int btreeDropTable(Btree *p, Pgno iTable, int *piMoved){
59090 rc = btreeGetPage(pBt, (Pgno)iTable, &pPage, 0);
59092 rc = sqlite3BtreeClearTable(p, iTable, 0);
59100 if( iTable>1 ){
59109 if( iTable==maxRootPgno ){
59129 rc = relocatePage(pBt, pMove, PTRMAP_ROOTPAGE, 0, iTable, 0);
59172 SQLITE_PRIVATE int sqlite3BtreeDropTable(Btree *p, int iTable, int *piMoved){
59175 rc = btreeDropTable(p, iTable, piMoved);
62434 printf(" r[%d]={%d:%d}", x->iReg, x->iTable, x->iColumn);
76912 pDup->iTable = pEList->a[iCol].u.x.iAlias;
77036 pExpr->iTable = -1;
77119 pExpr->iTable = pMatch->iCursor;
77133 pExpr->iTable = 1;
77136 pExpr->iTable = 0;
77163 }else if( pExpr->iTable==0 ){
77288 assert( pMatch->iCursor==pExpr->iTable );
77328 p->iTable = pItem->iCursor;
77433 pExpr->iTable = pItem->iCursor;
77501 pExpr->iTable = exprProbability(pList->a[1].pExpr);
77502 if( pExpr->iTable<0 ){
77517 pExpr->iTable = pDef->zName[0]=='u' ? 62 : 938;
79683 assert( p->iTable>=0 ); /* p cannot be part of a CHECK constraint */
79978 pX->iTable = iTab;
80070 pExpr->iTable = pParse->nTab++;
80071 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pExpr->iTable, !isRowid);
80085 sqlite3SelectDestInit(&dest, SRT_Set, pExpr->iTable);
80087 assert( (pExpr->iTable&0x0000FFFF)==pExpr->iTable );
80144 sqlite3VdbeAddOp3(v, OP_InsertInt, pExpr->iTable, r2, iValToIns);
80151 sqlite3VdbeAddOp3(v, OP_Insert, pExpr->iTable, r2, r3);
80155 sqlite3VdbeAddOp2(v, OP_IdxInsert, pExpr->iTable, r2);
80210 sqlite3SetHasNullFlag(v, pExpr->iTable, rHasNullFlag);
80327 sqlite3VdbeAddOp2(v, OP_Rewind, pExpr->iTable, destIfFalse);
80338 sqlite3VdbeAddOp3(v, OP_NotExists, pExpr->iTable, destIfFalse, r1);
80360 sqlite3VdbeAddOp4Int(v, OP_NotFound, pExpr->iTable, destIfFalse, r1, 1);
80375 j1 = sqlite3VdbeAddOp4Int(v, OP_Found, pExpr->iTable, 0, r1, 1);
80504 assert( p->iReg==0 || p->iTable!=iTab || p->iColumn!=iCol );
80512 p->iTable = iTab;
80533 p->iTable = iTab;
80650 int iTable, /* The cursor pointing to the table */
80659 if( p->iReg>0 && p->iTable==iTable && p->iColumn==iColumn ){
80666 sqlite3ExprCodeGetColumnOfTable(v, pTab, iTable, iColumn, iReg);
80670 sqlite3ExprCacheStore(pParse, iTable, iColumn, iReg);
80745 p->iTable = iReg;
80797 int iTab = pExpr->iTable;
80862 inReg = pExpr->iTable;
81240 int p1 = pExpr->iTable * (pTab->nCol+1) + 1 + pExpr->iColumn;
81242 assert( pExpr->iTable==0 || pExpr->iTable==1 );
81249 (pExpr->iTable ? "new" : "old"),
81461 sqlite3VdbeAddOp2(pParse->pVdbe, OP_Copy, pExpr->iTable, target);
81525 pExpr->iTable, pExpr->iColumn);
81529 if( pExpr->iTable<0 ){
81534 pExpr->iTable, pExpr->iColumn);
81572 sqlite3ExplainPrintf(pOut,"REGISTER(%d)", pExpr->iTable);
81710 pExpr->iTable ? "NEW" : "OLD", pExpr->iColumn);
82228 if( pA->iTable!=pB->iTable
82229 && (pA->iTable!=iTab || NEVER(pB->iTable>=0)) ) return 2;
82329 if( pExpr->iTable==pSrc->a[i].iCursor ) break;
82416 if( pExpr->iTable==pItem->iCursor ){
82426 if( pCol->iTable==pExpr->iTable &&
82436 pCol->iTable = pExpr->iTable;
82448 if( pE->op==TK_COLUMN && pE->iTable==pExpr->iTable &&
86049 if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
88356 static void destroyRootPage(Parse *pParse, int iTable, int iDb){
88359 sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb);
88373 pParse->db->aDb[iDb].zName, SCHEMA_TABLE(iDb), iTable, r1, r1);
93941 pExpr->iTable = regBase + iCol + 1;
93947 pExpr->iTable = regBase;
93967 pExpr->iTable = iCursor;
101801 pEq->iRightJoinTable = (i16)pE2->iTable;
101832 static void setJoinExpr(Expr *p, int iTable){
101837 p->iRightJoinTable = (i16)iTable;
101838 setJoinExpr(p->pLeft, iTable);
102790 for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
102977 if( pTabList->a[j].iCursor==p->iTable ) break;
104479 int iTable, /* Table to be substituted */
104483 if( pExpr->op==TK_COLUMN && pExpr->iTable==iTable ){
104495 pExpr->pLeft = substExpr(db, pExpr->pLeft, iTable, pEList);
104496 pExpr->pRight = substExpr(db, pExpr->pRight, iTable, pEList);
104498 substSelect(db, pExpr->x.pSelect, iTable, pEList);
104500 substExprList(db, pExpr->x.pList, iTable, pEList);
104508 int iTable, /* Table to be substituted */
104514 pList->a[i].pExpr = substExpr(db, pList->a[i].pExpr, iTable, pEList);
104520 int iTable, /* Table to be replaced */
104527 substExprList(db, p->pEList, iTable, pEList);
104528 substExprList(db, p->pGroupBy, iTable, pEList);
104529 substExprList(db, p->pOrderBy, iTable, pEList);
104530 p->pHaving = substExpr(db, p->pHaving, iTable, pEList);
104531 p->pWhere = substExpr(db, p->pWhere, iTable, pEList);
104532 substSelect(db, p->pPrior, iTable, pEList);
104537 substSelect(db, pItem->pSelect, iTable, pEList);
106499 pCol->pTab, pCol->iColumn, pCol->iTable, r1, 0);
111190 pTerm->truthProb = sqlite3LogEst(p->iTable) - 99;
111273 mask = getMask(pMaskSet, p->iTable);
111427 if( pScan->aEquiv[j]==pX->iTable
111433 pScan->aEquiv[j] = pX->iTable;
111457 && pX->iTable==pScan->aEquiv[0]
112108 pTerm->leftCursor = pLeft->iTable;
112143 pNew->leftCursor = pLeft->iTable;
112293 pNewTerm->leftCursor = pLeft->iTable;
112335 pNewTerm->leftCursor = pLeft->iTable;
112374 && p->iTable==iBase
112417 if( p->op==TK_COLUMN && p->iTable==iBase && p->iColumn<0 ) return 1;
112730 if( pExpr->op!=TK_COLUMN || pExpr->iTable!=pSrc->iCursor ) break;
113491 iTab = pX->iTable;
115486 if( pExpr->iTable==iCursor ){
116166 if( pOBExpr->iTable!=iCur ) continue;
116253 if( pOBExpr->iTable!=iCur ) continue;
120236 …otominor.yy346.pExpr ) sqlite3GetInt32(&yymsp[0].minor.yy0.z[1], &yygotominor.yy346.pExpr->iTable);