Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add the final date and various hashes for the 3.24.0 release. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
c300836d839035f205f3b03603274983 |
User & Date: | drh 2018-06-04 19:28:23.312 |
Context
2018-06-04
| ||
19:41 | Add the upsert-clause.gif image. (check-in: 7d927bcea1 user: drh tags: trunk) | |
19:28 | Add the final date and various hashes for the 3.24.0 release. (check-in: c300836d83 user: drh tags: trunk) | |
2018-06-01
| ||
17:41 | Add the Sanderson book to the books.html page. (check-in: 97f6d1477c user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
17 18 19 20 21 22 23 | proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } | | | 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2018-06-04 (3.24.0)} { <li> Add support for PostgreSQL-style [UPSERT]. <li> Add support for [auxiliary columns in r-tree tables]. <li> Add C-language APIs for discovering SQL keywords used by SQLite: [sqlite3_keyword_count()], [sqlite3_keyword_name()], and [sqlite3_keyword_check()]. <li> Add C-language APIs for dynamic strings based on the [sqlite3_str] object. |
︙ | ︙ | |||
80 81 82 83 84 85 86 | [sqlite_sequence] table used by [AUTOINCREMENT] can lead to a crash. Ticket [https://www.sqlite.org/src/info/d8dc2b3a58cd5dc29|d8dc2b3a58cd5dc2918a1] <li> Fix the [json_each()] function so that it returns valid results on its "fullkey" column when the input is a simple value rather than an array or object. <p><b>Hashes:</b> | | | | 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 | [sqlite_sequence] table used by [AUTOINCREMENT] can lead to a crash. Ticket [https://www.sqlite.org/src/info/d8dc2b3a58cd5dc29|d8dc2b3a58cd5dc2918a1] <li> Fix the [json_each()] function so that it returns valid results on its "fullkey" column when the input is a simple value rather than an array or object. <p><b>Hashes:</b> <li>SQLITE_SOURCE_ID: "2018-06-04 19:24:41 c7ee0833225bfd8c5ec2f9bf62b97c4e04d03bd9566366d5221ac8fb199a87ca" <li>SHA3-256 for sqlite3.c: 0d384704e1c66026228336d1e91771d295bf688c9c44c7a44f25a4c16c26ab3c } chng {2018-04-10 (3.23.1)} { <li> Fix two problems in the new [LEFT JOIN strength reduction optimization]. Tickets [https://sqlite.org/src/info/1e39b966ae9ee739|1e39b966ae9ee739] and [https://sqlite.org/src/info/fac496b61722daf2|fac496b61722daf2]. |
︙ | ︙ |
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 { c7ee083322|2018-06-04|Version 3.24.0 4bb2294022|2018-04-10|Version 3.23.1 736b53f57f|2018-04-02|Version 3.23.0 0c55d17973|2018-01-22|Version 3.22.0 1a584e4999|2017-10-24|Version 3.21.0 8d3a7ea6c5|2017-08-24|Version 3.20.1 9501e22dfe|2017-08-01|Version 3.20.0 036ebf729e|2017-06-17|Version 3.18.2 |
︙ | ︙ |
Changes to pages/news.in.
︙ | ︙ | |||
15 16 17 18 19 20 21 | 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%\">" } | | | 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | 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 {2018-06-04} {Release 3.24.0} { SQLite [version 3.24.0] is a regularly scheduled maintenance release. Highlights of this release include support for PostgreSQL-style UPSERT and improved performance, especially for ORDER BY LIMIT queries. } newsitem {2018-04-10} {Release 3.23.1} { The [version 3.23.1] release fixes a bug in the new |
︙ | ︙ |