Lines Matching refs:iTable
8028 int iTable, /* Index of root page */
10150 int iTable; /* Cursor number of the source table */ member
10277 int iTable; /* TK_COLUMN: cursor number of table holding column member
10346 #define EXPR_REDUCEDSIZE offsetof(Expr,iTable) /* Common features */
10806 int iTable; /* Table cursor number */ member
46910 Pgno iTable; /* Root page of table */
47686 && (pLock->iTable==iTab || (pLock->eLock==WRITE_LOCK && pLock->iTable==1))
47778 if( pIter->pBtree!=p && pIter->iTable==iTab && pIter->eLock!=eLock ){
47809 static int setSharedCacheTableLock(Btree *p, Pgno iTable, u8 eLock){
47827 assert( SQLITE_OK==querySharedCacheTableLock(p, iTable, eLock) );
47831 if( pIter->iTable==iTable && pIter->pBtree==p ){
47845 pLock->iTable = iTable;
47887 assert( pLock->iTable!=1 || pLock==&p->lock );
47888 if( pLock->iTable!=1 ){
49269 p->lock.iTable = 1;
50133 assert( p->lock.pBtree==p && p->lock.iTable==1 );
50960 int iTable, /* Root page of table to open */
50974 assert( hasSharedCacheTableLock(p, iTable, pKeyInfo!=0, wrFlag+1) );
50975 assert( wrFlag==0 || !hasReadConflicts(p, iTable) );
50985 if( iTable==1 && btreePagecount(pBt)==0 ){
50991 pCur->pgnoRoot = (Pgno)iTable;
51008 int iTable, /* Root page of table to open */
51015 rc = btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
54652 SQLITE_PRIVATE int sqlite3BtreeClearTable(Btree *p, int iTable, int *pnChange){
54663 rc = saveAllCursors(pBt, (Pgno)iTable, 0);
54665 rc = clearDatabasePage(pBt, (Pgno)iTable, 0, pnChange);
54691 static int btreeDropTable(Btree *p, Pgno iTable, int *piMoved){
54712 rc = btreeGetPage(pBt, (Pgno)iTable, &pPage, 0);
54714 rc = sqlite3BtreeClearTable(p, iTable, 0);
54722 if( iTable>1 ){
54731 if( iTable==maxRootPgno ){
54751 rc = relocatePage(pBt, pMove, PTRMAP_ROOTPAGE, 0, iTable, 0);
54794 SQLITE_PRIVATE int sqlite3BtreeDropTable(Btree *p, int iTable, int *piMoved){
54797 rc = btreeDropTable(p, iTable, piMoved);
70087 pDup->iTable = pEList->a[iCol].iAlias;
70167 pExpr->iTable = -1;
70201 pExpr->iTable = pItem->iCursor;
70210 pExpr->iTable = pItem->iCursor;
70251 pExpr->iTable = 1;
70254 pExpr->iTable = 0;
70278 }else if( pExpr->iTable==0 ){
70392 assert( pMatch->iCursor==pExpr->iTable );
70430 p->iTable = pItem->iCursor;
70489 pExpr->iTable = pItem->iCursor;
72532 assert( p->iTable>=0 ); /* p cannot be part of a CHECK constraint */
72753 pX->iTable = iTab;
72858 pExpr->iTable = pParse->nTab++;
72859 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pExpr->iTable, !isRowid);
72874 sqlite3SelectDestInit(&dest, SRT_Set, pExpr->iTable);
72876 assert( (pExpr->iTable&0x0000FFFF)==pExpr->iTable );
72924 sqlite3VdbeAddOp3(v, OP_InsertInt, pExpr->iTable, r2, iValToIns);
72930 sqlite3VdbeAddOp3(v, OP_Insert, pExpr->iTable, r2, r3);
72934 sqlite3VdbeAddOp2(v, OP_IdxInsert, pExpr->iTable, r2);
73056 sqlite3VdbeAddOp2(v, OP_Rewind, pExpr->iTable, destIfFalse);
73065 sqlite3VdbeAddOp3(v, OP_NotExists, pExpr->iTable, destIfFalse, r1);
73085 sqlite3VdbeAddOp4Int(v, OP_NotFound, pExpr->iTable, destIfFalse, r1, 1);
73098 j1 = sqlite3VdbeAddOp4Int(v, OP_Found, pExpr->iTable, 0, r1, 1);
73107 j3 = sqlite3VdbeAddOp4Int(v, OP_Found, pExpr->iTable, 0, rRhsHasNull, 1);
73239 if( p->iReg && p->iTable==iTab && p->iColumn==iCol ){
73247 assert( p->iReg==0 || p->iTable!=iTab || p->iColumn!=iCol );
73255 p->iTable = iTab;
73276 p->iTable = iTab;
73380 int iTable, /* The cursor pointing to the table */
73388 if( p->iReg>0 && p->iTable==iTable && p->iColumn==iColumn ){
73395 sqlite3ExprCodeGetColumnOfTable(v, pTab, iTable, iColumn, iReg);
73396 sqlite3ExprCacheStore(pParse, iTable, iColumn, iReg);
73518 if( pExpr->iTable<0 ){
73524 pExpr->iColumn, pExpr->iTable, target);
73577 inReg = pExpr->iTable;
73935 int p1 = pExpr->iTable * (pTab->nCol+1) + 1 + pExpr->iColumn;
73937 assert( pExpr->iTable==0 || pExpr->iTable==1 );
73944 (pExpr->iTable ? "new" : "old"),
74007 cacheX.iTable = sqlite3ExprCodeTemp(pParse, pX, ®Free1);
74112 sqlite3VdbeAddOp2(pParse->pVdbe, OP_Copy, pExpr->iTable, target);
74150 pExpr->iTable = iMem;
74255 pExpr->iTable = r2;
74353 exprX.iTable = sqlite3ExprCodeTemp(pParse, &exprX, ®Free1);
74673 if( pA->iTable!=pB->iTable || pA->iColumn!=pB->iColumn ) return 2;
74775 if( pExpr->iTable==pItem->iCursor ){
74785 if( pCol->iTable==pExpr->iTable &&
74795 pCol->iTable = pExpr->iTable;
74807 if( pE->op==TK_COLUMN && pE->iTable==pExpr->iTable &&
77250 if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
79242 static void destroyRootPage(Parse *pParse, int iTable, int iDb){
79245 sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb);
79259 pParse->db->aDb[iDb].zName, SCHEMA_TABLE(iDb), iTable, r1, r1);
84330 pLeft->iTable = regData+iCol+1;
84334 pLeft->iTable = regData;
84357 pLeft->iTable = regData;
84359 pRight->iTable = pSrc->a[0].iCursor;
90734 pEq->iRightJoinTable = (i16)pE2->iTable;
90765 static void setJoinExpr(Expr *p, int iTable){
90770 p->iRightJoinTable = (i16)iTable;
90771 setJoinExpr(p->pLeft, iTable);
91474 for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
91648 if( pTabList->a[j].iCursor==p->iTable ) break;
92964 int iTable, /* Table to be substituted */
92968 if( pExpr->op==TK_COLUMN && pExpr->iTable==iTable ){
92983 pExpr->pLeft = substExpr(db, pExpr->pLeft, iTable, pEList);
92984 pExpr->pRight = substExpr(db, pExpr->pRight, iTable, pEList);
92986 substSelect(db, pExpr->x.pSelect, iTable, pEList);
92988 substExprList(db, pExpr->x.pList, iTable, pEList);
92996 int iTable, /* Table to be substituted */
93002 pList->a[i].pExpr = substExpr(db, pList->a[i].pExpr, iTable, pEList);
93008 int iTable, /* Table to be replaced */
93015 substExprList(db, p->pEList, iTable, pEList);
93016 substExprList(db, p->pGroupBy, iTable, pEList);
93017 substExprList(db, p->pOrderBy, iTable, pEList);
93018 p->pHaving = substExpr(db, p->pHaving, iTable, pEList);
93019 p->pWhere = substExpr(db, p->pWhere, iTable, pEList);
93020 substSelect(db, p->pPrior, iTable, pEList);
93025 substSelect(db, pItem->pSelect, iTable, pEList);
94563 pCol->pTab, pCol->iColumn, pCol->iTable, r1);
98776 mask = getMask(pMaskSet, p->iTable);
99480 pTerm->leftCursor = pLeft->iTable;
99507 pNew->leftCursor = pLeft->iTable;
99654 pNewTerm->leftCursor = pLeft->iTable;
99695 pNewTerm->leftCursor = pLeft->iTable;
99794 if( pExpr->op!=TK_COLUMN || pExpr->iTable!=base ){
100320 if( pExpr->op!=TK_COLUMN || pExpr->iTable!=pSrc->iCursor ) break;
101621 iTab = pX->iTable;
105957 …otominor.yy118.pExpr ) sqlite3GetInt32(&yymsp[0].minor.yy0.z[1], &yygotominor.yy118.pExpr->iTable);
