Documentation Source Text: Check-in [21ae80926f]

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

Overview

Comment:	Changes for the 3.23.1 patch release.
Timelines:	family \| ancestors \| descendants \| both \| trunk
Files:	files \| file ages \| folders
SHA3-256:	21ae80926f3a9d0bad040be49d0c0d261fd9775fb538a4a8442747648f0c3794
User & Date:	drh 2018-04-10 12:36:04

Context

2018-04-10
13:48		Update the performance and size spreadsheet. Update the cpu.html page with the latest graph. check-in: 9e3acfbfab user: drh tags: trunk
12:36		Changes for the 3.23.1 patch release. check-in: 21ae80926f user: drh tags: trunk
01:09		Merge fixes from the 3.23.0 branch. check-in: 2ca5d3c1c4 user: drh tags: trunk

Changes

Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}




















chng {2018-04-02 (3.23.0)} {
<li> Add the [sqlite3_serialize()] and [sqlite3_deserialize()] interfaces when
     the [SQLITE_ENABLE_DESERIALIZE] compile-time option is used.
<li> Recognize TRUE and FALSE as constants.  (For compatibility, if there
     exist columns named "true" or "false", then the identifiers refer to the
     columns rather than Boolean constants.)








>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2018-04-11 (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/1e39b966ae9ee739|1e39b966ae9ee739].
<li> Fix misbehavior of the FTS5 xBestIndex method.  Ticket
     [https://sqlite.org/src/info/2b8aed9f7c9e61e8|2b8aed9f7c9e61e8].
<li> Fix a harmless reference to an uninitialized virtual machine register.
     Ticket [https://sqlite.org/src/info/093420fc0eb7cba7|093420fc0eb7cba7].
<li> Fix the [CLI] so that it builds with -DSQLITE_UNTESTABLE
<li> Fix the [https://sqlite.org/src/file/ext/misc/eval.c|eval.c] extension
     so that it works with [PRAGMA empty_result_callbacks=ON].
<li> Fix the [generate_series] virtual table so that it correctly returns
     no rows if any of its constraints are NULL.
<li> Performance enhancements in the parser.
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: <i>pending</i>
<li>SHA3-256 for sqlite3.c: <i>pending</i>
}

chng {2018-04-02 (3.23.0)} {
<li> Add the [sqlite3_serialize()] and [sqlite3_deserialize()] interfaces when
     the [SQLITE_ENABLE_DESERIALIZE] compile-time option is used.
<li> Recognize TRUE and FALSE as constants.  (For compatibility, if there
     exist columns named "true" or "false", then the identifiers refer to the
     columns rather than Boolean constants.)

Changes to pages/chronology.in.

#    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 {

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
77bb46233d|2017-06-16|Version 3.18.1

#    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 {
xxxxxxxxxx|pending|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
77bb46233d|2017-06-16|Version 3.18.1

Changes to pages/index.in.

[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:&nbsp;&nbsp;</span>
<a href="releaselog/3_23_0.html">Version 3.23.0</a> ([dateof:3.23.0]).
<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>

[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:&nbsp;&nbsp;</span>
<a href="releaselog/3_23_1.html">Version 3.23.1</a> ([dateof:3.23.1]).
<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>