Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Change log updates due to review of sqlite3.c diffs from prior release. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
4a562f8d21958e3ca2f61db0eb32c90a |
| User & Date: | drh 2018-05-29 15:55:30 |
Context
|
2018-05-29
| ||
| 18:35 | Document (with links) that SQLite is a LoC Recommended Storage Format. (check-in: 2ab12e598f user: drh tags: trunk) | |
| 15:55 | Change log updates due to review of sqlite3.c diffs from prior release. (check-in: 4a562f8d21 user: drh tags: trunk) | |
|
2018-05-26
| ||
| 01:59 | Show the apSqlParam field that was added to the sqlite3_rtree_query_info object in version 3.8.11. (check-in: b5582fa868 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
58
59
60
61
62
63
64
65
66
67
68
69
70
71
..
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
<li> The [OR optimization] is allowed to proceed
even if the OR expression has also been converted into an IN
expression. Uses of the OR optimization are now also
[eqp-or-opt|more clearly shown] in the [EXPLAIN QUERY PLAN] output.
<li> The query planner is more aggressive about using
[automatic indexes] for views and subqueries for which it is
not possible to create a persistent index.
<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]
................................................................................
[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]
<li> Fix a long-standing problem wherein a corrupt schema on the
[sqlite_sequence] table used by [AUTOINCREMENT] can lead to
a crash. Ticket
[https://www.sqlite.org/src/info/d8dc2b3a58cd5dc29|d8dc2b3a58cd5dc2918a1]
<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)} {
|
>
>
>
>
>
|
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
..
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
<li> The [OR optimization] is allowed to proceed
even if the OR expression has also been converted into an IN
expression. Uses of the OR optimization are now also
[eqp-or-opt|more clearly shown] in the [EXPLAIN QUERY PLAN] output.
<li> The query planner is more aggressive about using
[automatic indexes] for views and subqueries for which it is
not possible to create a persistent index.
<li> Make use of the one-pass UPDATE and DELETE query plans in the
[R-Tree extension] where appropriate.
<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]
................................................................................
[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]
<li> Fix a long-standing problem wherein a corrupt schema on the
[sqlite_sequence] table used by [AUTOINCREMENT] can lead to
a crash. Ticket
[https://www.sqlite.org/src/info/d8dc2b3a58cd5dc29|d8dc2b3a58cd5dc2918a1]
<li> Fix the [json_each()] function so that it returns
valid results on its "fullkey" column when the input is a simple value
rather than an array or object.
<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)} {
|