Documentation Source Text

Check-in [84e21ebf22]
Login

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

Overview
Comment:Add the SQLITE_READ authorizer change to the change log for 3.19.0.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 84e21ebf2285f3fb6b1474941bd4ab28b4671abc4ca8b9f45dac39a557e904ae
User & Date: drh 2017-05-10 16:34:10.011
Context
2017-05-10
16:38
Minor wording tweaks to the 35%-faster document. (check-in: a1177bfca0 user: drh tags: trunk)
16:34
Add the SQLITE_READ authorizer change to the change log for 3.19.0. (check-in: 84e21ebf22 user: drh tags: trunk)
2017-05-05
16:55
Updates to the 35% faster document. (check-in: ac27ab7f6f user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
18
19
20
21
22
23
24


25
26
27
28
29
30
31
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2017-06-00 (3.19.0)} {


<li> When using an index on an expression, try to use expression values already
     available in the index, rather than loading the original columns and recomputing
     the expression.
<li> Enhance the [flattening optimization] so that it is able to flatten views
     on the right-hand side of a LEFT JOIN.
<li> Use [replace()] instead of [char()] for escaping newline and carriage-return
     characters embedded in strings in the .dump output from the [command-line shell].







>
>







18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2017-06-00 (3.19.0)} {
<li> The [SQLITE_READ] [authorizer callback] is invoked with a NULL column name
     for every table referenced in a query from which no columns are extracted.
<li> When using an index on an expression, try to use expression values already
     available in the index, rather than loading the original columns and recomputing
     the expression.
<li> Enhance the [flattening optimization] so that it is able to flatten views
     on the right-hand side of a LEFT JOIN.
<li> Use [replace()] instead of [char()] for escaping newline and carriage-return
     characters embedded in strings in the .dump output from the [command-line shell].