Documentation Source Text

Check-in [4604e54aca]
Login

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

Overview
Comment:Version 3.27.2
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk | release | version-3.27.2
Files: files | file ages | folders
SHA3-256: 4604e54acae9ee880d1c310dda11508565bea70c95b5d423552b074ad9caec9e
User & Date: drh 2019-02-25 16:10:42.403
Context
2019-02-25
16:46
Add a news item for the 3.27.2 release. (check-in: f52168899f user: drh tags: trunk)
16:10
Version 3.27.2 (check-in: 4604e54aca user: drh tags: trunk, release, version-3.27.2)
2019-02-18
20:35
Fix typos in the fileformat2.html page. (check-in: eecca5ae5e 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
proc chng {date desc {options {}}} {
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}













chng {2019-02-08 (3.27.1)} {
<li> Fix a bug in the query optimizer: an adverse interaction between
the [OR optimization] and the optimization that tries to use values
read directly from an [expression index] instead of recomputing the
expression.
Ticket [https://www.sqlite.org/src/info/4e8e4857d32d401f|4e8e4857d32d401f]
<p><b>Hashes:</b>







>
>
>
>
>
>
>
>
>
>
>
>







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
proc chng {date desc {options {}}} {
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2019-02-25 (3.27.2)} {
<li> Fix a bug in the IN operator that was introduced by an 
     attempted optimization in version 3.27.0. Ticket
     [https://www.sqlite.org/src/info/df46dfb631f75694|df46dfb631f75694]
<li> Fix a bug causing a crash when a [window function] is misused.  Ticket
     [https://www.sqlite.org/src/info/4feb3159c6bc3f7e33959|4feb3159c6bc3f7e33959].
<li> Fix various documentation typos
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: bd49a8271d650fa89e446b42e513b595a717b9212c91dd384aab871fc1d0f6d7
<li>SHA3-256 for sqlite3.c: 1dbae33bff261f979d0042338f72c9e734b11a80720fb32498bae9150cc576e7
} {patchagainst 1 patchagainst 2}

chng {2019-02-08 (3.27.1)} {
<li> Fix a bug in the query optimizer: an adverse interaction between
the [OR optimization] and the optimization that tries to use values
read directly from an [expression index] instead of recomputing the
expression.
Ticket [https://www.sqlite.org/src/info/4e8e4857d32d401f|4e8e4857d32d401f]
<p><b>Hashes:</b>
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 {

0eca3dd3d3|2019-02-08|Version 3.27.1
97744701c3|2019-02-07|Version 3.27.0
bf8c1b2b7a|2018-12-01|Version 3.26.0
89e099fbe5|2018-11-05|Version 3.25.3
fb90e7189a|2018-09-25|Version 3.25.2
2ac9003de4|2018-09-18|Version 3.25.1
b63af6c3bd|2018-09-15|Version 3.25.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 {
bd49a8271d|2019-02-25|Version 3.27.2
0eca3dd3d3|2019-02-08|Version 3.27.1
97744701c3|2019-02-07|Version 3.27.0
bf8c1b2b7a|2018-12-01|Version 3.26.0
89e099fbe5|2018-11-05|Version 3.25.3
fb90e7189a|2018-09-25|Version 3.25.2
2ac9003de4|2018-09-18|Version 3.25.1
b63af6c3bd|2018-09-15|Version 3.25.0
Changes to pages/index.in.
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

<p>
SQLite [https://sqlite.org/src|source code]
is in the [public-domain] and is free to 
everyone to use for any purpose.

<h3>Latest Release</h3>
<a href="releaselog/3_27_1.html">Version 3.27.1</a> ([dateof:3.27.1]).
<a class="button" href="download.html">Download</a>
<a class="button" href="chronology.html">Prior Releases</a>

<div class="mobileonly">
<h3>Common Links</h3>
<tcl>common_links</tcl>
</div>







|







38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

<p>
SQLite [https://sqlite.org/src|source code]
is in the [public-domain] and is free to 
everyone to use for any purpose.

<h3>Latest Release</h3>
<a href="releaselog/3_27_2.html">Version 3.27.2</a> ([dateof:3.27.2]).
<a class="button" href="download.html">Download</a>
<a class="button" href="chronology.html">Prior Releases</a>

<div class="mobileonly">
<h3>Common Links</h3>
<tcl>common_links</tcl>
</div>