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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
d3b763b6a7b51b1b0112399aa5b9ac02 |
| User & Date: | drh 2019-07-09 13:13:03 |
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>
|