Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Updates to the change log for version 3.20.0 |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
424efe16333cba1bdbd1d05d2cd192fb |
User & Date: | drh 2017-07-10 20:11:32.726 |
Context
2017-07-11
| ||
14:31 | Mention tab-completion in the change log for 3.20.0. (check-in: bc8bf74d88 user: drh tags: trunk) | |
2017-07-10
| ||
20:11 | Updates to the change log for version 3.20.0 (check-in: 424efe1633 user: drh tags: trunk) | |
19:55 | Merge fixes from the 3.19 branch. (check-in: fea84d9dc3 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
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 45 46 47 48 49 50 51 52 53 54 55 56 | global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2017-08-31 (3.20.0)} { <li> Added the LSM1 extension <li> Added the [STMT virtual table] extension <li> Added the [sqlite3_prepare_v3()] and [sqlite3_prepare16_v3()] interfaces with the extra "prepFlags" parameters. <li> Provide the [SQLITE_PREPARE_PERSISTENT] flag [sqlite3_prepare_v3()] and use it to limit [lookaside memory] misuse by [FTS3], [FTS5], and the [R-Tree extension] <li> Enhancements to the [command-line shell]: <ul> <li> Add the ".cd" command. <li> Enhance the ".schema" command to show the schema of all attached databases. <li> Enhance ".tables" so that it shows the schema names for all attached if the name is anything other than "main". <li> The ".import" command ignores an initial UTF-8 BOM. </ul> <li> Query planner enhancements: <ul> <li> When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. <li> The query planner examines the values of bound parameters to help determine if a partial index is usable. <li> When deciding between two plans with the same estimated cost, bias the selection toward the one that does not use the sorter. </ul> <li> Add [SQLITE_STMTSTATUS_REPREPARE], [SQLITE_STMTSTATUS_RUN], and [SQLITE_STMTSTATUS_MEMUSED] options for the [sqlite3_stmt_status()] interface. <li> Provide eponymous virtual tables for [PRAGMA integrity_check], [PRAGMA quick_check], and [PRAGMA foreign_key_check]. | > > > > > > > > > > > | 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 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 | global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2017-08-31 (3.20.0)} { <li> Update the text of error messages returned by [sqlite3_errmsg()] for some error codes. <li> Added the LSM1 extension <li> Added the [STMT virtual table] extension <li> Added the [sqlite3_prepare_v3()] and [sqlite3_prepare16_v3()] interfaces with the extra "prepFlags" parameters. <li> Provide the [SQLITE_PREPARE_PERSISTENT] flag [sqlite3_prepare_v3()] and use it to limit [lookaside memory] misuse by [FTS3], [FTS5], and the [R-Tree extension] <li> Added the [PRAGMA secure_delete=FAST] command. When secure_delete is set to FAST, old content is overwritten with zeros as long as that does not increase the amount of I/O. Deleted content might still persist on the [free-page list] but will be purged from all b-tree pages. <li> Enhancements to the [command-line shell]: <ul> <li> Add the ".cd" command. <li> Enhance the ".schema" command to show the schema of all attached databases. <li> Enhance ".tables" so that it shows the schema names for all attached if the name is anything other than "main". <li> The ".import" command ignores an initial UTF-8 BOM. <li> Added the "--newlines" option to the ".dump" command to cause U+000a and U+000d characters to be output literally rather than escaped using the [replace()] function. </ul> <li> Query planner enhancements: <ul> <li> When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. <li> The query planner examines the values of bound parameters to help determine if a partial index is usable. <li> When deciding between two plans with the same estimated cost, bias the selection toward the one that does not use the sorter. <li> Evaluation WHERE clause constraints involving correlated subqueries last, in the hope that they never have be evaluated at all. </ul> <li> Add [SQLITE_STMTSTATUS_REPREPARE], [SQLITE_STMTSTATUS_RUN], and [SQLITE_STMTSTATUS_MEMUSED] options for the [sqlite3_stmt_status()] interface. <li> Provide eponymous virtual tables for [PRAGMA integrity_check], [PRAGMA quick_check], and [PRAGMA foreign_key_check]. |
︙ | ︙ |