Home
last modified time | relevance | path

Searched refs:pgno (Results 1 – 25 of 41) sorted by relevance

12

/sqlite-3.40.0/tool/
H A Dshowdb.c747 while( pgno>0 ){ in decode_trunk_page()
764 pgno = 0; in decode_trunk_page()
787 if( pgno<=0 || pgno>g.mxPage ){ in page_usage_msg()
875 if( pgno<=0 || pgno>g.mxPage ) return; in page_usage_btree()
957 while( pgno>0 && pgno<=g.mxPage && (u32)(cnt++)<g.mxPage ){ in page_usage_freelist()
969 pgno = iNext; in page_usage_freelist()
979 u64 pgno = 2; in page_usage_ptrmap() local
983 pgno+1, pgno+perPage); in page_usage_ptrmap()
1056 u64 pgno; in ptrmap_coverage_report() local
1079 for(pgno=2; pgno<=g.mxPage; pgno += perPage+1){ in ptrmap_coverage_report()
[all …]
H A Doffsets.c28 int pgno; /* Current page number */ member
137 p->pgno = p->aPgno[p->nStack-1]; in ofstPopPage()
145 static void ofstPushPage(GState *p, int pgno){ in ofstPushPage() argument
153 p->aPgno[p->nStack] = pgno; in ofstPushPage()
161 p->pgno = pgno; in ofstPushPage()
162 fseek(p->f, (pgno-1)*p->szPg, SEEK_SET); in ofstPushPage()
165 ofstError(p, "unable to read page %d", pgno); in ofstPushPage()
207 return p->szPg*(p->pgno-1) + ofst; in ofstInFile()
284 static void ofstWalkPage(GState *p, int pgno){ in ofstWalkPage() argument
286 ofstPushPage(p, pgno); in ofstWalkPage()
[all …]
/sqlite-3.40.0/ext/misc/
H A Dscrub.c134 if( (u32)pgno>p->iLastPage ) p->iLastPage = pgno; in scrubBackupWrite()
313 while( pgno && nFree){ in scrubBackupFreelist()
322 pgno = scrubBackupInt32(a); in scrubBackupFreelist()
352 while( nByte>0 && pgno!=0 ){ in scrubBackupOverflow()
392 if( pgno==1 ){ in scrubBackupBtree()
398 nPrefix = pgno==1 ? 100 : 0; in scrubBackupBtree()
477 pgno, ln); in scrubBackupBtree()
487 u32 pgno = 2; in scrubBackupPtrmap() local
494 while( pgno<=p->nPage ){ in scrubBackupPtrmap()
498 pgno += J+1; in scrubBackupPtrmap()
[all …]
H A Dbtreeinfo.c272 static int binfoCompute(sqlite3 *db, int pgno, BinfoCursor *pCsr){ in binfoCompute() argument
288 sqlite3_bind_int(pStmt, 1, pgno); in binfoCompute()
300 if( pgno==1 ){ in binfoCompute()
310 pgno = get_uint32(aData+8); in binfoCompute()
313 if( pgno==1 ) iCell -= 100; in binfoCompute()
318 pgno = get_uint32(aData+iCell); in binfoCompute()
338 int pgno = sqlite3_column_int(pCsr->pStmt, BINFO_COLUMN_ROOTPAGE+1); in binfoColumn() local
340 int rc = binfoCompute(db, pgno, pCsr); in binfoColumn()
/sqlite-3.40.0/test/
H A Ddbpage.test39 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage('main') ORDER BY pgno;
42 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=2;
45 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=4;
48 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=5;
51 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=0;
58 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage('aux1');
63 SELECT pgno, schema, substr(data,1,6)
65 WHERE sqlite_dbpage.schema=x3.y AND sqlite_dbpage.pgno=x3.z
72 UPDATE sqlite_dbpage SET data=zeroblob(4096) WHERE pgno=4;
78 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage('main') ORDER BY pgno;
[all …]
H A Ddbdata.test37 SELECT pgno, cell, field, quote(value) FROM sqlite_dbdata WHERE pgno=2;
49 SELECT pgno, cell, field, quote(value) FROM sqlite_dbdata;
68 SELECT value FROM sqlite_dbdata WHERE pgno=2 AND cell=2 AND field=1;
77 SELECT quote(value) FROM sqlite_dbdata WHERE pgno=2 AND cell=0 AND field=1;
96 SELECT * FROM sqlite_dbptr WHERE pgno=2;
102 SELECT * FROM sqlite_dbptr WHERE pgno=3;
H A Dcorrupt9.test43 set pgno [hexio_get_int [hexio_read $filename 32 4]]
44 return [expr {($pgno-1)*[hexio_get_int [hexio_read $filename 16 2]]}]
55 set pgno [hexio_read $filename [expr {$offset+8}] 4]
57 hexio_write $filename [expr {$offset+$i}] $pgno
H A Ddbpagefault.test60 DELETE FROM sqlite_dbpage WHERE pgno=100;
61 UPDATE sqlite_dbpage SET data=null WHERE pgno=100;
H A Dresetdb.test70 UPDATE sqlite_dbpage SET data=randomblob(4096) WHERE pgno=1;
135 UPDATE sqlite_dbpage SET data=randomblob(8192) WHERE pgno=1;
240 …612926010617111101397461626C657431743102435245415445205441424C4520743128612C622C6329' WHERE pgno=1;
/sqlite-3.40.0/src/
H A Ddbpage.c175 pCsr->pgno = -1; in dbpageOpen()
198 pCsr->pgno++; in dbpageNext()
204 return pCsr->pgno > pCsr->mxPgno; in dbpageEof()
229 pCsr->pgno = 1; in dbpageFilter()
249 if( pCsr->pgno<1 || pCsr->pgno>pCsr->mxPgno ){ in dbpageFilter()
250 pCsr->pgno = 1; in dbpageFilter()
253 pCsr->mxPgno = pCsr->pgno; in dbpageFilter()
256 assert( pCsr->pgno==1 ); in dbpageFilter()
302 *pRowid = pCsr->pgno; in dbpageRowid()
313 Pgno pgno; in dbpageUpdate() local
[all …]
H A Dpcache.c187 pPage->pgno)); in pcacheManageDirtyList()
417 pcachePageTrace(pgno, pRes); in sqlite3PcacheFetch()
463 pPg->pgno, pgno, in sqlite3PcacheFetchStress()
503 pPgHdr->pgno = pgno; in pcacheFetchFinishWithInit()
666 p->pgno = newPgno; in sqlite3PcacheMove()
686 pcacheTrace(("%p.TRUNCATE %d\n",pCache,pgno)); in sqlite3PcacheTruncate()
693 assert( p->pgno>0 ); in sqlite3PcacheTruncate()
694 if( p->pgno>pgno ){ in sqlite3PcacheTruncate()
699 if( pgno==0 && pCache->nRefSum ){ in sqlite3PcacheTruncate()
705 pgno = 1; in sqlite3PcacheTruncate()
[all …]
H A Dpager.c1071 Pgno pgno = pPg->pgno; in subjRequiresPage() local
2289 if( pgno==0 || pgno==PAGER_SJ_PGNO(pPager) ){ in pager_playback_one_page()
2293 if( pgno>(Pgno)pPager->dbSize || sqlite3BitvecTest(pDone, pgno) ){ in pager_playback_one_page()
2435 if( pgno==1 ){ in pager_playback_one_page()
3141 assert( p->pgno < p->pDirty->pgno ); in pagerWalFrames()
3927 Pgno pgno = pPg->pgno; in assertTruncateConstraintCb() local
4038 p->pgno = pgno; in pagerAcquireMapPage()
4394 Pgno pgno = pList->pgno; in pager_write_pagelist() local
5511 assert( pPg->pgno==pgno ); in getPageNormal()
5608 if( pgno<=1 && pgno==0 ){ in getPageMMap()
[all …]
H A Dtest_journal.c401 u32 pgno = decodeUint32(&aData[8+4*iLeaf]); in openTransaction() local
402 sqlite3BitvecSet(pMain->pWritable, pgno); in openTransaction()
479 u32 pgno; in readJournalFile() local
482 pgno = decodeUint32(zBuf); in readJournalFile()
483 if( pgno>0 && pgno<=pMain->nPage ){ in readJournalFile()
491 sqlite3BitvecSet(pMain->pWritable, pgno); in readJournalFile()
557 u32 pgno = (u32)(iOfst/p->nPagesize + 1); in jtWrite() local
564 assert( pgno>p->nPage || sqlite3BitvecTest(p->pWritable, pgno) ); in jtWrite()
588 u32 pgno; in jtTruncate() local
590 for(pgno=(u32)(size/p->nPagesize+1); pgno<=p->nPage; pgno++){ in jtTruncate()
[all …]
H A DbtreeInt.h277 Pgno pgno; /* Page number for this page */ member
620 #define PTRMAP_PAGENO(pBt, pgno) ptrmapPageno(pBt, pgno) argument
621 #define PTRMAP_PTROFFSET(pgptrmap, pgno) (5*(pgno-pgptrmap-1)) argument
622 #define PTRMAP_ISPAGE(pBt, pgno) (PTRMAP_PAGENO((pBt),(pgno))==(pgno)) argument
H A Dbtree.c2181 if( pgno!=pPage->pgno ){ in btreePageFromDbPage()
2185 pPage->pgno = pgno; in btreePageFromDbPage()
2290 assert( (*ppPage)->pgno==pgno || CORRUPT_DB ); in getAndInitPage()
3672 Pgno pgno = pPage->pgno; in setChildPtrmaps() local
4843 Pgno pgno; in getOverflowPage() local
5310 pCur->pPage->pgno in moveToParent()
5429 Pgno pgno; in moveToLeftmost() local
5454 Pgno pgno; in moveToRightmost() local
8291 rc = allocateBtreePage(pBt, &pNew, &pgno, (bBulk ? 1 : pgno), 0); in balance_nonroot()
8300 ptrmapPut(pBt, pNew->pgno, PTRMAP_BTREE, pParent->pgno, &rc); in balance_nonroot()
[all …]
H A Dos_kv.c541 unsigned int pgno; in kvvfsReadDb() local
556 pgno = 1 + iOfst/iAmt; in kvvfsReadDb()
558 pgno = 1; in kvvfsReadDb()
560 sqlite3_snprintf(sizeof(zKey), zKey, "%u", pgno); in kvvfsReadDb()
626 unsigned int pgno; in kvvfsWriteDb() local
634 pgno = 1 + iOfst/iAmt; in kvvfsWriteDb()
635 sqlite3_snprintf(sizeof(zKey), zKey, "%u", pgno); in kvvfsWriteDb()
666 unsigned int pgno, pgnoMax; in kvvfsTruncateDb() local
668 pgno = 1 + size/pFile->szPage; in kvvfsTruncateDb()
670 while( pgno<=pgnoMax ){ in kvvfsTruncateDb()
[all …]
H A Dtest2.c318 int pgno; in page_get() local
326 if( Tcl_GetInt(interp, argv[2], &pgno) ) return TCL_ERROR; in page_get()
329 rc = sqlite3PagerGet(pPager, pgno, &pPage, 0); in page_get()
355 int pgno; in page_lookup() local
362 if( Tcl_GetInt(interp, argv[2], &pgno) ) return TCL_ERROR; in page_lookup()
363 pPage = sqlite3PagerLookup(pPager, pgno); in page_lookup()
381 int pgno; in pager_truncate() local
388 if( Tcl_GetInt(interp, argv[2], &pgno) ) return TCL_ERROR; in pager_truncate()
389 sqlite3PagerTruncateImage(pPager, pgno); in pager_truncate()
H A Dwal.c862 u32 pgno; /* Page number of the frame */ in walDecodeFrame() local
874 pgno = sqlite3Get4byte(&aFrame[0]); in walDecodeFrame()
875 if( pgno==0 ){ in walDecodeFrame()
897 *piPage = pgno; in walDecodeFrame()
1342 rc = walIndexAppend(pWal, iFrame, pgno); in walIndexRecover()
2967 pgno = sLoc.aPgno[i-sLoc.iZero-1]; in sqlite3WalSnapshotRecover()
2968 iDbOff = (i64)(pgno-1) * szPage; in sqlite3WalSnapshotRecover()
3197 iKey = walHash(pgno); in sqlite3WalFindFrame()
3221 if( walFramePgno(pWal, iTest)==pgno ){ in sqlite3WalFindFrame()
3802 rc = walIndexAppend(pWal, iFrame, p->pgno); in sqlite3WalFrames()
[all …]
H A Dpager.h147 int sqlite3PagerGet(Pager *pPager, Pgno pgno, DbPage **ppPage, int clrFlag);
148 DbPage *sqlite3PagerLookup(Pager *pPager, Pgno pgno);
198 int sqlite3PagerDirectReadOk(Pager *pPager, Pgno pgno);
H A Dmemdb.c767 int pgno; in sqlite3_serialize() local
768 for(pgno=1; pgno<=nPage; pgno++){ in sqlite3_serialize()
770 unsigned char *pTo = pOut + szPage*(sqlite3_int64)(pgno-1); in sqlite3_serialize()
771 rc = sqlite3PagerGet(pPager, pgno, (DbPage**)&pPage, 0); in sqlite3_serialize()
/sqlite-3.40.0/ext/repair/test/
H A Dcheckfreelist01.test23 SELECT 1, NULL, sqlite_readint32(data, 32) FROM sqlite_dbpage WHERE pgno=1
26 FROM freelist_trunk, sqlite_dbpage WHERE pgno=n
53 WHERE pgno=4860;
62 WHERE pgno=4860;
71 WHERE pgno=4860;
80 WHERE pgno=5;
89 WHERE pgno=5;
/sqlite-3.40.0/ext/fts5/
H A Dfts5_index.c239 #define FTS5_SEGMENT_ROWID(segid, pgno) fts5_dri(segid, 0, 0, pgno) argument
240 #define FTS5_DLIDX_ROWID(segid, height, pgno) fts5_dri(segid, 1, height, pgno) argument
2187 int pgno; in fts5SegIterReverse() local
2192 for(pgno=pIter->iLeafPgno+1; !p->rc && pgno<=pSeg->pgnoLast; pgno++){ in fts5SegIterReverse()
3136 pgnoSave = pgno+1; in fts5ChunkIterate()
3149 pgno++; in fts5ChunkIterate()
3907 pDlidx[1].pgno = pDlidx->pgno; in fts5WriteDlidxAppend()
3917 pDlidx->pgno++; in fts5WriteDlidxAppend()
3925 i64 iPgno = (i==0 ? pWriter->writer.pgno : pDlidx[-1].pgno); in fts5WriteDlidxAppend()
3967 pPage->pgno++; in fts5WriteFlushLeaf()
[all …]
/sqlite-3.40.0/ext/lsm1/lsm-test/
H A Dlsmtest_bt.c55 buf.pgno = 0; in do_bt()
59 buf.pgno = (u32)atoi(azArg[2]); in do_bt()
/sqlite-3.40.0/ext/lsm1/
H A Dlsm_main.c586 LsmPgno pgno = va_arg(ap, LsmPgno); in lsm_info() local
588 rc = lsmInfoArrayStructure(pDb, 0, pgno, pzVal); in lsm_info()
593 LsmPgno pgno = va_arg(ap, LsmPgno); in lsm_info() local
595 rc = lsmInfoArrayPages(pDb, pgno, pzVal); in lsm_info()
601 LsmPgno pgno = va_arg(ap, LsmPgno); in lsm_info() local
607 rc = lsmInfoPageDump(pDb, pgno, bHex, pzVal); in lsm_info()
/sqlite-3.40.0/ext/recover/
H A Ddbdata.c329 u32 pgno, /* Page number of page to load */ in dbdataLoadPage() argument
339 if( pgno>0 ){ in dbdataLoadPage()
340 sqlite3_bind_int64(pStmt, 2, pgno); in dbdataLoadPage()

12