Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Minor tweaks to the change log and to the documentation for SQLITE_DQS. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
d3b763b6a7b51b1b0112399aa5b9ac02 |
User & Date: | drh 2019-07-09 13:13:03.409 |
Context
2019-07-10
| ||
11:45 | Fix typos (check-in: 7a5056a138 user: drh tags: trunk) | |
2019-07-09
| ||
13:13 | Minor tweaks to the change log and to the documentation for SQLITE_DQS. (check-in: d3b763b6a7 user: drh tags: trunk) | |
09:50 | Merge documentation fixes from the 3.28 release. (check-in: 02ab9d6bd3 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | chng {2019-07-00 (3.29.0)} { <li> Added the [SQLITE_DBCONFIG_DQS_DML] and [SQLITE_DBCONFIG_DQS_DDL] actions to [sqlite3_db_config()] for activating and deactivating the [double-quoted string literal] misfeature. Both default to "on" for legacy compatibility, but developers are encouraged to turn them "off", perhaps using the [-DSQLITE_DQS=0] compile-time option. <li> [-DSQLITE_DQS=0] is now a [recommended compile-time option]. <li> Improved optimization of AND and OR operators when one or the other operand is a constant. <li> Added the "[https://sqlite.org/src/file/ext/misc/dbdata.c|sqlite_dbdata]" virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt. <li> Enhancements to the [CLI]: <ol type="a"> <li> Add the ".recover" command which tries to recover as much content as possible from a corrupt database file. | > > > > > | 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 | chng {2019-07-00 (3.29.0)} { <li> Added the [SQLITE_DBCONFIG_DQS_DML] and [SQLITE_DBCONFIG_DQS_DDL] actions to [sqlite3_db_config()] for activating and deactivating the [double-quoted string literal] misfeature. Both default to "on" for legacy compatibility, but developers are encouraged to turn them "off", perhaps using the [-DSQLITE_DQS=0] compile-time option. <li> [-DSQLITE_DQS=0] is now a [recommended compile-time option]. <li> Improvements to the [query planner]: <ol type="a"> <li> Improved optimization of AND and OR operators when one or the other operand is a constant. <li> Enhancements to the [LIKE optimization] for cases when the left-hand side column has numeric affinity. </ol> <li> Added the "[https://sqlite.org/src/file/ext/misc/dbdata.c|sqlite_dbdata]" virtual table for extracting raw low-level content from an SQLite database, even a database that is corrupt. <li> Enhancements to the [CLI]: <ol type="a"> <li> Add the ".recover" command which tries to recover as much content as possible from a corrupt database file. |
︙ | ︙ |
Changes to pages/compile.in.
︙ | ︙ | |||
399 400 401 402 403 404 405 406 407 408 409 410 411 412 | The value set here cannot be more than [SQLITE_MAX_WORKER_THREADS]. } COMPILE_OPTION {SQLITE_DQS=<i>N</i>} { This macro determines the default values for [SQLITE_DBCONFIG_DQS_DDL] and [SQLITE_DBCONFIG_DQS_DML], which in turn how SQLite handles each [double-quoted string literal]. The <i>N</i> argument should be an integer 0, 1, 2, or 3. <blockquote><table border=1 cellpadding="0" cellspacing="0"> <tr><th rowspan="2">SQLITE_DQS<th colspan="2">Double-Quoted Strings Allowed <th rowspan="2">Remarks <tr><th>In DDL<th>In DML <tr><td>3<td>yes<td>yes<td>default <tr><td>2<td>yes<td>no<td> | > > | 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 | The value set here cannot be more than [SQLITE_MAX_WORKER_THREADS]. } COMPILE_OPTION {SQLITE_DQS=<i>N</i>} { This macro determines the default values for [SQLITE_DBCONFIG_DQS_DDL] and [SQLITE_DBCONFIG_DQS_DML], which in turn how SQLite handles each [double-quoted string literal]. The "DQS" name stands for "<u>D</u>ouble-<u>Q</u>uoted <u>S</u>tring". The <i>N</i> argument should be an integer 0, 1, 2, or 3. <blockquote><table border=1 cellpadding="0" cellspacing="0"> <tr><th rowspan="2">SQLITE_DQS<th colspan="2">Double-Quoted Strings Allowed <th rowspan="2">Remarks <tr><th>In DDL<th>In DML <tr><td>3<td>yes<td>yes<td>default <tr><td>2<td>yes<td>no<td> |
︙ | ︙ |