Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Mention the column-name fix in the change log for 3.20.0. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
86057a37ce84d421d0618905c37ac6cc |
| User & Date: | drh 2017-07-31 20:19:02.021 |
Context
|
2017-07-31
| ||
| 20:31 | Enhance the change log to use ordered-lists rather than unnumber-lists to make it easier for people to refer to a specific item in the change log. Also fixed a minor typo on item 7 of the current change log. (check-in: bfd46de16b user: drh tags: trunk) | |
| 20:19 | Mention the column-name fix in the change log for 3.20.0. (check-in: 86057a37ce user: drh tags: trunk) | |
| 14:16 | Enhance the chronology.html page so that the table columns are sortable. (check-in: d3fa7ece9a user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
| ︙ | ︙ | |||
94 95 96 97 98 99 100 101 102 103 104 105 106 107 |
the number of bytes of metadata on btree pages.
<li> The [SQLITE_DBCONFIG_ENABLE_QPSG] run-time option and the
[SQLITE_ENABLE_QPSG] compile-time option enable the
[query planner stability guarantee]. See also ticket
[https://www.sqlite.org/src/info/892fc34f173e99d8|892fc34f173e99d8]
<li> Miscellaneous optimizations result in a 2% reduction in [CPU cycles used].
<p><b>Bug Fixes:</b>
<li> Fix the query planner so that it knows not to use [automatic indexes]
on the right table of LEFT JOIN if the WHERE clause uses the [IS operator].
Fix for [https://sqlite.org/src/info/ce68383bf6aba|ce68383bf6aba].
<li> Ensure that the query planner knows that any column of a
[flattening optimization|flattened] LEFT JOIN can be NULL even
if that column is labeled with "NOT NULL". Fix for ticket
[https://sqlite.org/src/info/892fc34f173e99d8|892fc34f173e99d8].
| > > > > | 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 |
the number of bytes of metadata on btree pages.
<li> The [SQLITE_DBCONFIG_ENABLE_QPSG] run-time option and the
[SQLITE_ENABLE_QPSG] compile-time option enable the
[query planner stability guarantee]. See also ticket
[https://www.sqlite.org/src/info/892fc34f173e99d8|892fc34f173e99d8]
<li> Miscellaneous optimizations result in a 2% reduction in [CPU cycles used].
<p><b>Bug Fixes:</b>
<li> Fix the behavior of [sqlite3_column_name()] for queries that use the
[flattening optimization] so that the result is consistent with other
queries that do not use that optimization, and with PostgreSQL, MySQL,
and SQLServer. Ticket [https://sqlite.org/src/info/de3403bf5ae|de3403bf5ae].
<li> Fix the query planner so that it knows not to use [automatic indexes]
on the right table of LEFT JOIN if the WHERE clause uses the [IS operator].
Fix for [https://sqlite.org/src/info/ce68383bf6aba|ce68383bf6aba].
<li> Ensure that the query planner knows that any column of a
[flattening optimization|flattened] LEFT JOIN can be NULL even
if that column is labeled with "NOT NULL". Fix for ticket
[https://sqlite.org/src/info/892fc34f173e99d8|892fc34f173e99d8].
|
| ︙ | ︙ |