Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | The page_size pragma preserves the reserved area at the end of each page. (CVS 1964) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
c34f3209e5028e008ea9e2c43f1e0d97 |
| User & Date: | drh 2004-09-17 20:25:25 |
Context
|
2004-09-17
| ||
| 20:46 | Close stray statements prior to finishing trace.test, to avoid a file descriptor leak. (CVS 1965) check-in: 8bb0221d user: drh tags: trunk | |
| 20:25 | The page_size pragma preserves the reserved area at the end of each page. (CVS 1964) check-in: c34f3209 user: drh tags: trunk | |
| 20:02 | Get VACUUM working on databases that have reserved bytes at the end of each page. (CVS 1963) check-in: 90bb3af6 user: drh tags: trunk | |
Changes
Changes to src/pragma.c.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
|
** May you do good and not evil. ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains code used to implement the PRAGMA command. ** ** $Id: pragma.c,v 1.65 2004/09/08 15:09:41 drh Exp $ */ #include "sqliteInt.h" #include <ctype.h> #if defined(SQLITE_DEBUG) || defined(SQLITE_TEST) # include "pager.h" # include "btree.h" ................................................................................ */ if( sqlite3StrICmp(zLeft,"page_size")==0 ){ Btree *pBt = pDb->pBt; if( !zRight ){ int size = pBt ? sqlite3BtreeGetPageSize(pBt) : 0; returnSingleInt(pParse, "page_size", size); }else{ sqlite3BtreeSetPageSize(pBt, atoi(zRight), 0); } }else /* ** PRAGMA [database.]cache_size ** PRAGMA [database.]cache_size=N ** |
|
|
|
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
|
** May you do good and not evil. ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains code used to implement the PRAGMA command. ** ** $Id: pragma.c,v 1.66 2004/09/17 20:25:25 drh Exp $ */ #include "sqliteInt.h" #include <ctype.h> #if defined(SQLITE_DEBUG) || defined(SQLITE_TEST) # include "pager.h" # include "btree.h" ................................................................................ */ if( sqlite3StrICmp(zLeft,"page_size")==0 ){ Btree *pBt = pDb->pBt; if( !zRight ){ int size = pBt ? sqlite3BtreeGetPageSize(pBt) : 0; returnSingleInt(pParse, "page_size", size); }else{ sqlite3BtreeSetPageSize(pBt, atoi(zRight), sqlite3BtreeGetReserve(pBt)); } }else /* ** PRAGMA [database.]cache_size ** PRAGMA [database.]cache_size=N ** |