Documentation Source Text

Check-in [45bd3cdd39]
Login

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

Overview
Comment:Create a change log entry for 3.23.0.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 45bd3cdd391b50d05803acd037c8210ff7bb8d4b4485784809054140db63e0fd
User & Date: drh 2018-02-27 16:36:39.962
Context
2018-02-27
21:29
Add documentation on althttpd. (check-in: d9cb224c9f user: drh tags: trunk)
16:36
Create a change log entry for 3.23.0. (check-in: 45bd3cdd39 user: drh tags: trunk)
2018-02-25
19:24
Be sure to ParseRfc822Date() has enough precision in its output. (check-in: 3fed9a6fc9 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
16
17
18
19
20
21
22





















































23
24
25
26
27
28
29
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-01-22 (3.22.0)} {
<li> The output of [sqlite3_trace_v2()] now shows each individual SQL statement
     run within a trigger.
<li> Add the ability to read from [WAL mode] databases even if the application 
     lacks write permission on the database and its containing directory, as long as
     the -shm and -wal files exist in that directory.







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







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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
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-00-00 (3.23.0)} {
<li> Recognize TRUE and FALSE as constants.  (For compatibility, if there
     are columns named "true" or "false", then the identifiers refer to the
     columns rather than Boolean constants.)
<li> Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE.
<li> Improve the omit-left-join optimization so that it works in cases where
     the right-hand table is UNIQUE but not necessarily NOT NULL.
<li> The "alternate-form-2" flag ("!") on the [built-in printf] implemention
     now causes string substitutions to measure the width and precision in
     characters instead of bytes.
<li> If the [xColumn] method in a [virtual table] implementation returns
     an error message using [sqlite3_result_error()] then give that error
     message preference over internally-generated messages.
<li> Bug fixes:
<ol type='a'>
  <li> Fix the parser to acceept valid [row value] syntax.
       Ticket [https://www.sqlite.org/src/info/7310e2fb3d046a5|7310e2fb3d046a5]
  <li> Fix the query planner so that it takes into account dependencies in
       the arguments to table-valued functions in subexpressions in 
       the WHERE clause.
       Ticket [https://www.sqlite.org/src/info/80177f0c226ff54|80177f0c226ff54]
  <li> Fix incorrect result with complex OR-connected WHERE and STAT4.
       Ticket [https://www.sqlite.org/src/info/ec32177c99ccac2|ec32177c99ccac2]
  <li> Fix potential corruption in [indexes on expressions] due to automatic
       datatype conversions.
       Ticket [https://www.sqlite.org/src/info/343634942dd54ab|343634942dd54ab]
  <li> Assertion fault in FTS4.
       Ticket [https://www.sqlite.org/src/info/d6ec09eccf68cfc|d6ec09eccf68cfc]
  <li> Incorrect result on the less-than operator in [row values].
       Ticket [https://www.sqlite.org/src/info/f484b65f3d62305|f484b65f3d62305]
  <li> Always interpret non-zero floating-point values as TRUE, even if
       the integer part is zero.
       Ticket [https://www.sqlite.org/src/info/36fae083b450e3a|36fae083b450e3a]
</ol>
<li> Additional fixes for issues detected by
     [https://github.com/google/oss-fuzz|OSSFuzz]:
<ol type='a'>
  <li> Fix a possible infinite loop on VACUUM for corrupt database files.
       Check-in [https://www.sqlite.org/src/info/27754b74ddf64|27754b74ddf64]
  <li> Disallow [parameters] in the [WITH clause] of triggers and views.
       Check-in [https://www.sqlite.org/src/info/b918d4b4e546d|b918d4b4e546d]
  <li> Fix a potential memory leak in [row value] processing.
       Check-in [https://www.sqlite.org/src/info/2df6bbf1b8ca8|2df6bbf1b8ca8]
  <li> Improve the performance of the [replace() SQL function] for cases where
       there are many substitutions on megabyte-sized strings, in an attempt
       to avoid OSSFuzz timeouts during testing.
       Check-in [https://www.sqlite.org/src/info/fab2c2b07b5d3|fab2c2b07b5d3]
</ol>
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: <i>pending</i>
<li>SHA3-256 for sqlite3.c: <i>pending</i>
}

chng {2018-01-22 (3.22.0)} {
<li> The output of [sqlite3_trace_v2()] now shows each individual SQL statement
     run within a trigger.
<li> Add the ability to read from [WAL mode] databases even if the application 
     lacks write permission on the database and its containing directory, as long as
     the -shm and -wal files exist in that directory.
Changes to pages/chronology.in.
24
25
26
27
28
29
30

31
32
33
34
35
36
37
#    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 {

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
0ee482a1e0|2017-06-08|Version 3.19.3







>







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.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
0ee482a1e0|2017-06-08|Version 3.19.3
Changes to pages/index.in.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
[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_22_0.html">Version 3.22.0</a> ([dateof:3.22.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>







|







10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
[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>