Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Updates to the change log. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
6d211fe371cf7200fc4fc81f8a2d5bd3 |
| User & Date: | drh 2018-04-25 00:02:23 |
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
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].
|