Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Updates for the 3.8.3.1 release. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
f2ce0c9b8e190258ef3f67d4ed75c16e |
User & Date: | drh 2014-02-11 14:30:18.601 |
Context
2014-02-11
| ||
16:36 | Add SOURCE_ID and SHA1 hash for the 3.8.3.1 release. (check-in: d882698e7b user: drh tags: trunk) | |
14:30 | Updates for the 3.8.3.1 release. (check-in: f2ce0c9b8e user: drh tags: trunk) | |
2014-02-10
| ||
17:49 | Fix a typo in the WITH documentation. (check-in: 4cd3bb5ab2 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
13 14 15 16 17 18 19 20 21 22 23 24 25 26 | <tcl> set nChng 0 proc chng {date desc {options {}}} { global nChng aChng set aChng($nChng) [list $date $desc $options] incr nChng } chng {2014-02-03 (3.8.3)} { <li>Added support for [common table expressions] and the [WITH clause]. <li>Added the [printf()] SQL function. <li>Added [SQLITE_DETERMINISTIC] as an optional bit in the 4th argument to the [sqlite3_create_function()] and related interfaces, providing applications with the ability to create new functions that can be factored out of inner loops when | > > > > > > > > | 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | <tcl> set nChng 0 proc chng {date desc {options {}}} { global nChng aChng set aChng($nChng) [list $date $desc $options] incr nChng } chng {2014-02-11 (3.8.3.1)} { <li>Fix a bug (ticket [http://www.sqlite.org/src/info/4c86b126f2|4c86b126f2]) that causes rows to go missing on some queries with OR clauses and IS NOT NULL operators in the WHERE clause, when the [SQLITE_ENABLE_STAT3] or [SQLITE_ENABLE_STAT4] compile-time options are used. <li>Fix a harmless compiler warning that was causing problems for VS2013. } chng {2014-02-03 (3.8.3)} { <li>Added support for [common table expressions] and the [WITH clause]. <li>Added the [printf()] SQL function. <li>Added [SQLITE_DETERMINISTIC] as an optional bit in the 4th argument to the [sqlite3_create_function()] and related interfaces, providing applications with the ability to create new functions that can be factored out of inner loops when |
︙ | ︙ |
Changes to pages/index.in.
︙ | ︙ | |||
91 92 93 94 95 96 97 | </td> <td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td> <td valign="top"> <h3>Current Status</h3> <p><ul> | | | | 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 | </td> <td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td> <td valign="top"> <h3>Current Status</h3> <p><ul> <li><a href="releaselog/3_8_3_1.html">Version 3.8.3.1</a> of SQLite is recommended for all new development. Upgrading from versions 3.7.17, 3.8.0.2 is optional. Upgrading from all other prior versions of SQLite is recommended.</li> </ul></p> <h3>Common Links</h3> <p><ul> |
︙ | ︙ |
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 {2014-02-03} {Release 3.8.3} { <p>SQLite [version 3.8.3] is a regularly scheduled maintenance release. Upgrading from the previous release is optional. <p>The most visible change in version 3.8.3 is the addition of support for [common table expressions]. It is now possible to write a | > > > > > > > > > > > > > > > > > > > > > > | 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 | 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 {2014-02-11} {Release 3.8.3.1} { <p>SQLite [version 3.8.3.1] fixes a bug present in versions 3.8.1, 3.8.2 and 3.8.3 that can cause queries to omit valid out rows. Upgrading from those versions is recommended. <p>The problem only comes up if SQLite is compiled with either the [SQLITE_ENABLE_STAT3] or [SQLITE_ENABLE_STAT4] compile-time options. In that case, if a query has a WHERE clause that contains expressions like this: <blockquote> WHERE (expr1 OR expr2 OR ... OR exprN) AND column IS NOT NULL </blockquote> Where all of expr1 through exprN are suitable for use by indexes, then during query planning SQLite might mistakenly converted the "column IS NOT NULL" term into "column>NULL". But the latter term is never true, and so the query would return no rows. <p>The trouble ticket for this bug is [[http://www.sqlite.org/src/info/4c86b126f2|4c86b126f2]]. It is recommended that all users upgrade to avoid this problem. } newsitem {2014-02-03} {Release 3.8.3} { <p>SQLite [version 3.8.3] is a regularly scheduled maintenance release. Upgrading from the previous release is optional. <p>The most visible change in version 3.8.3 is the addition of support for [common table expressions]. It is now possible to write a |
︙ | ︙ |