Documentation Source Text

Check-in [03fde5ae27]
Login

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

Overview
Comment:Update the change log and the speed-and-size graph.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 03fde5ae272314a947e5f3e2eccfd307336ec19850c0bcec50943c0a0cdc0d03
User & Date: drh 2017-05-02 18:46:38.306
Context
2017-05-04
19:44
Add the "35% Faster Than The Filesystem" document. (check-in: fd906f77ce user: drh tags: trunk)
2017-05-02
18:46
Update the change log and the speed-and-size graph. (check-in: 03fde5ae27 user: drh tags: trunk)
01:31
Fix typo. (check-in: f230c5ce7d user: mistachkin tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to misc/speed-size-graph.ods.

cannot compute difference between binary files

Changes to pages/changes.in.
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38






39



40
41
42
43
44
45
46
proc chng {date desc {options {}}} {
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2017-00-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].
<li> Avoid unnecessary foreign key processing in UPDATE statements that do not
     touch the columns that are constrained by the foreign keys.
<li> On a DISTINCT query that uses an index, try to skip ahead to the next distinct
     entry using the index rather that stepping through rows, when an appropriate
     index is available.
<li> Avoid unnecessary invalidation of [sqlite3_blob] handles when making
     changes to unrelated tables.






<p><b>Bug Fixes:</b>



<li> Fix a problem in [PRAGMA integrity_check] that was causing a subsequent
     [VACUUM] to behave suboptimally.
<li> Fix the [PRAGMA foreign_key_check] command so that it works correctly with
     foreign keys on [WITHOUT ROWID] tables.
<li> Disallow leading zeros in numeric constants in JSON.  Fix for ticket
     [https://www.sqlite.org/src/info/b93be8729a895a528e2|b93be8729a895a528e2].
<li> Disallow control characters inside of strings in JSON.  Fix for ticket







|














>
>
>
>
>
>

>
>
>







17
18
19
20
21
22
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
proc chng {date desc {options {}}} {
  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].
<li> Avoid unnecessary foreign key processing in UPDATE statements that do not
     touch the columns that are constrained by the foreign keys.
<li> On a DISTINCT query that uses an index, try to skip ahead to the next distinct
     entry using the index rather that stepping through rows, when an appropriate
     index is available.
<li> Avoid unnecessary invalidation of [sqlite3_blob] handles when making
     changes to unrelated tables.
<li> Transfer any terms of the HAVING clause that use only columns mentioned in
     the GROUP BY clause over to the WHERE clause for faster processing.
<li> Reuse the same materialization of a VIEW if that VIEW appears more then
     once in the same query.
<li> Enhance [PRAGMA integrity_check] so that it identifies tables that have two
     or more rows with the same [rowid].
<p><b>Bug Fixes:</b>
<li> Fix a problem in [REPLACE] that can result in a corrupt database containing
     two ore more rows with the same [rowid].  Fix for ticket
     [https://www.sqlite.org/src/info/f68dc596c4e6018d|f68dc596c4e6018d].
<li> Fix a problem in [PRAGMA integrity_check] that was causing a subsequent
     [VACUUM] to behave suboptimally.
<li> Fix the [PRAGMA foreign_key_check] command so that it works correctly with
     foreign keys on [WITHOUT ROWID] tables.
<li> Disallow leading zeros in numeric constants in JSON.  Fix for ticket
     [https://www.sqlite.org/src/info/b93be8729a895a528e2|b93be8729a895a528e2].
<li> Disallow control characters inside of strings in JSON.  Fix for ticket