blob: 3e29092702171e24d0645444049073d632aa8485 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
|
<!DOCTYPE html>
<html><head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link href="../sqlite.css" rel="stylesheet">
<title>SQLite Release 3.22.0 On 2018-01-22</title>
<!-- path=../ -->
</head>
<body>
<div class=nosearch>
<a href="../index.html">
<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite" border="0">
</a>
<div><!-- IE hack to prevent disappearing logo --></div>
<div class="tagline desktoponly">
Small. Fast. Reliable.<br>Choose any three.
</div>
<div class="menu mainmenu">
<ul>
<li><a href="../index.html">Home</a>
<li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
<li class='wideonly'><a href='../about.html'>About</a>
<li class='desktoponly'><a href="../docs.html">Documentation</a>
<li class='desktoponly'><a href="../download.html">Download</a>
<li class='wideonly'><a href='../copyright.html'>License</a>
<li class='desktoponly'><a href="../support.html">Support</a>
<li class='desktoponly'><a href="../prosupport.html">Purchase</a>
<li class='search' id='search_menubutton'>
<a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
</ul>
</div>
<div class="menu submenu" id="submenu">
<ul>
<li><a href='../about.html'>About</a>
<li><a href='../docs.html'>Documentation</a>
<li><a href='../download.html'>Download</a>
<li><a href='../support.html'>Support</a>
<li><a href='../prosupport.html'>Purchase</a>
</ul>
</div>
<div class="searchmenu" id="searchmenu">
<form method="GET" action="../search">
<select name="s" id="searchtype">
<option value="d">Search Documentation</option>
<option value="c">Search Changelog</option>
</select>
<input type="text" name="q" id="searchbox" value="">
<input type="submit" value="Go">
</form>
</div>
</div>
<script>
function toggle_div(nm) {
var w = document.getElementById(nm);
if( w.style.display=="block" ){
w.style.display = "none";
}else{
w.style.display = "block";
}
}
function toggle_search() {
var w = document.getElementById("searchmenu");
if( w.style.display=="block" ){
w.style.display = "none";
} else {
w.style.display = "block";
setTimeout(function(){
document.getElementById("searchbox").focus()
}, 30);
}
}
function div_off(nm){document.getElementById(nm).style.display="none";}
window.onbeforeunload = function(e){div_off("submenu");}
/* Disable the Search feature if we are not operating from CGI, since */
/* Search is accomplished using CGI and will not work without it. */
if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
document.getElementById("search_menubutton").style.display = "none";
}
/* Used by the Hide/Show button beside syntax diagrams, to toggle the */
function hideorshow(btn,obj){
var x = document.getElementById(obj);
var b = document.getElementById(btn);
if( x.style.display!='none' ){
x.style.display = 'none';
b.innerHTML='show';
}else{
x.style.display = '';
b.innerHTML='hide';
}
return false;
}
var antiRobot = 0;
function antiRobotGo(){
if( antiRobot!=3 ) return;
antiRobot = 7;
var j = document.getElementById("mtimelink");
if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
}
function antiRobotDefense(){
document.body.onmousedown=function(){
antiRobot |= 2;
antiRobotGo();
document.body.onmousedown=null;
}
document.body.onmousemove=function(){
antiRobot |= 2;
antiRobotGo();
document.body.onmousemove=null;
}
setTimeout(function(){
antiRobot |= 1;
antiRobotGo();
}, 100)
antiRobotGo();
}
antiRobotDefense();
</script>
<h2>SQLite Release 3.22.0 On 2018-01-22</h2><p><ol class='lessindent'>
<li> The output of <a href="../c3ref/trace_v2.html">sqlite3_trace_v2()</a> now shows each individual SQL statement
run within a trigger.
<li> Add the ability to read from <a href="../wal.html">WAL mode</a> databases even if the application
lacks write permission on the database and its containing directory, as long as
the -shm and -wal files exist in that directory.
<li> Added the <a href="../rtree.html#rtreecheck">rtreecheck()</a> scalar SQL function to the <a href="../rtree.html">R-Tree extension</a>.
<li> Added the <a href="../c3ref/vtab_nochange.html">sqlite3_vtab_nochange()</a> and <a href="../c3ref/value_blob.html">sqlite3_value_nochange()</a> interfaces
to help virtual table implementations optimize UPDATE operations.
<li> Added the <a href="../c3ref/vtab_collation.html">sqlite3_vtab_collation()</a> interface.
<li> Added support for the <a href="../fts5.html#carrotq">"^" initial token syntax</a> in FTS5.
<li> New extensions:
<ol type='a'>
<li> The <a href="../zipfile.html">Zipfile virtual table</a> can read and write a
<a href="https://en.wikipedia.org/wiki/Zip_(file_format)">ZIP Archive</a>.
<li> Added the fsdir(PATH) <a href="../vtab.html#tabfunc2">table-valued function</a> to the
<a href="https://sqlite.org/src/file/ext/misc/fileio.c">fileio.c</a> extension,
for listing the files in a directory.
<li> The <a href="https://sqlite.org/src/file/ext/misc/btreeinfo.c">sqlite_btreeinfo</a>
eponymous virtual table for introspecting and estimating the sizes of
the btrees in a database.
<li> The <a href="https://sqlite.org/src/file/ext/misc/appendvfs.c">Append VFS</a> is a
<a href="../vfs.html#shim">VFS shim</a> that allows an SQLite database to be appended to some other
file. This allows (for example) a database to be appended to an
executable that then opens and reads the database.
</ol>
<li> Query planner enhancements:
<ol type='a'>
<li> The optimization that uses an index to quickly compute an
aggregate min() or max() is extended to work with
<a href="../expridx.html">indexes on expressions</a>.
<li> The decision of whether to implement a FROM-clause subquery
as a co-routine or using <a href="../optoverview.html#flattening">query flattening</a>
now considers whether
the result set of the outer query is "complex" (if it
contains functions or expression subqueries). A complex result
set biases the decision toward the use of co-routines.
<li> The planner avoids query plans that use indexes with unknown
collating functions.
<li> The planner omits unused LEFT JOINs even if they are not the
right-most joins of a query.
</ol>
<li> Other performance optimizations:
<ol type='a'>
<li> A smaller and faster implementation of text to floating-point
conversion subroutine: sqlite3AtoF().
<li> The <a href="../lemon.html">Lemon parser generator</a> creates a faster parser.
<li> Use the strcspn() C-library routine to speed up the LIKE and
GLOB operators.
</ol>
<li> Improvements to the <a href="../cli.html">command-line shell</a>:
<ol type='a'>
<li> The ".schema" command shows the structure of virtual tables.
<li> Added support for reading and writing
<a href="../sqlar.html">SQLite Archive</a> files using
the <a href="../cli.html#sqlar">.archive command</a>.
<li> Added the experimental <a href="../cli.html#expert">.expert command</a>
<li> Added the ".eqp trigger" variant of the ".eqp" command
<li> Enhance the ".lint fkey-indexes" command so that it works with
<a href="../withoutrowid.html">WITHOUT ROWID</a> tables.
<li> If the filename argument to the shell is a ZIP archive rather than
an SQLite database, then the shell automatically opens that ZIP
archive using the <a href="../zipfile.html">Zipfile virtual table</a>.
<li> Added the <a href="../cli.html#editfunc">edit() SQL function</a>.
<li> Added the <a href="../cli.html#exexcel*">.excel command</a> to simplify exporting
database content to a spreadsheet.
<li> Databases are opened using
<a href="https://sqlite.org/src/file/ext/misc/appendvfs.c">Append VFS</a> when
the --append flag is used on the command line or with the
.open command.
</ol>
<li> Enhance the <a href="../compile.html#enable_update_delete_limit">SQLITE_ENABLE_UPDATE_DELETE_LIMIT</a> compile-time option so
that it works for <a href="../withoutrowid.html">WITHOUT ROWID</a> tables.
<li> Provide the <a href="../lang_corefunc.html#sqlite_offset">sqlite_offset(X)</a> SQL function that returns
the byte offset into the database file to the beginning of the record
holding value X, when compiling with <a href="../compile.html#enable_offset_sql_func">-DSQLITE_ENABLE_OFFSET_SQL_FUNC</a>.
<li> Bug fixes:
<ol type='a'>
<li> Infinite loop on an UPDATE that uses an OR operator in the WHERE clause.
Problem introduced with 3.17.0 and reported on the mailing list about
one year later. Ticket
<a href="https://www.sqlite.org/src/info/47b2581aa9bfecec">47b2581aa9bfecec</a>.
<li> Incorrect query results when the skip-ahead-distinct optimization is
used.
Ticket <a href="https://sqlite.org/src/info/ef9318757b152e3a">ef9318757b152e3a</a>.
<li> Incorrect query results on a join with a ORDER BY DESC. Ticket
<a href="https://sqlite.org/src/info/123c9ba32130a6c9">123c9ba32130a6c9</a>.
<li> Inconsistent result set column names between CREATE TABLE AS
and a simple SELECT. Ticket
<a href="https://sqlite.org/src/info/3b4450072511e621">3b4450072511e621</a>
<li> Assertion fault when doing REPLACE on an index on an expression.
Ticket <a href="https://sqlite.org/src/info/dc3f932f5a147771">dc3f932f5a147771</a>
<li> Assertion fault when doing an IN operator on a constant index.
Ticket <a href="https://sqlite.org/src/info/aa98619ad08ddcab">aa98619ad08ddcab</a>
</ol>
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: "2018-01-22 18:45:57 0c55d179733b46d8d0ba4d88e01a25e10677046ee3da1d5b1581e86726f2171d"
<li>SHA3-256 for sqlite3.c: 206df47ebc49cd1710ac0dd716ce5de5854826536993f4feab7a49d136b85069
</ol></p>
<p>A <a href="../changes.html">complete list of SQLite releases</a>
in a single page and a <a href="../chronology.html">chronology</a> are both also available.
A detailed history of every
check-in is available at
<a href="http://www.sqlite.org/src/timeline">
SQLite version control site</a>.</p>
|
