lib/sqlite/sqlite3.c

9909 ** Table.tnum is the page number for the root BTree page of the table in the
9914 ** when the VDBE cursor to the table is closed.  In this case Table.tnum
9926   int tnum;            /* Root BTree node for this table (see note above) */
10128   int tnum;        /* Page containing root of this index in database file */
48417       if( pIdx->tnum==(int)iRoot ){
48418         iTab = pIdx->pTable->tnum;
70086       sqlite3VdbeChangeP2(v, 2, pTab->tnum);
70092       ** parameter of the other to pTab->tnum.  */
70094       sqlite3VdbeChangeP2(v, 3 + flags, pTab->tnum);
74474     sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName);
74518           sqlite3VdbeAddOp4(v, OP_OpenRead, iTab, pIdx->tnum, iDb,
77684       aRoot[i] = pStat->tnum;
77746   if( pTab->tnum==0 ){
77766   sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName);
77783     sqlite3VdbeAddOp4(v, OP_OpenRead, iIdxCur, pIdx->tnum, iDb,
77955     sqlite3VdbeAddOp3(v, OP_OpenRead, iIdxCur, pTab->tnum, iDb);
80640     p->tnum = db->init.newTnum;
81018     if( pTab->tnum==iFrom ){
81019       pTab->tnum = iTo;
81025     if( pIdx->tnum==iFrom ){
81026       pIdx->tnum = iTo;
81070   destroyRootPage(pParse, pTab->tnum, iDb);
81072     destroyRootPage(pParse, pIdx->tnum, iDb);
81091   int iTab = pTab->tnum;
81102       int iIdx = pIdx->tnum;
81457 ** the root page number of the index is taken from pIndex->tnum.
81466   int tnum;                      /* Root page of index */
81482   sqlite3TableLock(pParse, iDb, pTab->tnum, 1, pTab->zName);
81487     tnum = memRootPage;
81489     tnum = pIndex->tnum;
81490     sqlite3VdbeAddOp2(v, OP_Clear, tnum, iDb);
81493   sqlite3VdbeAddOp4(v, OP_OpenWrite, iIdx, tnum, iDb,
81941       pIndex->tnum = db->init.newTnum;
82144     destroyRootPage(pParse, pIndex->tnum, iDb);
83753     sqlite3VdbeAddOp4(v, OP_Clear, pTab->tnum, iDb, memCnt,
83757       sqlite3VdbeAddOp2(v, OP_Clear, pIdx->tnum, iDb);
83820         sqlite3VdbeAddOp2(v, OP_Close, iCur + i, pIdx->tnum);
86040       sqlite3VdbeAddOp3(v, OP_OpenRead, iCur, pIdx->tnum, iDb);
86445     sqlite3TableLock(pParse, iDb, pTo->tnum, 0, pTo->zName);
86911   sqlite3TableLock(p, iDb, pTab->tnum, (opcode==OP_OpenWrite)?1:0, pTab->zName);
86912   sqlite3VdbeAddOp3(v, opcode, iCur, pTab->tnum, iDb);
87029       int tnum = pOp->p2;
87030       if( tnum==pTab->tnum ){
87034         if( tnum==pIndex->tnum ){
88383     sqlite3VdbeAddOp4(v, op, i+baseCur, pIdx->tnum, iDb,
88696     sqlite3VdbeAddOp4(v, OP_OpenRead, iSrc, pSrcIdx->tnum, iDbSrc,
88700     sqlite3VdbeAddOp4(v, OP_OpenWrite, iDest, pDestIdx->tnum, iDbDest,
91081         sqlite3VdbeAddOp2(v, OP_Integer, pTab->tnum, 2+cnt);
91084           sqlite3VdbeAddOp2(v, OP_Integer, pIdx->tnum, 2+cnt);
91606     }else if( sqlite3GetInt32(argv[1], &pIndex->tnum)==0 ){
96695         int iRoot = pTab->tnum;              /* Root page of scanned b-tree */
96698         sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName);
96719           iRoot = pBest->tnum;
98620         sqlite3VdbeAddOp4(v, OP_OpenWrite, iCur+i+1, pIdx->tnum, iDb,
105313       sqlite3TableLock(pParse, iDb, pTab->tnum, 0, pTab->zName);
105326       sqlite3VdbeAddOp4(v, OP_OpenRead, iIdxCur, pIx->tnum, iDb,