Lines Matching defs:pgno
11438 ** pgno INTEGER,
11465 ** INSERT INTO sqlite_dbdata(pgno, cell, field, value) VALUES
11481 ** pgno INTEGER,
11550 " pgno INTEGER," \
11563 " pgno INTEGER," \
11613 ** pgno=?
11616 ** the 0x01 bit in idxNum is set. If pgno=? is present, the 0x02 bit
11619 ** If both parameters are present, schema is in position 0 and pgno in
11733 ** Load page pgno from the database via the sqlite_dbpage virtual table.
11744 u32 pgno, /* Page number of page to load */
11754 if( pgno>0 ){
11755 sqlite3_bind_int64(pStmt, 2, pgno);
12215 "SELECT data FROM sqlite_dbpage(?) WHERE pgno=?", -1,
13264 ** SELECT page_is_used(<pgno>);
13272 i64 pgno = sqlite3_value_int64(apArg[0]);
13274 sqlite3_result_int(pCtx, recoverBitmapQuery(p->laf.pUsed, pgno));
13297 i64 pgno = sqlite3_value_int64(apArg[0]);
13301 if( pgno==0 ){
13308 p, p->dbIn, "SELECT data FROM sqlite_dbpage(%Q) WHERE pgno=?", p->zDb
13315 sqlite3_bind_int64(pStmt, 1, pgno);
13322 if( pgno==1 && nPg==p->pgsz && 0==memcmp(p->pPage1Cache, aPg, nPg) ){
13465 " SELECT child FROM sqlite_dbptr('getpage()'), pages WHERE pgno=p"
13473 "FROM sqlite_dbdata('getpage()') WHERE pgno IN ("
13475 ") GROUP BY pgno, cell"
13626 "CREATE TABLE recovery.map(pgno INTEGER PRIMARY KEY, parent INT);"
14022 zSep = "rootpgno INTEGER, pgno INTEGER, nfield INTEGER, id INTEGER, ";
14098 "WITH RECURSIVE p(pgno) AS ("
14101 " SELECT parent FROM recovery.map AS m, p WHERE m.pgno=p.pgno"
14103 "SELECT p.pgno FROM p, recovery.map m WHERE m.pgno=p.pgno "
14145 sqlite3_bind_int64(pInsert, 2, iPage); /* pgno */
14249 "FROM sqlite_dbdata('getpage()') d WHERE d.pgno=? "
14294 " WHERE pgno=page"
14297 "FROM sqlite_dbdata('getpage()') d, pages p WHERE p.page=d.pgno "
14468 "WITH trunk(pgno) AS ("
14471 " SELECT read_i32(getpage(trunk.pgno), 0) AS x FROM trunk WHERE x>0"
14473 "trunkdata(pgno, data) AS ("
14474 " SELECT pgno, getpage(pgno) FROM trunk"
14477 " SELECT data, min(16384, read_i32(data, 1)-1), pgno FROM trunkdata"
14490 " WHERE pgno=page"
14537 "INSERT OR IGNORE INTO recovery.map(pgno, parent) VALUES(?, ?)"
14543 "SELECT pgno, child FROM sqlite_dbptr('getpage()') "
14548 "SELECT max(field)+1 FROM sqlite_dbdata('getpage') WHERE pgno = ?"
20365 "SELECT data FROM sqlite_dbpage(?1) WHERE pgno=1",