Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Version 3.19.1 |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk | release | version-3.19.1 |
Files: | files | file ages | folders |
SHA3-256: |
522b8714da4be72b7e284067eb2de3f3 |
User & Date: | drh 2017-05-24 13:18:20.086 |
Context
2017-05-25
| ||
00:40 | Initial changes for the 3.19.2 release. (check-in: 21ff2eb546 user: drh tags: trunk) | |
2017-05-24
| ||
13:18 | Version 3.19.1 (check-in: 522b8714da user: drh tags: trunk, release, version-3.19.1) | |
2017-05-23
| ||
12:49 | Start a change log for the 3.19.1 patch release. (check-in: 3abd703937 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
21 22 23 24 25 26 27 28 29 30 31 32 33 34 | incr nChng } chng {2017-05-24 (3.19.1)} { <li>Fix a bug in the LEFT JOIN flattener optimization. (see ticket [https://www.sqlite.org/src/info/cad1ab4cb7b0fc|cad1ab4cb7b0fc]) <li>Remove a surplus semicolon that was causing problems for older versions of MSVC. } {patchagainst 1} chng {2017-05-22 (3.19.0)} { <li> The [SQLITE_READ] [authorizer callback] is invoked once with a column name that is an empty string for every table referenced in a query from which no columns are extracted. <li> When using an index on an expression, try to use expression values already | > > > | 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | incr nChng } chng {2017-05-24 (3.19.1)} { <li>Fix a bug in the LEFT JOIN flattener optimization. (see ticket [https://www.sqlite.org/src/info/cad1ab4cb7b0fc|cad1ab4cb7b0fc]) <li>Remove a surplus semicolon that was causing problems for older versions of MSVC. <p><b>Hashes:</b> <li>SQLITE_SOURCE_ID: "2017-05-24 13:08:33 f6d7b988f40217821a382bc298180e9e6794f3ed79a83c6ef5cae048989b3f86" <li>SHA3-256 for sqlite3.c: 996b2aff37b6e0c6663d0312cd921bbdf6826c989cbbb07dadde5e9672889bca } {patchagainst 1} chng {2017-05-22 (3.19.0)} { <li> The [SQLITE_READ] [authorizer callback] is invoked once with a column name that is an empty string for every table referenced in a query from which no columns are extracted. <li> When using an index on an expression, try to use expression values already |
︙ | ︙ |
Changes to pages/chronology.in.
︙ | ︙ | |||
24 25 26 27 28 29 30 | # 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 { | | | 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 { f6d7b988f4|2017-05-24|version 3.19.1 28a94eb282|2017-05-22|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 |
︙ | ︙ |
Changes to pages/news.in.
︙ | ︙ | |||
14 15 16 17 18 19 20 21 22 23 24 25 26 27 | hd_puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt regsub -all {[Tt]icket #(\d+)} $txt \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt hd_resolve "<blockquote>$txt</blockquote>" hd_puts "<hr width=\"50%\">" } newsitem {2017-05-22} {Release 3.19.0} { SQLite [version 3.19.0] is a regularly scheduled maintenance release. <p> The emphasis on this release is improvements to the query planner. There are also some obscure bug fixes. There is no reason to upgrade unless you are having problems with a prior release. | > > > > > > > > > > > > > > > > > > | 14 15 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 | hd_puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt regsub -all {[Tt]icket #(\d+)} $txt \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt hd_resolve "<blockquote>$txt</blockquote>" hd_puts "<hr width=\"50%\">" } newsitem {2017-05-24} {Release 3.19.1} { One of the new query planner optimizations in the 3.19.0 release contained bugs. The 3.19.1 patch release fixes them. <p> Beginning with 3.19.0, subqueries and views on the right-hand side of a LEFT JOIN operator could sometimes be [https://sqlite.org/optoverview.html#flattening|flattened] into the main query. The new optimization worked well for all of the test cases that the developers devised, and for millions of legacy test cases, but once 3.19.0 was released, users found some other cases where the optimization failed. Ticket [https://sqlite.org/src/info/cad1ab4cb7b0fc344|cad1ab4cb7b0fc344] contains examples. <p> These problems exist only in 3.19.0. Users of SQLite 3.19.0 should upgrade, but users of all prior versions of SQLite are safe. } newsitem {2017-05-22} {Release 3.19.0} { SQLite [version 3.19.0] is a regularly scheduled maintenance release. <p> The emphasis on this release is improvements to the query planner. There are also some obscure bug fixes. There is no reason to upgrade unless you are having problems with a prior release. |
︙ | ︙ |