Documentation Source Text

Check-in [4a29b53e40]
Login

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

Overview
Comment:Preliminary changes for the 3.19.3 release.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 4a29b53e40d19669822d61b0ed0643769ea3acb562178b9e6fe807248d9be37b
User & Date: drh 2017-06-08 12:46:31.742
Context
2017-06-08
14:34
Version 3.19.3 (check-in: 9a562cf207 user: drh tags: trunk, release, version-3.19.3)
12:46
Preliminary changes for the 3.19.3 release. (check-in: 4a29b53e40 user: drh tags: trunk)
00:28
Flag the faster-than-filesystem report as "under development" (check-in: 029e600ba4 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
︙︙
16
17
18
19
20
21
22






23
24
25
26
27
28
29

set nChng 0
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-25 (3.19.2)} {
<li>Fix more bugs in the LEFT JOIN [flattening optimization]. Ticket
    [https://www.sqlite.org/src/info/7fde638e94287d2c|7fde638e94287d2c].
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: "2017-05-25 16:50:27 edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9"
<li>SHA3-256 for sqlite3.c: 1be0c457869c1f7eba58c3b5097b9ec307a15be338308bee8e5be8570bcf5d1e








>
>
>
>
>
>








16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

set nChng 0
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-08 (3.19.3)} {
<li>Fix a bug associated with [auto_vacuum] that can lead to database
    corruption.  The bug was introduced in [version 3.16.0] ([dateof:3.16.0]).
    Ticket [https://sqlite.org/src/info/fda22108|fda22108].
}

chng {2017-05-25 (3.19.2)} {
<li>Fix more bugs in the LEFT JOIN [flattening optimization]. Ticket
    [https://www.sqlite.org/src/info/7fde638e94287d2c|7fde638e94287d2c].
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: "2017-05-25 16:50:27 edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9"
<li>SHA3-256 for sqlite3.c: 1be0c457869c1f7eba58c3b5097b9ec307a15be338308bee8e5be8570bcf5d1e
︙︙
Changes to pages/chronology.in.
︙︙
24
25
26
27
28
29
30

31
32
33
34
35
36
37

#    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 {

edb4e819b0|2017-05-25|version 3.19.2
f6d7b988f4|2017-05-24|version 3.19.1
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








>








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|2017-06-08|version 3.19.3
edb4e819b0|2017-05-25|version 3.19.2
f6d7b988f4|2017-05-24|version 3.19.1
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
︙︙
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-05-25} {Release 3.19.2} {
Still more problems have been found in the LEFT JOIN
[https://sqlite.org/optoverview.html#flattening|flattening] optimization
that was added in the 3.19.0 release.  This patch release fixes all known
issues with that optimization and adds new test cases.  Hopefully this
will be the last patch.








>
>
>
>
>
>
>
>
>
>








14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37

  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-06-08} {Release 3.19.3} {
[Version 3.19.3] is an emergency patch release to fix a 
[https://sqlite.org/src/info/fda22108|bug] in 
[auto_vacuum] logic that can lead to database corruption.
The bug was introduced in [version 3.16.0] 
([dateof:3.16.0]).  Though the bug is obscure and rarely
encountered, upgrading is recommended for all users, and
especially for users who turn on [auto_vacuum].
}

newsitem {2017-05-25} {Release 3.19.2} {
Still more problems have been found in the LEFT JOIN
[https://sqlite.org/optoverview.html#flattening|flattening] optimization
that was added in the 3.19.0 release.  This patch release fixes all known
issues with that optimization and adds new test cases.  Hopefully this
will be the last patch.
︙︙