Lines Matching refs:iTable
8314 int iTable, /* Index of root page */
10448 int iTable; /* Cursor number of the source table */
10510 ** For such expressions, Expr.op is set to TK_COLUMN and Expr.iTable is
10518 ** character '?' in the original SQL) then the Expr.iTable holds the index
10523 ** subquery gives a constant result, then iTable is -1. If the subquery
10525 ** then iTable is the address of a subroutine that computes the subquery.
10573 int iTable; /* TK_COLUMN: cursor number of table holding column
10642 #define EXPR_REDUCEDSIZE offsetof(Expr,iTable) /* Common features */
11109 int iTable; /* Table cursor number */
48745 ** is opened on the table with root page BtShared.iTable. Locks are removed
48751 Pgno iTable; /* Root page of table */
49535 && (pLock->iTable==iTab || (pLock->eLock==WRITE_LOCK && pLock->iTable==1))
49627 if( pIter->pBtree!=p && pIter->iTable==iTab && pIter->eLock!=eLock ){
49642 ** Add a lock on the table with root-page iTable to the shared-btree used
49658 iTable, u8 eLock){
49676 assert( SQLITE_OK==querySharedCacheTableLock(p, iTable, eLock) );
49680 if( pIter->iTable==iTable && pIter->pBtree==p ){
49687 ** with table iTable, allocate one and link it into the list.
49694 pLock->iTable = iTable;
49736 assert( pLock->iTable!=1 || pLock==&p->lock );
49737 if( pLock->iTable!=1 ){
51116 p->lock.iTable = 1;
51996 assert( p->lock.pBtree==p && p->lock.iTable==1 );
52791 ** iTable. If a read-only cursor is requested, it is assumed that
52814 ** No checking is done to make sure that page iTable really is the
52823 int iTable, /* Root page of table to open */
52837 assert( hasSharedCacheTableLock(p, iTable, pKeyInfo!=0, wrFlag+1) );
52838 assert( wrFlag==0 || !hasReadConflicts(p, iTable) );
52848 if( iTable==1 && btreePagecount(pBt)==0 ){
52850 iTable = 0;
52855 pCur->pgnoRoot = (Pgno)iTable;
52872 int iTable, /* Root page of table to open */
52879 rc = btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
56580 ** Delete all information from a single table in the database. iTable is
56588 ** If pnChange is not NULL, then table iTable must be an intkey table. The
56592 SQLITE_PRIVATE int sqlite3BtreeClearTable(Btree *p, int iTable, int *pnChange){
56598 /* Invalidate all incrblob cursors open on table iTable (assuming iTable
56603 rc = saveAllCursors(pBt, (Pgno)iTable, 0);
56605 rc = clearDatabasePage(pBt, (Pgno)iTable, 0, pnChange);
56619 ** If AUTOVACUUM is enabled and the page at iTable is not the last
56622 ** iTable and that last slot formerly occupied by the last root page
56623 ** is added to the freelist instead of iTable. In this say, all
56631 static int btreeDropTable(Btree *p, Pgno iTable, int *piMoved){
56652 rc = btreeGetPage(pBt, (Pgno)iTable, &pPage, 0);
56654 rc = sqlite3BtreeClearTable(p, iTable, 0);
56662 if( iTable>1 ){
56671 if( iTable==maxRootPgno ){
56691 rc = relocatePage(pBt, pMove, PTRMAP_ROOTPAGE, 0, iTable, 0);
56734 SQLITE_PRIVATE int sqlite3BtreeDropTable(Btree *p, int iTable, int *piMoved){
56737 rc = btreeDropTable(p, iTable, piMoved);
73237 pDup->iTable = pEList->a[iCol].iAlias;
73293 ** pExpr->iTable Set to the cursor number for the table obtained
73335 pExpr->iTable = -1;
73369 pExpr->iTable = pItem->iCursor;
73385 pExpr->iTable = pItem->iCursor;
73406 pExpr->iTable = 1;
73409 pExpr->iTable = 0;
73433 }else if( pExpr->iTable==0 ){
73547 assert( pMatch->iCursor==pExpr->iTable );
73585 p->iTable = pItem->iCursor;
73644 pExpr->iTable = pItem->iCursor;
74299 ** Expr.iTable The VDBE cursor number for X.Y
75708 assert( p->iTable>=0 ); /* p cannot be part of a CHECK constraint */
75787 ** or ephermal table) is stored in pX->iTable before this function returns.
75944 pX->iTable = iTab;
76046 pExpr->iTable = pParse->nTab++;
76047 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pExpr->iTable, !isRowid);
76062 sqlite3SelectDestInit(&dest, SRT_Set, pExpr->iTable);
76064 assert( (pExpr->iTable&0x0000FFFF)==pExpr->iTable );
76112 sqlite3VdbeAddOp3(v, OP_InsertInt, pExpr->iTable, r2, iValToIns);
76118 sqlite3VdbeAddOp3(v, OP_Insert, pExpr->iTable, r2, r3);
76122 sqlite3VdbeAddOp2(v, OP_IdxInsert, pExpr->iTable, r2);
76216 ** pExpr->iTable will contains the values that make up the RHS.
76244 sqlite3VdbeAddOp2(v, OP_Rewind, pExpr->iTable, destIfFalse);
76253 sqlite3VdbeAddOp3(v, OP_NotExists, pExpr->iTable, destIfFalse, r1);
76273 sqlite3VdbeAddOp4Int(v, OP_NotFound, pExpr->iTable, destIfFalse, r1, 1);
76286 j1 = sqlite3VdbeAddOp4Int(v, OP_Found, pExpr->iTable, 0, r1, 1);
76295 j3 = sqlite3VdbeAddOp4Int(v, OP_Found, pExpr->iTable, 0, rRhsHasNull, 1);
76427 if( p->iReg && p->iTable==iTab && p->iColumn==iCol ){
76435 assert( p->iReg==0 || p->iTable!=iTab || p->iColumn!=iCol );
76443 p->iTable = iTab;
76464 p->iTable = iTab;
76561 ** There must be an open cursor to pTab in iTable when this routine
76568 int iTable, /* The cursor pointing to the table */
76576 if( p->iReg>0 && p->iTable==iTable && p->iColumn==iColumn ){
76583 sqlite3ExprCodeGetColumnOfTable(v, pTab, iTable, iColumn, iReg);
76584 sqlite3ExprCacheStore(pParse, iTable, iColumn, iReg);
76706 if( pExpr->iTable<0 ){
76712 pExpr->iColumn, pExpr->iTable, target);
76765 inReg = pExpr->iTable;
77099 ** trigger programs. In this case Expr.iTable is set to 1 for the
77123 int p1 = pExpr->iTable * (pTab->nCol+1) + 1 + pExpr->iColumn;
77125 assert( pExpr->iTable==0 || pExpr->iTable==1 );
77132 (pExpr->iTable ? "new" : "old"),
77195 cacheX.iTable = sqlite3ExprCodeTemp(pParse, pX, ®Free1);
77300 sqlite3VdbeAddOp2(pParse->pVdbe, OP_Copy, pExpr->iTable, target);
77338 pExpr->iTable = iMem;
77361 pExpr->iTable, pExpr->iColumn);
77365 if( pExpr->iTable<0 ){
77370 pExpr->iTable, pExpr->iColumn);
77408 sqlite3ExplainPrintf(pOut,"REGISTER(%d)", pExpr->iTable);
77532 ** trigger programs. In this case Expr.iTable is set to 1 for the
77538 pExpr->iTable ? "NEW" : "OLD", pExpr->iColumn);
77701 pExpr->iTable = r2;
77799 exprX.iTable = sqlite3ExprCodeTemp(pParse, &exprX, ®Free1);
78119 if( pA->iTable!=pB->iTable || pA->iColumn!=pB->iColumn ) return 2;
78217 if( pExpr->iTable==pItem->iCursor ){
78227 if( pCol->iTable==pExpr->iTable &&
78237 pCol->iTable = pExpr->iTable;
78249 if( pE->op==TK_COLUMN && pE->iTable==pExpr->iTable &&
78270 } /* endif pExpr->iTable==pItem->iCursor */
81106 if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
83092 ** Write code to erase the table with root-page iTable from database iDb.
83095 ** erasing iTable (this can happen with an auto-vacuum database).
83097 static void destroyRootPage(Parse *pParse, int iTable, int iDb){
83100 sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb);
83105 ** location iTable. The following code modifies the sqlite_master table to
83114 pParse->db->aDb[iDb].zName, SCHEMA_TABLE(iDb), iTable, r1, r1);
88258 pLeft->iTable = regData+iCol+1;
88262 pLeft->iTable = regData;
88285 pLeft->iTable = regData;
88287 pRight->iTable = pSrc->a[0].iCursor;
94770 pEq->iRightJoinTable = (i16)pE2->iTable;
94777 ** And set the Expr.iRightJoinTable to iTable for every term in the
94801 static void setJoinExpr(Expr *p, int iTable){
94806 p->iRightJoinTable = (i16)iTable;
94807 setJoinExpr(p->pLeft, iTable);
95531 for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
95705 if( pTabList->a[j].iCursor==p->iTable ) break;
97014 ** a column in table number iTable with a copy of the iColumn-th
97021 ** FORM clause entry is iTable. This routine make the necessary
97028 int iTable, /* Table to be substituted */
97032 if( pExpr->op==TK_COLUMN && pExpr->iTable==iTable ){
97047 pExpr->pLeft = substExpr(db, pExpr->pLeft, iTable, pEList);
97048 pExpr->pRight = substExpr(db, pExpr->pRight, iTable, pEList);
97050 substSelect(db, pExpr->x.pSelect, iTable, pEList);
97052 substExprList(db, pExpr->x.pList, iTable, pEList);
97060 int iTable, /* Table to be substituted */
97066 pList->a[i].pExpr = substExpr(db, pList->a[i].pExpr, iTable, pEList);
97072 int iTable, /* Table to be replaced */
97079 substExprList(db, p->pEList, iTable, pEList);
97080 substExprList(db, p->pGroupBy, iTable, pEList);
97081 substExprList(db, p->pOrderBy, iTable, pEList);
97082 p->pHaving = substExpr(db, p->pHaving, iTable, pEList);
97083 p->pWhere = substExpr(db, p->pWhere, iTable, pEList);
97084 substSelect(db, p->pPrior, iTable, pEList);
97089 substSelect(db, pItem->pSelect, iTable, pEList);
98732 pCol->pTab, pCol->iColumn, pCol->iTable, r1);
102710 ** SrcList_item.iCursor and Expr.iTable fields. For any given WHERE
102979 ** sets their opcodes to TK_COLUMN and their Expr.iTable fields to
102990 mask = getMask(pMaskSet, p->iTable);
103705 pTerm->leftCursor = pLeft->iTable;
103732 pNew->leftCursor = pLeft->iTable;
103879 pNewTerm->leftCursor = pLeft->iTable;
103920 pNewTerm->leftCursor = pLeft->iTable;
103981 && p->iTable==iBase
104031 pTerm = findTerm(pWC, p->iTable, p->iColumn, ~(Bitmask)0, WO_EQ, 0);
104038 if( p->iTable!=base ) return 0;
104077 ** true. Note: The (p->iTable==iBase) part of this test may be false if the
104082 if( p->op==TK_COLUMN && p->iTable==iBase && p->iColumn<0 ) return 1;
104178 if( pExpr->op!=TK_COLUMN || pExpr->iTable!=base ){
104715 if( pExpr->op!=TK_COLUMN || pExpr->iTable!=pSrc->iCursor ) break;
106031 iTab = pX->iTable;
110464 if( yygotominor.yy342.pExpr ) sqlite3GetInt32(&yymsp[0].minor.yy0.z[1], &yygotominor.yy342.pExpr->iTable);
