Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Enhance the PRAGMA journal_mode=OFF documentation to make it clear that ordinary SQL can corrupt the database file while in that mode. See ticket https://www.sqlite.org/src/info/f4ec250930342e0c |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
5f361950a72fd1f69e44624e418085ed |
User & Date: | drh 2019-05-17 20:39:53.152 |
Context
2019-05-21
| ||
11:14 | IE11 does not understand a 308 redirect, so always use a 301 redirect instead. (check-in: 91021e98e3 user: drh tags: trunk) | |
2019-05-17
| ||
20:39 | Enhance the PRAGMA journal_mode=OFF documentation to make it clear that ordinary SQL can corrupt the database file while in that mode. See ticket https://www.sqlite.org/src/info/f4ec250930342e0c (check-in: 5f361950a7 user: drh tags: trunk) | |
17:22 | Fix a harmless compiler warning about the return value of freopen() in althttpd. (check-in: 445195faaf user: drh tags: trunk) | |
Changes
Changes to pages/pragma.in.
︙ | ︙ | |||
417 418 419 420 421 422 423 | on the value of the case_sensitive_like pragma. ^When case_sensitive_like is disabled, the default LIKE behavior is expressed. ^(When case_sensitive_like is enabled, case becomes 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 | | | < < < < < < | < < < < < < < < < < < < < < | 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 | on the value of the case_sensitive_like pragma. ^When case_sensitive_like is disabled, the default LIKE behavior is expressed. ^(When case_sensitive_like is enabled, case becomes 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. ^(This pragma only changes the behavior of the SQL [LIKE] operator. It does not change the behavior of the [sqlite3_strlike()] C-language interface, which is always case insensitive.)^</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.)^ |
︙ | ︙ | |||
744 745 746 747 748 749 750 | journal to delete. The OFF journaling mode disables the atomic commit and rollback capabilities of SQLite. The [ROLLBACK] command no longer works; it behaves in an undefined way. Applications must avoid using the [ROLLBACK] command when the journal mode is OFF. ^If the application crashes in the middle of a transaction when the OFF journaling mode is set, then the database file will very likely | | > > > > > > > > | 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 | journal to delete. The OFF journaling mode disables the atomic commit and rollback capabilities of SQLite. The [ROLLBACK] command no longer works; it behaves in an undefined way. Applications must avoid using the [ROLLBACK] command when the journal mode is OFF. ^If the application crashes in the middle of a transaction when the OFF journaling mode is set, then the database file will very likely [cfgerrors|go corrupt]. Without a journal, there is no way for a statement to unwind partially completed operations following a constraint error. This might also leave the database in a corrupted state. For example, if a duplicate entry causes a [CREATE INDEX|CREATE UNIQUE INDEX] statement to fail half-way through, it will leave behind a partially created, and hence corrupt, index. Because OFF journaling mode allows the database file to be corrupted using ordinary SQL, it is disabled when [SQLITE_DBCONFIG_DEFENSIVE] is enabled.</p> <p>^Note that the journal_mode for an [in-memory database] is either MEMORY or OFF and can not be changed to a different value. ^An attempt to change the journal_mode of an [in-memory database] to any setting other than MEMORY or OFF is ignored. ^Note also that the journal_mode cannot be changed while a transaction is active.</p> } |
︙ | ︙ |