Documentation Source Text

Check-in [f7fce883af]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Version 3.23.1
Timelines: family | ancestors | descendants | both | trunk | release | version-3.23.1
Files: files | file ages | folders
SHA3-256:f7fce883af218d2fcaed8c5a5056555e23ce5fac931314b0ad8a5f0c936da8c3
User & Date: drh 2018-04-10 17:44:52
Context
2018-04-10
18:26
Fix typos in the whynotgit.html document. check-in: 4b40ee5303 user: drh tags: trunk
17:44
Version 3.23.1 check-in: f7fce883af user: drh tags: trunk, release, version-3.23.1
17:09
Fix a typo in the whynotgit.html document. check-in: 44fe2354a1 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    17     17   proc chng {date desc {options {}}} {
    18     18     global nChng aChng xrefChng
    19     19     set aChng($nChng) [list $date $desc $options]
    20     20     set xrefChng($date) $nChng
    21     21     incr nChng
    22     22   }
    23     23   
    24         -chng {2018-04-11 (3.23.1)} {
           24  +chng {2018-04-10 (3.23.1)} {
    25     25   <li> Fix two problems in the new [LEFT JOIN strength reduction optimization].
    26     26        Tickets [https://sqlite.org/src/info/1e39b966ae9ee739|1e39b966ae9ee739]
    27     27        and [https://sqlite.org/src/info/1e39b966ae9ee739|1e39b966ae9ee739].
    28     28   <li> Fix misbehavior of the FTS5 xBestIndex method.  Ticket
    29     29        [https://sqlite.org/src/info/2b8aed9f7c9e61e8|2b8aed9f7c9e61e8].
    30     30   <li> Fix a harmless reference to an uninitialized virtual machine register.
    31     31        Ticket [https://sqlite.org/src/info/093420fc0eb7cba7|093420fc0eb7cba7].
................................................................................
    32     32   <li> Fix the [CLI] so that it builds with -DSQLITE_UNTESTABLE
    33     33   <li> Fix the [https://sqlite.org/src/file/ext/misc/eval.c|eval.c] extension
    34     34        so that it works with [PRAGMA empty_result_callbacks=ON].
    35     35   <li> Fix the [generate_series] virtual table so that it correctly returns
    36     36        no rows if any of its constraints are NULL.
    37     37   <li> Performance enhancements in the parser.
    38     38   <p><b>Hashes:</b>
    39         -<li>SQLITE_SOURCE_ID: <i>pending</i>
    40         -<li>SHA3-256 for sqlite3.c: <i>pending</i>
    41         -}
           39  +<li>SQLITE_SOURCE_ID: "2018-04-10 17:39:29 4bb2294022060e61de7da5c227a69ccd846ba330e31626ebcd59a94efd148b3b"
           40  +<li>SHA3-256 for sqlite3.c: 65750d1e506f416a0b0b9dd22d171379679c733e3460549754dc68c92705b5dc
           41  +} {patchagainst 1}
    42     42   
    43     43   chng {2018-04-02 (3.23.0)} {
    44     44   <li> Add the [sqlite3_serialize()] and [sqlite3_deserialize()] interfaces when
    45     45        the [SQLITE_ENABLE_DESERIALIZE] compile-time option is used.
    46     46   <li> Recognize TRUE and FALSE as constants.  (For compatibility, if there
    47     47        exist columns named "true" or "false", then the identifiers refer to the
    48     48        columns rather than Boolean constants.)

Changes to pages/chronology.in.

    24     24   #    ORDER BY mtime DESC;
    25     25   #
    26     26   # A small amount of manual editing and de-duplication followed.
    27     27   #
    28     28   # Manually edit the list for each subsequent release.
    29     29   #      
    30     30   foreach line [split {
    31         -xxxxxxxxxx|pending|Version 3.23.1
           31  +4bb2294022|2018-04-10|Version 3.23.1
    32     32   736b53f57f|2018-04-02|Version 3.23.0
    33     33   0c55d17973|2018-01-22|Version 3.22.0
    34     34   1a584e4999|2017-10-24|Version 3.21.0
    35     35   8d3a7ea6c5|2017-08-24|Version 3.20.1
    36     36   9501e22dfe|2017-08-01|Version 3.20.0
    37     37   036ebf729e|2017-06-17|Version 3.18.2
    38     38   77bb46233d|2017-06-16|Version 3.18.1

Changes to pages/news.in.

    14     14     hd_puts "<h3>$date - $title</h3>"
    15     15     regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
    16     16     regsub -all {[Tt]icket #(\d+)} $txt \
    17     17         {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
    18     18     hd_resolve "<blockquote>$txt</blockquote>"
    19     19     hd_puts "<hr width=\"50%\">"
    20     20   }
           21  +
           22  +newsitem {2018-04-10} {Release 3.23.1} {
           23  +The [version 3.23.1] release fixes a bug in the new
           24  +[LEFT JOIN strength reduction optimization] added to version 3.23.0.
           25  +A few other minor and obscure fixes were also inserted, as well as
           26  +a small performance optimization.  Code changes relative to
           27  +version 3.23.0 are minimal.
           28  +}
    21     29   
    22     30   newsitem {2018-04-02} {Release 3.23.0} {
    23     31   The [version 3.23.0] release is a regularly scheduled maintenance release.
    24     32   See the [version 3.23.0|change log] for a list of enhancements and bug
    25     33   fixes.
    26     34   }
    27     35