Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Clarify restrictions on the use of PRAGMA page_size. |
|---|---|
| Timelines: | family | ancestors | descendants | both | branch-3.12 |
| Files: | files | file ages | folders |
| SHA1: |
44656180a0ab71985c8c8688e9435d61 |
| User & Date: | drh 2016-04-25 21:58:55 |
Context
|
2016-05-05
| ||
| 13:28 | Clarify that using an database file with a link count different from 1 results in undefined behavior. Leaf check-in: 7c96132d65 user: drh tags: branch-3.12 | |
|
2016-04-25
| ||
| 21:58 | Clarify restrictions on the use of PRAGMA page_size. check-in: 44656180a0 user: drh tags: branch-3.12 | |
|
2016-04-18
| ||
| 18:37 | Add hashes to the 3.12.2 change log. check-in: 7e800725ac user: drh tags: branch-3.12 | |
Changes
Changes to pages/pragma.in.
798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 |
<p>^When a new database is created, SQLite assigned a page size to
the database based on platform and filesystem. For many years,
the default page size was almost always 1024 bytes, but beginning
with SQLite [version 3.12.0] in 2016, the default page size increased
to 4096.
<p>^The page_size pragma will only cause an immediate change in the
page size if it is issued while the database is still empty, prior
to the first CREATE TABLE statement. ^(If the page_size pragma is
used to specify a new page size just prior to
running the [VACUUM] command and if the database is not in
[WAL | WAL journal mode] then [VACUUM] will change the page
size to the new value.)^</p>
<p>^The [SQLITE_DEFAULT_PAGE_SIZE] compile-time option can be used
to change the default page size assigned to new databases.
|
| > | |
798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 |
<p>^When a new database is created, SQLite assigned a page size to
the database based on platform and filesystem. For many years,
the default page size was almost always 1024 bytes, but beginning
with SQLite [version 3.12.0] in 2016, the default page size increased
to 4096.
<p>^The page_size pragma will only cause an immediate change in the
page size if it is issued while the database is still empty (prior
to the first CREATE statement) and if the database is not in
[WAL mode]. ^(If the page_size pragma is
used to specify a new page size just prior to
running the [VACUUM] command and if the database is not in
[WAL | WAL journal mode] then [VACUUM] will change the page
size to the new value.)^</p>
<p>^The [SQLITE_DEFAULT_PAGE_SIZE] compile-time option can be used
to change the default page size assigned to new databases.
|