Lines Matching defs:iTable
7766 int iTable, /* Index of root page */
9882 int iTable; /* Cursor number of the source table */
9946 ** For such expressions, Expr.op is set to TK_COLUMN and Expr.iTable is
9954 ** character '?' in the original SQL) then the Expr.iTable holds the index
9959 ** subquery gives a constant result, then iTable is -1. If the subquery
9961 ** then iTable is the address of a subroutine that computes the subquery.
10009 int iTable; /* TK_COLUMN: cursor number of table holding column
10078 #define EXPR_REDUCEDSIZE offsetof(Expr,iTable) /* Common features */
10538 int iTable; /* Table cursor number */
46508 ** is opened on the table with root page BtShared.iTable. Locks are removed
46514 Pgno iTable; /* Root page of table */
47290 && (pLock->iTable==iTab || (pLock->eLock==WRITE_LOCK && pLock->iTable==1))
47382 if( pIter->pBtree!=p && pIter->iTable==iTab && pIter->eLock!=eLock ){
47397 ** Add a lock on the table with root-page iTable to the shared-btree used
47413 static int setSharedCacheTableLock(Btree *p, Pgno iTable, u8 eLock){
47431 assert( SQLITE_OK==querySharedCacheTableLock(p, iTable, eLock) );
47435 if( pIter->iTable==iTable && pIter->pBtree==p ){
47442 ** with table iTable, allocate one and link it into the list.
47449 pLock->iTable = iTable;
47491 assert( pLock->iTable!=1 || pLock==&p->lock );
47492 if( pLock->iTable!=1 ){
48865 p->lock.iTable = 1;
49729 assert( p->lock.pBtree==p && p->lock.iTable==1 );
50524 ** iTable. If a read-only cursor is requested, it is assumed that
50547 ** No checking is done to make sure that page iTable really is the
50556 int iTable, /* Root page of table to open */
50570 assert( hasSharedCacheTableLock(p, iTable, pKeyInfo!=0, wrFlag+1) );
50571 assert( wrFlag==0 || !hasReadConflicts(p, iTable) );
50581 if( iTable==1 && btreePagecount(pBt)==0 ){
50587 pCur->pgnoRoot = (Pgno)iTable;
50604 int iTable, /* Root page of table to open */
50611 rc = btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
54217 ** Delete all information from a single table in the database. iTable is
54225 ** If pnChange is not NULL, then table iTable must be an intkey table. The
54229 SQLITE_PRIVATE int sqlite3BtreeClearTable(Btree *p, int iTable, int *pnChange){
54235 /* Invalidate all incrblob cursors open on table iTable (assuming iTable
54240 rc = saveAllCursors(pBt, (Pgno)iTable, 0);
54242 rc = clearDatabasePage(pBt, (Pgno)iTable, 0, pnChange);
54256 ** If AUTOVACUUM is enabled and the page at iTable is not the last
54259 ** iTable and that last slot formerly occupied by the last root page
54260 ** is added to the freelist instead of iTable. In this say, all
54268 static int btreeDropTable(Btree *p, Pgno iTable, int *piMoved){
54289 rc = btreeGetPage(pBt, (Pgno)iTable, &pPage, 0);
54291 rc = sqlite3BtreeClearTable(p, iTable, 0);
54299 if( iTable>1 ){
54308 if( iTable==maxRootPgno ){
54328 rc = relocatePage(pBt, pMove, PTRMAP_ROOTPAGE, 0, iTable, 0);
54371 SQLITE_PRIVATE int sqlite3BtreeDropTable(Btree *p, int iTable, int *piMoved){
54374 rc = btreeDropTable(p, iTable, piMoved);
69602 pDup->iTable = pEList->a[iCol].iAlias;
69640 ** pExpr->iTable Set to the cursor number for the table obtained
69682 pExpr->iTable = -1;
69716 pExpr->iTable = pItem->iCursor;
69725 pExpr->iTable = pItem->iCursor;
69766 pExpr->iTable = 1;
69769 pExpr->iTable = 0;
69793 }else if( pExpr->iTable==0 ){
69907 assert( pMatch->iCursor==pExpr->iTable );
69945 p->iTable = pItem->iCursor;
70004 pExpr->iTable = pItem->iCursor;
70645 ** Expr.iTable The VDBE cursor number for X.Y
72047 assert( p->iTable>=0 ); /* p cannot be part of a CHECK constraint */
72117 ** or ephermal table) is stored in pX->iTable before this function returns.
72268 pX->iTable = iTab;
72373 pExpr->iTable = pParse->nTab++;
72374 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pExpr->iTable, !isRowid);
72389 sqlite3SelectDestInit(&dest, SRT_Set, pExpr->iTable);
72391 assert( (pExpr->iTable&0x0000FFFF)==pExpr->iTable );
72439 sqlite3VdbeAddOp3(v, OP_InsertInt, pExpr->iTable, r2, iValToIns);
72445 sqlite3VdbeAddOp3(v, OP_Insert, pExpr->iTable, r2, r3);
72449 sqlite3VdbeAddOp2(v, OP_IdxInsert, pExpr->iTable, r2);
72543 ** pExpr->iTable will contains the values that make up the RHS.
72571 sqlite3VdbeAddOp2(v, OP_Rewind, pExpr->iTable, destIfFalse);
72580 sqlite3VdbeAddOp3(v, OP_NotExists, pExpr->iTable, destIfFalse, r1);
72600 sqlite3VdbeAddOp4Int(v, OP_NotFound, pExpr->iTable, destIfFalse, r1, 1);
72613 j1 = sqlite3VdbeAddOp4Int(v, OP_Found, pExpr->iTable, 0, r1, 1);
72622 j3 = sqlite3VdbeAddOp4Int(v, OP_Found, pExpr->iTable, 0, rRhsHasNull, 1);
72754 if( p->iReg && p->iTable==iTab && p->iColumn==iCol ){
72762 assert( p->iReg==0 || p->iTable!=iTab || p->iColumn!=iCol );
72770 p->iTable = iTab;
72791 p->iTable = iTab;
72888 ** There must be an open cursor to pTab in iTable when this routine
72895 int iTable, /* The cursor pointing to the table */
72903 if( p->iReg>0 && p->iTable==iTable && p->iColumn==iColumn ){
72910 sqlite3ExprCodeGetColumnOfTable(v, pTab, iTable, iColumn, iReg);
72911 sqlite3ExprCacheStore(pParse, iTable, iColumn, iReg);
73033 if( pExpr->iTable<0 ){
73039 pExpr->iColumn, pExpr->iTable, target);
73090 inReg = pExpr->iTable;
73424 ** trigger programs. In this case Expr.iTable is set to 1 for the
73448 int p1 = pExpr->iTable * (pTab->nCol+1) + 1 + pExpr->iColumn;
73450 assert( pExpr->iTable==0 || pExpr->iTable==1 );
73457 (pExpr->iTable ? "new" : "old"),
73520 cacheX.iTable = sqlite3ExprCodeTemp(pParse, pX, ®Free1);
73625 sqlite3VdbeAddOp2(pParse->pVdbe, OP_Copy, pExpr->iTable, target);
73663 pExpr->iTable = iMem;
73768 pExpr->iTable = r2;
73866 exprX.iTable = sqlite3ExprCodeTemp(pParse, &exprX, ®Free1);
74186 if( pA->iTable!=pB->iTable || pA->iColumn!=pB->iColumn ) return 2;
74288 if( pExpr->iTable==pItem->iCursor ){
74298 if( pCol->iTable==pExpr->iTable &&
74308 pCol->iTable = pExpr->iTable;
74320 if( pE->op==TK_COLUMN && pE->iTable==pExpr->iTable &&
74341 } /* endif pExpr->iTable==pItem->iCursor */
76749 if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
78738 ** Write code to erase the table with root-page iTable from database iDb.
78741 ** erasing iTable (this can happen with an auto-vacuum database).
78743 static void destroyRootPage(Parse *pParse, int iTable, int iDb){
78746 sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb);
78751 ** location iTable. The following code modifies the sqlite_master table to
78760 pParse->db->aDb[iDb].zName, SCHEMA_TABLE(iDb), iTable, r1, r1);
83797 pLeft->iTable = regData+iCol+1;
83801 pLeft->iTable = regData;
83824 pLeft->iTable = regData;
83826 pRight->iTable = pSrc->a[0].iCursor;
90186 pEq->iRightJoinTable = (i16)pE2->iTable;
90193 ** And set the Expr.iRightJoinTable to iTable for every term in the
90217 static void setJoinExpr(Expr *p, int iTable){
90222 p->iRightJoinTable = (i16)iTable;
90223 setJoinExpr(p->pLeft, iTable);
90926 for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
91100 if( pTabList->a[j].iCursor==p->iTable ) break;
92402 ** a column in table number iTable with a copy of the iColumn-th
92409 ** FORM clause entry is iTable. This routine make the necessary
92416 int iTable, /* Table to be substituted */
92420 if( pExpr->op==TK_COLUMN && pExpr->iTable==iTable ){
92435 pExpr->pLeft = substExpr(db, pExpr->pLeft, iTable, pEList);
92436 pExpr->pRight = substExpr(db, pExpr->pRight, iTable, pEList);
92438 substSelect(db, pExpr->x.pSelect, iTable, pEList);
92440 substExprList(db, pExpr->x.pList, iTable, pEList);
92448 int iTable, /* Table to be substituted */
92454 pList->a[i].pExpr = substExpr(db, pList->a[i].pExpr, iTable, pEList);
92460 int iTable, /* Table to be replaced */
92467 substExprList(db, p->pEList, iTable, pEList);
92468 substExprList(db, p->pGroupBy, iTable, pEList);
92469 substExprList(db, p->pOrderBy, iTable, pEList);
92470 p->pHaving = substExpr(db, p->pHaving, iTable, pEList);
92471 p->pWhere = substExpr(db, p->pWhere, iTable, pEList);
92472 substSelect(db, p->pPrior, iTable, pEList);
92477 substSelect(db, pItem->pSelect, iTable, pEList);
94015 pCol->pTab, pCol->iColumn, pCol->iTable, r1);
97822 ** SrcList_item.iCursor and Expr.iTable fields. For any given WHERE
98087 ** sets their opcodes to TK_COLUMN and their Expr.iTable fields to
98098 mask = getMask(pMaskSet, p->iTable);
98802 pTerm->leftCursor = pLeft->iTable;
98829 pNew->leftCursor = pLeft->iTable;
98976 pNewTerm->leftCursor = pLeft->iTable;
99017 pNewTerm->leftCursor = pLeft->iTable;
99116 if( pExpr->op!=TK_COLUMN || pExpr->iTable!=base ){
99642 if( pExpr->op!=TK_COLUMN || pExpr->iTable!=pSrc->iCursor ) break;
100943 iTab = pX->iTable;
105279 if( yygotominor.yy118.pExpr ) sqlite3GetInt32(&yymsp[0].minor.yy0.z[1], &yygotominor.yy118.pExpr->iTable);
