Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Changes for the 3.16.2 release. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
dea27852a00bf227e4b1835211524077 |
User & Date: | drh 2017-01-05 17:53:37.624 |
Context
2017-01-06
| ||
16:36 | Adjust the change log and hashes for the 3.16.2 release. (check-in: 140541287d user: drh tags: trunk) | |
2017-01-05
| ||
17:53 | Changes for the 3.16.2 release. (check-in: dea27852a0 user: drh tags: trunk) | |
2017-01-03
| ||
20:24 | Version 3.16.1 (check-in: a9be5c2caa user: drh tags: trunk, release, version-3.16.1) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
17 18 19 20 21 22 23 24 25 26 27 28 29 30 | proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2017-01-03 (3.16.1)} { <li>Fix a bug concerning the use of [row values] within [CREATE TRIGGER|triggers] (see ticket [https://www.sqlite.org/src/info/8c9458e7|8c9458e7]) that was in version 3.15.0 but was not reported until moments after the 3.16.0 release was published. <p><b>Hashes:</b> <li>SQLITE_SOURCE_ID: "2017-01-03 18:27:03 979f04392853b8053817a3eea2fc679947b437fd" | > > > > > > > > > > > > > > > > > > > > | 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 | proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2017-01-05 (3.16.2)} { <li>Fix the [REPLACE] statement for [WITHOUT ROWID] tables that lack secondary indexes so that it works correctly with triggers and foreign keys. This was a new bug caused by performance optimizations added in version 3.16.0. Ticket [https://www.sqlite.org/src/info/30027b613b4|30027b613b4] <li>Fix the [sqlite3_value_text()] interface so that it correctly translates content generated by [zeroblob()] into a string of all 0x00 characters. This is a long-standing issue discovered after the 3.16.1 release by [https://github.com/google/oss-fuzz|OSS-Fuzz] <li>Fix the bytecode generator to deal with a subquery in the FROM clause that is itself a UNION ALL where one side of the UNION ALL is a view that contains an ORDER BY. This is a long-standing issue that was discovered after the release of 3.16.1. See ticket [https://www.sqlite.org/src/info/190c2507|190c2507]. <p><b>Hashes:</b> <li>SQLITE_SOURCE_ID: "2017-01-05 17:27:12 285c5a54dd4f872ba98c5cd1bd3d61ae1360930f" <li>SHA1 for sqlite3.c: 66083bdd3626386c3d0af3213c26f8e21dbe8a73 } {patchagainst 1 patchagainst 2} chng {2017-01-03 (3.16.1)} { <li>Fix a bug concerning the use of [row values] within [CREATE TRIGGER|triggers] (see ticket [https://www.sqlite.org/src/info/8c9458e7|8c9458e7]) that was in version 3.15.0 but was not reported until moments after the 3.16.0 release was published. <p><b>Hashes:</b> <li>SQLITE_SOURCE_ID: "2017-01-03 18:27:03 979f04392853b8053817a3eea2fc679947b437fd" |
︙ | ︙ |
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 { 979f043928|2016-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 707875582f|2016-10-14|Version 3.15.0 29dbef4b85|2016-09-12|Version 3.14.2 a12d805977|2016-08-11|Version 3.14.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 { 285c5a54dd|2016-01-05|version 3.16.2 979f043928|2016-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 707875582f|2016-10-14|Version 3.15.0 29dbef4b85|2016-09-12|Version 3.14.2 a12d805977|2016-08-11|Version 3.14.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_16_2.html">Version 3.16.2</a> ([dateof:3.16.2]). <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> |
︙ | ︙ |
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 {2016-01-03} {Release 3.16.1} { SQLite [version 3.16.1] fixes a bug in the row-value logic for UPDATE statements inside of triggers. The bug has been there since row-values were added by release 3.15.0, but was not discovered until just a few minutes after the 3.16.0 release was published, and so it was not fixed by 3.16.0. This patch release is version 3.16.0 with the row-value bug fix. | > > > > > > > > | 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | 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 {2016-01-05} {Release 3.16.2} { One of the performance optimizations added in 3.16.0 caused triggers and foreign keys to malfunction for the [REPLACE] statement on [WITHOUT ROWID] tables that lack secondary indexes. This patch release fixes the problem. See ticket [https://www.sqlite.org/src/info/30027b613b4|30027b613b4] for details. } newsitem {2016-01-03} {Release 3.16.1} { SQLite [version 3.16.1] fixes a bug in the row-value logic for UPDATE statements inside of triggers. The bug has been there since row-values were added by release 3.15.0, but was not discovered until just a few minutes after the 3.16.0 release was published, and so it was not fixed by 3.16.0. This patch release is version 3.16.0 with the row-value bug fix. |
︙ | ︙ |