Documentation Source Text

Check-in [156259f9a6]
Login

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

Overview
Comment:Add mention of sqlite3changeset_apply() hardening to the change log.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 156259f9a6b5b7fffa159dcb4b6ff888e17cd5aa131fa38456ca9b9ceb5ef0c0
User & Date: drh 2018-03-28 15:11:13
Context
2018-03-28
15:54
A couple more minor changes in the change log. check-in: ac0b5884a5 user: drh tags: trunk
15:11
Add mention of sqlite3changeset_apply() hardening to the change log. check-in: 156259f9a6 user: drh tags: trunk
2018-03-27
12:51
Update the speed and size chart. check-in: e704c03dfe user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

34
35
36
37
38
39
40


41
42
43
44
45
46
47
     now causes string substitutions to measure the width and precision in
     characters instead of bytes.
<li> If the [xColumn] method in a [virtual table] implementation returns
     an error message using [sqlite3_result_error()] then give that error
     message preference over internally-generated messages.
<li> Added the -A command-line option to the [CLI] to make it easier to manage
     [SQLite Archive files].


<li> Query optimizer enhancements:
<ol type='a'>
  <li> Improve the [omit-left-join optimization] so that it works in cases where
       the right-hand table is UNIQUE but not necessarily NOT NULL.
  <li> Improve the [push-down optimization] so that it works for many LEFT JOINs.
  <li> Add the [LEFT JOIN strength reduction optimization] that converts a LEFT
       JOIN into an ordinary JOIN if there exist terms in the WHERE clause







>
>







34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
     now causes string substitutions to measure the width and precision in
     characters instead of bytes.
<li> If the [xColumn] method in a [virtual table] implementation returns
     an error message using [sqlite3_result_error()] then give that error
     message preference over internally-generated messages.
<li> Added the -A command-line option to the [CLI] to make it easier to manage
     [SQLite Archive files].
<li> Enhance the [sqlite3changeset_apply()] interface so that it is hardened
     against attacks from deliberately corrupted [changeset] objects.
<li> Query optimizer enhancements:
<ol type='a'>
  <li> Improve the [omit-left-join optimization] so that it works in cases where
       the right-hand table is UNIQUE but not necessarily NOT NULL.
  <li> Improve the [push-down optimization] so that it works for many LEFT JOINs.
  <li> Add the [LEFT JOIN strength reduction optimization] that converts a LEFT
       JOIN into an ordinary JOIN if there exist terms in the WHERE clause