Documentation Source Text

Check-in [1f4c6d050e]
Login

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

Overview
Comment:Start the change log for 3.24.0
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 1f4c6d050e2debd1ef4b5116a8eef0731532862008ef7968887db2389d7c3fde
User & Date: drh 2018-04-19 10:24:29.568
Context
2018-04-19
13:28
Preliminary documentation for upsert. (check-in: 74564b6da7 user: drh tags: trunk)
10:24
Start the change log for 3.24.0 (check-in: 1f4c6d050e user: drh tags: trunk)
2018-04-14
18:49
Fix incorrect hyperlink to xkcd in the whynotgit.html document. (check-in: ee9866f9cc user: drh tags: trunk)
Changes
Side-by-Side Diff Ignore Whitespace Patch
Changes to pages/changes.in.
16
17
18
19
20
21
22








23
24
25
26
27
28
29
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37







+
+
+
+
+
+
+
+







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-07-00 (3.24.0)} {
<li> Add support for PostgreSQL-style UPSERT.
<li> Enhance [ALTER TABLE] so that it recognizes "true" and "false" as
     valid arguments to DEFAULT.
<li> Added the sorter-reference optimization as a compile-time option.
     Only available if compiled with SQLITE_ENABLE_SORTER_REFERENCES.
}

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/fac496b61722daf2|fac496b61722daf2].
<li> Fix misbehavior of the FTS5 xBestIndex method.  Ticket
     [https://sqlite.org/src/info/2b8aed9f7c9e61e8|2b8aed9f7c9e61e8].
Changes to pages/chronology.in.
24
25
26
27
28
29
30

31
32
33
34
35
36
37
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 {
0000000000|pending|Version 3.24.0
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
Changes to pages/index.in.
10
11
12
13
14
15
16
17

18
19
20
21
22
23
24
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_1.html">Version 3.23.1</a> ([dateof:3.23.1]).
<a href="releaselog/3_24_0.html">Version 3.24.0</a> ([dateof:3.24.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>