Debian Codegraph @

www/releaselog/3_22_0.html

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