Documentation Source Text

Check-in [287ea23516]
Login

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

Overview
Comment:Changes for version 3.27.1.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 287ea235163f521e4c58c74bf16d0b564afa073cd9eeaa73ccfa246cb1bb25d0
User & Date: drh 2019-02-08 13:04:21.021
Context
2019-02-08
13:22
Version 3.27.1 (check-in: 65b2939d78 user: drh tags: trunk, release, version-3.27.1)
13:04
Changes for version 3.27.1. (check-in: 287ea23516 user: drh tags: trunk)
2019-02-07
18:10
Fix the chronology entry for 3.27.0. (check-in: 79e69bbf6e 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 {2019-02-07 (3.27.0)} {
<li>Added the [VACUUM INTO] command
<li>Issue an SQLITE_WARNING message on the [error log] if a 
[double-quoted string literal] is used.
<li>The [sqlite3_normalized_sql()] interface works on any prepared statement
created using [sqlite3_prepare_v2()] or [sqlite3_prepare_v3()].  It is no








>
>
>
>
>
>
>
>
>
>
>








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

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 {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>
<li>SQLITE_SOURCE_ID: <i>pending</i>
<li>SHA3-256 for sqlite3.c: <i>pending</i>
} {patchagainst 1}

chng {2019-02-07 (3.27.0)} {
<li>Added the [VACUUM INTO] command
<li>Issue an SQLITE_WARNING message on the [error log] if a 
[double-quoted string literal] is used.
<li>The [sqlite3_normalized_sql()] interface works on any prepared statement
created using [sqlite3_prepare_v2()] or [sqlite3_prepare_v3()].  It is no
︙︙
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 {

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
c7ee083322|2018-06-04|Version 3.24.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 {
xxxxxxxxxx|pending|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
c7ee083322|2018-06-04|Version 3.24.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_0.html">Version 3.27.0</a> ([dateof:3.27.0]).
<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_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>
︙︙