Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add an entry on the cell_size_check pragma. Updates to the change log. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
0bf50a0382767cbf9a5ac8c9394914c3 |
User & Date: | drh 2015-05-29 19:05:46.572 |
Context
2015-05-30
| ||
20:51 | Fix a typo in the SQLITE_BUSY_SNAPSHOT documentation. (check-in: fe158a6ae2 user: drh tags: trunk) | |
2015-05-29
| ||
19:05 | Add an entry on the cell_size_check pragma. Updates to the change log. (check-in: 0bf50a0382 user: drh tags: trunk) | |
2015-05-25
| ||
09:22 | Fix typo in the "deprecated" footnote on the pragma list. (check-in: 7555c435cc user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
17 18 19 20 21 22 23 | set aChng($nChng) [list $date $desc $options] incr nChng } chng {2015-00-00 (3.8.11)} { <li>Added the [sqlite3_value_dup()] and [sqlite3_value_free()] interfaces. <li>The [IS operator] is now able to drive indexes. | > > > > > > > > | | | > > | 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 | set aChng($nChng) [list $date $desc $options] incr nChng } chng {2015-00-00 (3.8.11)} { <li>Added the [sqlite3_value_dup()] and [sqlite3_value_free()] interfaces. <li>The [IS operator] is now able to drive indexes. <li>Enhance the query planner to permit [automatic indexing] on FROM-clause subqueries that are implemented by co-routine. <li>Disallow the use of "rowid" in [common table expressions]. <li>Added the [PRAGMA cell_size_check] command for better and earlier detection of database file corruption. <li>Improved fuzz-testing of database files, with fixes for problems found. <li>Add the fuzzcheck test program and automatically run this program using both SQL and database test cases on "make test". <p><b>Important bug fixes:</b> <li>Fix to CREATE TABLE AS so that columns of type TEXT never end up holding an INT value. Ticket [https://www.sqlite.org/src/info/f2ad7de056ab1dc9200|f2ad7de056ab1dc9200] <li>Fix the [sqlite3_memory_used()] and [sqlite3_memory_highwater()] interfaces so that they actually do provide a 64-bit answer. } chng {2015-05-20 (3.8.10.2)} { <li>Fix an index corruption issue introduced by [version 3.8.7]. An index with a TEXT key can be corrupted by an [INSERT] into the corresponding table if the table has two nested triggers that convert the key value to INTEGER and back to TEXT again. |
︙ | ︙ |
Changes to pages/pragma.in.
︙ | ︙ | |||
295 296 297 298 299 300 301 302 303 304 305 306 307 308 | significant. So, for example, <b>'a' LIKE 'A'</b> is false but <b>'a' LIKE 'a'</b> is still true.)^</p> <p>^This pragma uses [sqlite3_create_function()] to overload the LIKE and GLOB functions, which may override previous implementations of LIKE and GLOB registered by the application.</p> } Pragma checkpoint_fullfsync { <p>^(<b>PRAGMA checkpoint_fullfsync <br>PRAGMA checkpoint_fullfsync = </b><i>boolean</i><b>;</b></p> <p>Query or change the fullfsync flag for [checkpoint] operations.)^ ^If this flag is set, then the F_FULLFSYNC syncing method is used during checkpoint operations on systems that support F_FULLFSYNC. | > > > > > > > > > > > | 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 | significant. So, for example, <b>'a' LIKE 'A'</b> is false but <b>'a' LIKE 'a'</b> is still true.)^</p> <p>^This pragma uses [sqlite3_create_function()] to overload the LIKE and GLOB functions, which may override previous implementations of LIKE and GLOB registered by the application.</p> } Pragma cell_size_check { <p>^(<b>PRAGMA cell_size_check <br>PRAGMA cell_size_check = </b><i>boolean</i><b>;</b></p> <p>The cell_size_check pragma enables or disables additional sanity checking on database b-tree pages as they are initially read from disk. With cell size checking enabled, database corruption is detected earlier and is less likely to "spread". However, there is a small performance hit for doing the extra checks and so cell size checking is turned off by default. } Pragma checkpoint_fullfsync { <p>^(<b>PRAGMA checkpoint_fullfsync <br>PRAGMA checkpoint_fullfsync = </b><i>boolean</i><b>;</b></p> <p>Query or change the fullfsync flag for [checkpoint] operations.)^ ^If this flag is set, then the F_FULLFSYNC syncing method is used during checkpoint operations on systems that support F_FULLFSYNC. |
︙ | ︙ |