Documentation Source Text

Check-in [f7fce883af]
Login

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

Overview
Comment:Version 3.23.1
Downloads: Tarball | ZIP archive
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.555
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
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
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
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.)







|














|
|
|







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
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-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/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: "2018-04-10 17:39:29 4bb2294022060e61de7da5c227a69ccd846ba330e31626ebcd59a94efd148b3b"
<li>SHA3-256 for sqlite3.c: 65750d1e506f416a0b0b9dd22d171379679c733e3460549754dc68c92705b5dc
} {patchagainst 1}

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







|







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 {
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
77bb46233d|2017-06-16|Version 3.18.1
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-04-02} {Release 3.23.0} {
The [version 3.23.0] release is a regularly scheduled maintenance release.
See the [version 3.23.0|change log] for a list of enhancements and bug
fixes.
}








>
>
>
>
>
>
>
>







14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
  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-04-10} {Release 3.23.1} {
The [version 3.23.1] release fixes a bug in the new
[LEFT JOIN strength reduction optimization] added to version 3.23.0.
A few other minor and obscure fixes were also inserted, as well as
a small performance optimization.  Code changes relative to
version 3.23.0 are minimal.
}

newsitem {2018-04-02} {Release 3.23.0} {
The [version 3.23.0] release is a regularly scheduled maintenance release.
See the [version 3.23.0|change log] for a list of enhancements and bug
fixes.
}