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: |
6d211fe371cf7200fc4fc81f8a2d5bd3 |
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
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]. |
︙ | ︙ |