Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add news for the 3.25.0 release. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
884ea7b3ed16eb30c25e49b9eceb5f2e |
User & Date: | drh 2018-09-14 16:54:24.865 |
Context
2018-09-14
| ||
17:42 | Fix minor typos detected by the spell checker. (check-in: c68e153fc6 user: drh tags: trunk) | |
16:54 | Add news for the 3.25.0 release. (check-in: 884ea7b3ed user: drh tags: trunk) | |
16:34 | The application_id is a signed integer. (check-in: 3580ba4b5b user: drh tags: trunk) | |
Changes
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 {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. } | > > > > > > > > > > > > > > > > > > > > > > > > > > | 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 46 47 48 49 50 51 52 53 | 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 {2018-09-15} {Release 3.25.0} { SQLite [version 3.25.0] is a regularly scheduled maintenance release. Two big enhancements in this release: <ol> <li><p> Support for [window functions] was added, using the PostgreSQL documentation as the baseline. <li><p> The [ALTER TABLE] command was enhanced to support renaming of columns, and so that column and table renames are propagated into trigger bodies and views. </ol> <p>In addition, there are various performance enhancements and minor fixes. <p>One bug of note is [https://www.sqlite.org/src/info/9936b2fa443fec03ff25|ticket 9936b2fa443fec] which describes a hard-to-reach condition where the ORDER BY LIMIT optimization might cause an infinite loop during query evaluation. This ticket raised a lot of concern on HackerNews and Reddit, probably due to my choice of the ticket title. "Infinite Loop" sounds scary. But I argue that the bug isn't really all that bad in that it is very difficult to reach, will show up during testing (rather than magically appearing after a product is deployed), does not cause any data loss, and does not return an incorrect result. It was an important error, but not nearly as dire as many people interpreted it to be. And, in any event, it is fixed now. } 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. } |
︙ | ︙ |