Documentation Source Text

Check-in [6d211fe371]
Login

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

Overview
Comment:Updates to the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 6d211fe371cf7200fc4fc81f8a2d5bd3955eebcf0e702c5953f7eff706c07f5a
User & Date: drh 2018-04-25 00:02:23.195
Context
2018-04-30
22:27
Update the change log. Fix typo in virtual table documentation. (check-in: 32c5dad1b2 user: drh tags: trunk)
2018-04-25
00:02
Updates to the change log. (check-in: 6d211fe371 user: drh tags: trunk)
2018-04-20
00:00
Document the fact that UPSERTs count INSERT operations but not UPDATEs. (check-in: fcfd6e8be6 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
23
24
25
26
27
28
29




















30

31
32
33
34
35
36
37

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







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

>







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

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.
<li> The [CLI] automatically intercepts the raw [EXPLAIN QUERY PLAN] 
     output an reformats it into an ASCII-art graph.
<li> Enhance the query planner to allow the [OR optimization] to proceed
     even if the OR expression has also been converted into an IN
     expression.
<li> Performance improvements in the LEMON-generated parser.
<p><b>Bug fixes:</b>
<li> For the right-hand table of a LEFT JOIN, compute the values
     of expressions directly rather than loading precomputed values
     out of an [expression index] as the expression index might
     not contain the correct value.  Ticket
     [https://sqlite.org/src/info/7fa8049685b50b5aeb0c2|7fa8049685b50b5aeb0c2]
<li> Do not attempt to use terms from the WHERE clause to enable
     indexed lookup of the right-hand table of a LEFT JOIN.  Ticket
     [https://sqlite.org/src/info/4ba5abf65c5b0f9a96a7a|4ba5abf65c5b0f9a96a7a]
<li> Fix a memory leak that can occur following a failure to open error
     in the [CSV virtual table]
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: <i>pending</i>
<li>SHA3-256 for sqlite3.c: <i>pending</i>
}


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