Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add a change log entry for the pending 3.19.0 release. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
31ead1aadea46b4ed0945a8ec4254e1a |
User & Date: | drh 2017-04-18 11:40:43.298 |
Context
2017-04-18
| ||
11:52 | Update to the flattening optimization description in the optoverview.html page. Add a new bullet to the change log for 3.19.0. (check-in: d26b238e7e user: drh tags: trunk) | |
11:40 | Add a change log entry for the pending 3.19.0 release. (check-in: 31ead1aade user: drh tags: trunk) | |
11:07 | Update the perfomance and size spreadsheet with the latest figures. (check-in: 7b34966b61 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
16 17 18 19 20 21 22 23 24 25 26 27 28 29 | set nChng 0 proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2017-03-30 (3.18.0)} { <li>Added the [PRAGMA optimize] command <li>The SQLite version identifier returned by the [sqlite_source_id()] SQL function and the [sqlite3_sourceid()] C API and found in the [SQLITE_SOURCE_ID] macro is now a 64-digit SHA3-256 hash instead of a 40-digit SHA1 hash. <li>Added the [json_patch()] SQL function to the [json1|JSON1 extension]. | > > > > > > > > > > > > > > > > > > > > > > > > > > > | 16 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 45 46 47 48 49 50 51 52 53 54 55 56 | set nChng 0 proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2017-00-00 (3.19.0)} { <li> When using an index on an expression, try to use expression values already available in the index, rather than loading the original columns and recomputing the expression. <li> Enhance the [flattening optimization] so that it is able to flatten views on the right-hand side of a LEFT JOIN. <li> Use [replace()] instead of [char()] for escaping newline and carriage-return characters embedded in strings in the .dump output from the [command-line shell]. <li> Avoid unnecessary foreign key processing in UPDATE statements that do not touch the columns that are constrained by the foreign keys. <li> On a DISTINCT query that uses an index, try to skip ahead to the next distinct entry using the index rather that stepping through rows, when an appropriate index is available. <p><b>Bug Fixes:</b> <li> Fix a problem in [PRAGMA integrity_check] that was causing a subsequent [VACUUM] to behave suboptimally. <li> Fix the [PRAGMA foreign_key_check] command so that it works correctly with foreign keys on [WITHOUT ROWID] tables. <li> Disallow leading zeros in numeric constants in JSON. Fix for ticket [https://www.sqlite.org/src/info/b93be8729a895a528e2|b93be8729a895a528e2]. <li> Disallow control characters inside of strings in JSON. Fix for ticket [https://www.sqlite.org/src/info/6c9b5514077fed34551|6c9b5514077fed34551]. <li> Limit the depth of recursion for JSON objects and arrays in order to avoid excess stack usage in the recursive descent parser. Fix for ticket [https://www.sqlite.org/src/info/981329adeef51011052|981329adeef51011052]. } chng {2017-03-30 (3.18.0)} { <li>Added the [PRAGMA optimize] command <li>The SQLite version identifier returned by the [sqlite_source_id()] SQL function and the [sqlite3_sourceid()] C API and found in the [SQLITE_SOURCE_ID] macro is now a 64-digit SHA3-256 hash instead of a 40-digit SHA1 hash. <li>Added the [json_patch()] SQL function to the [json1|JSON1 extension]. |
︙ | ︙ |
Changes to pages/chronology.in.
︙ | ︙ | |||
24 25 26 27 28 29 30 31 32 33 34 35 36 37 | # ORDER BY mtime DESC; # # A small amount of manual editing and de-duplication followed. # # Manually edit the list for each subsequent release. # foreach line [split { 424a0d3803|2017-03-28|version 3.18.0 ada05cfa86|2017-02-13|version 3.17.0 a65a62893c|2017-01-06|version 3.16.2 979f043928|2017-01-03|Version 3.16.1 04ac0b75b1|2017-01-02|Version 3.16.0 bbd85d235f|2016-11-28|Version 3.15.2 1136863c76|2016-11-04|Version 3.15.1 | > | 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | # ORDER BY mtime DESC; # # A small amount of manual editing and de-duplication followed. # # Manually edit the list for each subsequent release. # foreach line [split { xxxxxxxxxx|(pending)|version 3.19.0 424a0d3803|2017-03-28|version 3.18.0 ada05cfa86|2017-02-13|version 3.17.0 a65a62893c|2017-01-06|version 3.16.2 979f043928|2017-01-03|Version 3.16.1 04ac0b75b1|2017-01-02|Version 3.16.0 bbd85d235f|2016-11-28|Version 3.15.2 1136863c76|2016-11-04|Version 3.15.1 |
︙ | ︙ |
Changes to pages/index.in.
︙ | ︙ | |||
10 11 12 13 14 15 16 | [full-featured SQL|full-featured], [public-domain], SQL database engine. SQLite is the [most used] database engine in the world. <a class="button" href="about.html">More Info</a></p> <hr class="xhr"> <span class="hdrfont">Latest Release: </span> | | | 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | [full-featured SQL|full-featured], [public-domain], SQL database engine. SQLite is the [most used] database engine in the world. <a class="button" href="about.html">More Info</a></p> <hr class="xhr"> <span class="hdrfont">Latest Release: </span> <a href="releaselog/3_19_0.html">Version 3.19.0</a> ([dateof:3.19.0]). <a class="button" href="download.html">Download</a> <a class="button" href="chronology.html">Prior Releases</a> <div class="mobileonly"> <hr class="xhr"> <h3>Common Links</h3> <tcl>common_links</tcl> |
︙ | ︙ |