Lines Matching defs:tnum
10927 ** Table.tnum is the page number for the root BTree page of the table in the
10932 ** when the VDBE cursor to the table is closed. In this case Table.tnum
10949 int tnum; /* Root BTree node for this table (see note above) */
11169 int tnum; /* DB Page containing root of this index */
51716 if( pIdx->tnum==(int)iRoot ){
51717 iTab = pIdx->pTable->tnum;
74807 sqlite3VdbeChangeP2(v, 1, pTab->tnum);
74813 ** parameter of the other to pTab->tnum. */
74815 sqlite3VdbeChangeP2(v, 2 + flags, pTab->tnum);
79845 sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName);
79880 sqlite3VdbeAddOp3(v, OP_OpenRead, iTab, pIdx->tnum, iDb);
83639 aRoot[i] = pStat->tnum;
84395 if( pTab->tnum==0 ){
84418 sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName);
84488 sqlite3VdbeAddOp3(v, OP_OpenRead, iIdxCur, pIdx->tnum, iDb);
87721 ** (3) Set the Index.tnum of the PRIMARY KEY Index object in the
87785 pPk->tnum = pTab->tnum;
87879 p->tnum = db->init.newTnum;
88288 if( pTab->tnum==iFrom ){
88289 pTab->tnum = iTo;
88295 if( pIdx->tnum==iFrom ){
88296 pIdx->tnum = iTo;
88340 destroyRootPage(pParse, pTab->tnum, iDb);
88342 destroyRootPage(pParse, pIdx->tnum, iDb);
88361 int iTab = pTab->tnum;
88372 int iIdx = pIdx->tnum;
88742 ** the root page number of the index is taken from pIndex->tnum.
88751 int tnum; /* Root page of index */
88767 sqlite3TableLock(pParse, iDb, pTab->tnum, 1, pTab->zName);
88772 tnum = memRootPage;
88774 tnum = pIndex->tnum;
88794 if( memRootPage<0 ) sqlite3VdbeAddOp2(v, OP_Clear, tnum, iDb);
88795 sqlite3VdbeAddOp4(v, OP_OpenWrite, iIdx, tnum, iDb,
89249 pIndex->tnum = db->init.newTnum;
89454 destroyRootPage(pParse, pIndex->tnum, iDb);
91198 sqlite3TableLock(pParse, iDb, pTab->tnum, 1, pTab->zName);
91200 sqlite3VdbeAddOp4(v, OP_Clear, pTab->tnum, iDb, memCnt,
91205 sqlite3VdbeAddOp2(v, OP_Clear, pIdx->tnum, iDb);
93806 sqlite3VdbeAddOp3(v, OP_OpenRead, iCur, pIdx->tnum, iDb);
94353 sqlite3TableLock(pParse, iDb, pTo->tnum, 0, pTo->zName);
94822 sqlite3TableLock(pParse, iDb, pTab->tnum,
94825 sqlite3VdbeAddOp4Int(v, opcode, iCur, pTab->tnum, iDb, pTab->nCol);
94830 assert( pPk->tnum=pTab->tnum );
94831 sqlite3VdbeAddOp3(v, opcode, iCur, pPk->tnum, iDb);
94953 int tnum = pOp->p2;
94954 if( tnum==pTab->tnum ){
94958 if( tnum==pIndex->tnum ){
96432 sqlite3TableLock(pParse, iDb, pTab->tnum, op==OP_OpenWrite, pTab->zName);
96442 sqlite3VdbeAddOp3(v, op, iIdxCur, pIdx->tnum, iDb);
96768 sqlite3TableLock(pParse, iDbDest, pDest->tnum, 1, pDest->zName);
96769 sqlite3TableLock(pParse, iDbSrc, pSrc->tnum, 0, pSrc->zName);
96776 sqlite3VdbeAddOp3(v, OP_OpenRead, iSrc, pSrcIdx->tnum, iDbSrc);
96779 sqlite3VdbeAddOp3(v, OP_OpenWrite, iDest, pDestIdx->tnum, iDbDest);
99877 sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName);
99886 sqlite3TableLock(pParse, iDb, pParent->tnum, 0, pParent->zName);
99892 sqlite3VdbeAddOp3(v, OP_OpenRead, i, pIdx->tnum, iDb);
100059 sqlite3VdbeAddOp2(v, OP_Integer, pTab->tnum, 2+cnt);
100064 sqlite3VdbeAddOp2(v, OP_Integer, pIdx->tnum, 2+cnt);
100681 }else if( sqlite3GetInt32(argv[1], &pIndex->tnum)==0 ){
106611 int iRoot = pTab->tnum; /* Root page of scanned b-tree */
106614 sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName);
106636 iRoot = pBest->tnum;
115088 if( pIndex && pIndex->tnum==0 ){
115147 ** If pProbe->tnum==0, that means pIndex is a fake index used for the
115181 }else if( pProbe->tnum<=0 || (pSrc->jointype & JT_LEFT)!=0 ){
115614 if( pProbe->tnum<=0 ){
117187 sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName);
117222 sqlite3VdbeAddOp3(v, op, iIndexCur, pIx->tnum, iDb);
