Lines Matching refs:iTable
8060 int iTable, /* Index of root page */
10190 int iTable; /* Cursor number of the source table */ member
10317 int iTable; /* TK_COLUMN: cursor number of table holding column member
10386 #define EXPR_REDUCEDSIZE offsetof(Expr,iTable) /* Common features */
10853 int iTable; /* Table cursor number */ member
47654 Pgno iTable; /* Root page of table */
48430 && (pLock->iTable==iTab || (pLock->eLock==WRITE_LOCK && pLock->iTable==1))
48522 if( pIter->pBtree!=p && pIter->iTable==iTab && pIter->eLock!=eLock ){
48553 static int setSharedCacheTableLock(Btree *p, Pgno iTable, u8 eLock){
48571 assert( SQLITE_OK==querySharedCacheTableLock(p, iTable, eLock) );
48575 if( pIter->iTable==iTable && pIter->pBtree==p ){
48589 pLock->iTable = iTable;
48631 assert( pLock->iTable!=1 || pLock==&p->lock );
48632 if( pLock->iTable!=1 ){
50016 p->lock.iTable = 1;
50880 assert( p->lock.pBtree==p && p->lock.iTable==1 );
51708 int iTable, /* Root page of table to open */
51722 assert( hasSharedCacheTableLock(p, iTable, pKeyInfo!=0, wrFlag+1) );
51723 assert( wrFlag==0 || !hasReadConflicts(p, iTable) );
51733 if( iTable==1 && btreePagecount(pBt)==0 ){
51735 iTable = 0;
51740 pCur->pgnoRoot = (Pgno)iTable;
51757 int iTable, /* Root page of table to open */
51764 rc = btreeCursor(p, iTable, wrFlag, pKeyInfo, pCur);
55407 SQLITE_PRIVATE int sqlite3BtreeClearTable(Btree *p, int iTable, int *pnChange){
55418 rc = saveAllCursors(pBt, (Pgno)iTable, 0);
55420 rc = clearDatabasePage(pBt, (Pgno)iTable, 0, pnChange);
55446 static int btreeDropTable(Btree *p, Pgno iTable, int *piMoved){
55467 rc = btreeGetPage(pBt, (Pgno)iTable, &pPage, 0);
55469 rc = sqlite3BtreeClearTable(p, iTable, 0);
55477 if( iTable>1 ){
55486 if( iTable==maxRootPgno ){
55506 rc = relocatePage(pBt, pMove, PTRMAP_ROOTPAGE, 0, iTable, 0);
55549 SQLITE_PRIVATE int sqlite3BtreeDropTable(Btree *p, int iTable, int *piMoved){
55552 rc = btreeDropTable(p, iTable, piMoved);
71871 pDup->iTable = pEList->a[iCol].iAlias;
71951 pExpr->iTable = -1;
71985 pExpr->iTable = pItem->iCursor;
71994 pExpr->iTable = pItem->iCursor;
72035 pExpr->iTable = 1;
72038 pExpr->iTable = 0;
72062 }else if( pExpr->iTable==0 ){
72176 assert( pMatch->iCursor==pExpr->iTable );
72214 p->iTable = pItem->iCursor;
72273 pExpr->iTable = pItem->iCursor;
74332 assert( p->iTable>=0 ); /* p cannot be part of a CHECK constraint */
74551 pX->iTable = iTab;
74654 pExpr->iTable = pParse->nTab++;
74655 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, pExpr->iTable, !isRowid);
74670 sqlite3SelectDestInit(&dest, SRT_Set, pExpr->iTable);
74672 assert( (pExpr->iTable&0x0000FFFF)==pExpr->iTable );
74720 sqlite3VdbeAddOp3(v, OP_InsertInt, pExpr->iTable, r2, iValToIns);
74726 sqlite3VdbeAddOp3(v, OP_Insert, pExpr->iTable, r2, r3);
74730 sqlite3VdbeAddOp2(v, OP_IdxInsert, pExpr->iTable, r2);
74852 sqlite3VdbeAddOp2(v, OP_Rewind, pExpr->iTable, destIfFalse);
74861 sqlite3VdbeAddOp3(v, OP_NotExists, pExpr->iTable, destIfFalse, r1);
74881 sqlite3VdbeAddOp4Int(v, OP_NotFound, pExpr->iTable, destIfFalse, r1, 1);
74894 j1 = sqlite3VdbeAddOp4Int(v, OP_Found, pExpr->iTable, 0, r1, 1);
74903 j3 = sqlite3VdbeAddOp4Int(v, OP_Found, pExpr->iTable, 0, rRhsHasNull, 1);
75035 if( p->iReg && p->iTable==iTab && p->iColumn==iCol ){
75043 assert( p->iReg==0 || p->iTable!=iTab || p->iColumn!=iCol );
75051 p->iTable = iTab;
75072 p->iTable = iTab;
75176 int iTable, /* The cursor pointing to the table */
75184 if( p->iReg>0 && p->iTable==iTable && p->iColumn==iColumn ){
75191 sqlite3ExprCodeGetColumnOfTable(v, pTab, iTable, iColumn, iReg);
75192 sqlite3ExprCacheStore(pParse, iTable, iColumn, iReg);
75314 if( pExpr->iTable<0 ){
75320 pExpr->iColumn, pExpr->iTable, target);
75373 inReg = pExpr->iTable;
75731 int p1 = pExpr->iTable * (pTab->nCol+1) + 1 + pExpr->iColumn;
75733 assert( pExpr->iTable==0 || pExpr->iTable==1 );
75740 (pExpr->iTable ? "new" : "old"),
75803 cacheX.iTable = sqlite3ExprCodeTemp(pParse, pX, ®Free1);
75908 sqlite3VdbeAddOp2(pParse->pVdbe, OP_Copy, pExpr->iTable, target);
75946 pExpr->iTable = iMem;
76051 pExpr->iTable = r2;
76149 exprX.iTable = sqlite3ExprCodeTemp(pParse, &exprX, ®Free1);
76469 if( pA->iTable!=pB->iTable || pA->iColumn!=pB->iColumn ) return 2;
76571 if( pExpr->iTable==pItem->iCursor ){
76581 if( pCol->iTable==pExpr->iTable &&
76591 pCol->iTable = pExpr->iTable;
76603 if( pE->op==TK_COLUMN && pE->iTable==pExpr->iTable &&
79046 if( pExpr->iTable==pTabList->a[iSrc].iCursor ){
81038 static void destroyRootPage(Parse *pParse, int iTable, int iDb){
81041 sqlite3VdbeAddOp3(v, OP_Destroy, iTable, r1, iDb);
81055 pParse->db->aDb[iDb].zName, SCHEMA_TABLE(iDb), iTable, r1, r1);
86177 pLeft->iTable = regData+iCol+1;
86181 pLeft->iTable = regData;
86204 pLeft->iTable = regData;
86206 pRight->iTable = pSrc->a[0].iCursor;
92613 pEq->iRightJoinTable = (i16)pE2->iTable;
92644 static void setJoinExpr(Expr *p, int iTable){
92649 p->iRightJoinTable = (i16)iTable;
92650 setJoinExpr(p->pLeft, iTable);
93374 for(j=0;j<pTabList->nSrc && pTabList->a[j].iCursor!=pExpr->iTable;j++);
93548 if( pTabList->a[j].iCursor==p->iTable ) break;
94864 int iTable, /* Table to be substituted */
94868 if( pExpr->op==TK_COLUMN && pExpr->iTable==iTable ){
94883 pExpr->pLeft = substExpr(db, pExpr->pLeft, iTable, pEList);
94884 pExpr->pRight = substExpr(db, pExpr->pRight, iTable, pEList);
94886 substSelect(db, pExpr->x.pSelect, iTable, pEList);
94888 substExprList(db, pExpr->x.pList, iTable, pEList);
94896 int iTable, /* Table to be substituted */
94902 pList->a[i].pExpr = substExpr(db, pList->a[i].pExpr, iTable, pEList);
94908 int iTable, /* Table to be replaced */
94915 substExprList(db, p->pEList, iTable, pEList);
94916 substExprList(db, p->pGroupBy, iTable, pEList);
94917 substExprList(db, p->pOrderBy, iTable, pEList);
94918 p->pHaving = substExpr(db, p->pHaving, iTable, pEList);
94919 p->pWhere = substExpr(db, p->pWhere, iTable, pEList);
94920 substSelect(db, p->pPrior, iTable, pEList);
94925 substSelect(db, pItem->pSelect, iTable, pEList);
96552 pCol->pTab, pCol->iColumn, pCol->iTable, r1);
100790 mask = getMask(pMaskSet, p->iTable);
101502 pTerm->leftCursor = pLeft->iTable;
101529 pNew->leftCursor = pLeft->iTable;
101676 pNewTerm->leftCursor = pLeft->iTable;
101717 pNewTerm->leftCursor = pLeft->iTable;
101778 && p->iTable==iBase
101828 pTerm = findTerm(pWC, p->iTable, p->iColumn, ~(Bitmask)0, WO_EQ, 0);
101835 if( p->iTable!=base ) return 0;
101879 if( p->op==TK_COLUMN && p->iTable==iBase && p->iColumn<0 ) return 1;
101975 if( pExpr->op!=TK_COLUMN || pExpr->iTable!=base ){
102509 if( pExpr->op!=TK_COLUMN || pExpr->iTable!=pSrc->iCursor ) break;
103820 iTab = pX->iTable;
108178 …otominor.yy118.pExpr ) sqlite3GetInt32(&yymsp[0].minor.yy0.z[1], &yygotominor.yy118.pExpr->iTable);