Documentation Source Text

Check-in [27e87090c9]
Login

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

Overview
Comment:Version 3.19.2
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk | release | version-3.19.2
Files: files | file ages | folders
SHA3-256: 27e87090c924e7c01bb1ab0e5d0cf008ab5e991941abdf8ff465e52adbfb96e5
User & Date: drh 2017-05-25 16:56:02.718
Context
2017-06-02
11:24
Remove an incorrect statement about sessions and WITHOUT ROWID from the WITHOUT ROWID documentation. (check-in: 65df8fdcfa user: drh tags: trunk)
2017-05-25
16:56
Version 3.19.2 (check-in: 27e87090c9 user: drh tags: trunk, release, version-3.19.2)
00:40
Initial changes for the 3.19.2 release. (check-in: 21ff2eb546 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
︙︙
17
18
19
20
21
22
23
24
25
26



27
28
29
30
31
32
33

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-26 (3.19.2)} {
<li>Fix more bugs in the LEFT JOIN [flattening optimization]. Ticket
    [https://www.sqlite.org/src/info/7fde638e94287d2c|7fde638e94287d2c].



} {patchagainst 1 patchagainst 2}

chng {2017-05-24 (3.19.1)} {
<li>Fix a bug in the LEFT JOIN [flattening optimization]. Ticket
    [https://www.sqlite.org/src/info/cad1ab4cb7b0fc|cad1ab4cb7b0fc].
<li>Remove a surplus semicolon that was causing problems for older versions of MSVC.
<p><b>Hashes:</b>








|


>
>
>








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

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
} {patchagainst 1 patchagainst 2}

chng {2017-05-24 (3.19.1)} {
<li>Fix a bug in the LEFT JOIN [flattening optimization]. Ticket
    [https://www.sqlite.org/src/info/cad1ab4cb7b0fc|cad1ab4cb7b0fc].
<li>Remove a surplus semicolon that was causing problems for older versions of MSVC.
<p><b>Hashes:</b>
︙︙
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.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
04ac0b75b1|2017-01-02|Version 3.16.0








|








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 {
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
04ac0b75b1|2017-01-02|Version 3.16.0
︙︙
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-24} {Release 3.19.1} {
One of the new query planner optimizations in the 3.19.0 release contained
bugs.  The 3.19.1 patch release fixes them.
<p>
Beginning with 3.19.0, subqueries and views on the right-hand side of
a LEFT JOIN operator could sometimes be








>
>
>
>
>
>
>
>








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-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.
}

newsitem {2017-05-24} {Release 3.19.1} {
One of the new query planner optimizations in the 3.19.0 release contained
bugs.  The 3.19.1 patch release fixes them.
<p>
Beginning with 3.19.0, subqueries and views on the right-hand side of
a LEFT JOIN operator could sometimes be
︙︙