Documentation Source Text

Check-in [9ae6f97cab]
Login

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

Overview
Comment:Version 3.19.0
Timelines: family | ancestors | descendants | both | trunk | release | version-3.19.0
Files: files | file ages | folders
SHA3-256: 9ae6f97cabf46394303977ac1d4fe601881784f06dd455a45978704eba7bad47
User & Date: drh 2017-05-22 14:02:27
Context
2017-05-22
19:23
Add a chart of raw data to the faster-than-filesystem page. check-in: 5f95a7df66 user: drh tags: trunk
14:02
Version 3.19.0 check-in: 9ae6f97cab user: drh tags: trunk, release, version-3.19.0
13:49
Fix typos in the opcodes.html document. check-in: d11890e573 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
..
64
65
66
67
68
69
70



71
72
73
74
75
76
77
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> The [SQLITE_READ] [authorizer callback] is invoked once
     with a column name that is an empty string
     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
................................................................................
<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
     [https://www.sqlite.org/src/info/6c9b5514077fed34551|6c9b5514077fed34551].
<li> Limit the depth of recursion for JSON objects and arrays in order to avoid
     excess stack usage in the recursive descent parser.  Fix for ticket
     [https://www.sqlite.org/src/info/981329adeef51011052|981329adeef51011052].



}

chng {2017-03-30 (3.18.0)} {
<li>Added the [PRAGMA optimize] command
<li>The SQLite version identifier returned by the [sqlite_source_id()] SQL function
    and the [sqlite3_sourceid()] C API and found in the [SQLITE_SOURCE_ID] macro is
    now a 64-digit SHA3-256 hash instead of a 40-digit SHA1 hash.







|







 







>
>
>







17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
..
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
proc chng {date desc {options {}}} {
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2017-05-22 (3.19.0)} {
<li> The [SQLITE_READ] [authorizer callback] is invoked once
     with a column name that is an empty string
     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
................................................................................
<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
     [https://www.sqlite.org/src/info/6c9b5514077fed34551|6c9b5514077fed34551].
<li> Limit the depth of recursion for JSON objects and arrays in order to avoid
     excess stack usage in the recursive descent parser.  Fix for ticket
     [https://www.sqlite.org/src/info/981329adeef51011052|981329adeef51011052].
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: "2017-05-22 13:58:13 28a94eb282822cad1d1420f2dad6bf65e4b8b9062eda4a0b9ee8270b2c608e40"
<li>SHA3-256 for sqlite3.c: c30326aa1a9cc342061b755725eac9270109acf878bc59200dd4b1cea6bc2908
}

chng {2017-03-30 (3.18.0)} {
<li>Added the [PRAGMA optimize] command
<li>The SQLite version identifier returned by the [sqlite_source_id()] SQL function
    and the [sqlite3_sourceid()] C API and found in the [SQLITE_SOURCE_ID] macro is
    now a 64-digit SHA3-256 hash instead of a 40-digit SHA1 hash.

Changes to pages/chronology.in.

24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
#    ORDER BY mtime DESC;
#
# A small amount of manual editing and de-duplication followed.
#
# Manually edit the list for each subsequent release.
#      
foreach line [split {
xxxxxxxxxx|(pending)|version 3.19.0
424a0d3803|2017-03-28|version 3.18.0
ada05cfa86|2017-02-13|version 3.17.0
a65a62893c|2017-01-06|version 3.16.2
979f043928|2017-01-03|Version 3.16.1
04ac0b75b1|2017-01-02|Version 3.16.0
bbd85d235f|2016-11-28|Version 3.15.2
1136863c76|2016-11-04|Version 3.15.1







|







24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
#    ORDER BY mtime DESC;
#
# A small amount of manual editing and de-duplication followed.
#
# Manually edit the list for each subsequent release.
#      
foreach line [split {
28a94eb282|2017-05-22|version 3.19.0
424a0d3803|2017-03-28|version 3.18.0
ada05cfa86|2017-02-13|version 3.17.0
a65a62893c|2017-01-06|version 3.16.2
979f043928|2017-01-03|Version 3.16.1
04ac0b75b1|2017-01-02|Version 3.16.0
bbd85d235f|2016-11-28|Version 3.15.2
1136863c76|2016-11-04|Version 3.15.1

Changes to pages/news.in.

14
15
16
17
18
19
20








21
22
23
24
25
26
27
  hd_puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  regsub -all {[Tt]icket #(\d+)} $txt \
      {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
  hd_resolve "<blockquote>$txt</blockquote>"
  hd_puts "<hr width=\"50%\">"
}









newsitem {2017-03-30} {Release 3.18.0} {
SQLite [version 3.18.0] is a regularly scheduled maintenance release.
<p>
This release features an initial implementation the 
"[PRAGMA optimize]" command.  This command can now be used to cause
[ANALYZE] to be run on an as-needed basis.  Applications should invoke







>
>
>
>
>
>
>
>







14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
  hd_puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  regsub -all {[Tt]icket #(\d+)} $txt \
      {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
  hd_resolve "<blockquote>$txt</blockquote>"
  hd_puts "<hr width=\"50%\">"
}

newsitem {2017-05-22} {Release 3.19.0} {
SQLite [version 3.19.0] is a regularly scheduled maintenance release.
<p>
The emphasis on this release is improvements to the query planner.
There are also some obscure bug fixes.  There is no reason to upgrade
unless you are having problems with a prior release.
}

newsitem {2017-03-30} {Release 3.18.0} {
SQLite [version 3.18.0] is a regularly scheduled maintenance release.
<p>
This release features an initial implementation the 
"[PRAGMA optimize]" command.  This command can now be used to cause
[ANALYZE] to be run on an as-needed basis.  Applications should invoke