Debian Codegraph @

www/releaselog/3_21_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.21.0 On 2017-10-24</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.21.0 On 2017-10-24</h2><p><ol class='lessindent'>
119 <li> Take advantage of the atomic-write capabilities in the
120 <a href="https://en.wikipedia.org/wiki/F2FS">F2FS filesystem</a> when available, for
121 greatly reduced transaction overhead. This currently requires the
122 <a href="../compile.html#enable_batch_atomic_write">SQLITE_ENABLE_BATCH_ATOMIC_WRITE</a> compile-time option.
123 <li> Allow <a href="../lang_attach.html">ATTACH</a> and <a href="../lang_detach.html">DETACH</a> commands to work inside of a transaction.
124 <li> Allow <a href="../vtab.html#worid">WITHOUT ROWID virtual tables</a> to be writable if the PRIMARY KEY
125 contains exactly one column.
126 <li> The "fsync()" that occurs after the header is written in a WAL reset
127 now uses the sync settings for checkpoints. This means it will use a
128 "fullfsync" on macs if <a href="../pragma.html#pragma_checkpoint_fullfsync">PRAGMA checkpoint_fullfsync</a> set on.
129 <li> The <a href="../c3ref/libversion.html">sqlite3_sourceid()</a> function tries to detect if the source code has
130 been modified from what is checked into version control and if there are
131 modifications, the last four characters of the version hash are shown as
132 "alt1" or "alt2". The objective is to detect accidental and/or careless
133 edits. A forger can subvert this feature.
134 <li> Improved de-quoting of column names for <a href="../lang_createtable.html#createtabas">CREATE TABLE AS</a> statements with
135 an aggregate query on the right-hand side.
136 <li> Fewer "stat()" system calls issued by the unix VFS.
137 <li> Enhanced the <a href="../optoverview.html#like_opt">LIKE optimization</a> so that it works with an <a href="../lang_expr.html#like">ESCAPE</a> clause.
138 <li> Enhanced <a href="../pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> and <a href="../pragma.html#pragma_quick_check">PRAGMA quick_check</a> to detect obscure
139 row corruption that they were formerly missing. Also update both pragmas
140 so that they return error text rather than SQLITE_CORRUPT when encountering
141 corruption in <a href="../fileformat2.html#record_format">records</a>.
142 <li> The query planner now prefers to implement FROM-clause subqueries using
143 <a href="../optoverview.html#coroutines">co-routines</a> rather using the <a href="../optoverview.html#flattening">query flattener</a> optimization. Support for
144 the use of co-routines for subqueries may no longer be disabled.
145 <li> Pass information about !=, IS, IS NOT, NOT NULL, and IS NULL constraints
146 into the <a href="../vtab.html#xbestindex">xBestIndex</a> method of virtual tables.
147 <li> Enhanced the <a href="../csv.html">CSV virtual table</a> so that it accepts the last row of
148 input if the final new-line character is missing.
149 <li> Remove the rarely-used "scratch" memory allocator. Replace it with the
150 <a href="../c3ref/c_config_covering_index_scan.html#sqliteconfigsmallmalloc">SQLITE_CONFIG_SMALL_MALLOC</a> configuration setting that gives SQLite
151 a hint that large memory allocations should be avoided when possible.
152 <li> Added the
153 <a href="https://sqlite.org/src/file/ext/misc/unionvtab.c">swarm virtual table</a>
154 to the existing union virtual table extension.
155 <li> Added the
156 <a href="https://sqlite.org/src/file/src/dbpage.c">sqlite_dbpage virtual table</a>
157 for providing direct access to pages
158 of the database file. The source code is built into the <a href="../amalgamation.html">amalgamation</a> and
159 is activated using the <a href="../compile.html#enable_dbpage_vtab">-DSQLITE_ENABLE_DBPAGE_VTAB</a> compile-time option.
160 <li> Add a new type of fts5vocab virtual table - "instance" - that provides
161 direct access to an FTS5 full-text index at the lowest possible level.
162 <li> Remove a call to rand_s() in the Windows VFS since it was causing problems
163 in Firefox on some older laptops.
164 <li> The <a href="https://sqlite.org/src/finfo?name=src/shell.c">src/shell.c</a> source code
165 to the <a href="../cli.html">command-line shell</a> is no longer under version control. That file
166 is now generated as part of the build process.
167 <li> Miscellaneous <a href="../cpu.html#microopt">microoptimizations</a> reduce CPU usage by about 2.1%.
168 <li> Bug fixes:
169 <ol type="a">
170 <li> Fix a faulty assert() statement discovered by OSSFuzz.
171 Ticket <a href="https://sqlite.org/src/info/cb91bf4290c211d">cb91bf4290c211d</a>
172 <li> Fix an obscure memory leak in <a href="../c3ref/result_blob.html">sqlite3_result_pointer()</a>.
173 Ticket <a href="https://sqlite.org/src/info/7486aa54b968e9b">7486aa54b968e9b</a>
174 <li> Avoid a possible use-after-free error by deferring schema resets until
175 after the query planner has finished running.
176 Ticket <a href="https://sqlite.org/src/info/be436a7f4587ce5">be436a7f4587ce5</a>
177 <li> Only use indexes-on-expressions to optimize ORDER BY or GROUP BY if
178 the COLLATE is correct.
179 Ticket <a href="https://sqlite.org/src/info/e20dd54ab0e4383">e20dd54ab0e4383</a>
180 <li> Fix an assertion fault that was coming up when the expression in an
181 index-on-expressions is really a constant.
182 Ticket <a href="https://sqlite.org/src/info/aa98619ad08ddca">aa98619ad08ddca</a>
183 <li> Fix an assertion fault that could occur following
184 <a href="../pragma.html#pragma_reverse_unordered_selects">PRAGMA reverse_unordered_selects</a>.
185 Ticket <a href="https://sqlite.org/src/info/cb91bf4290c211d">cb91bf4290c211d</a>
186 <li> Fix a segfault that can occur for queries that use table-valued functions
187 in an IN or EXISTS subquery.
188 Ticket <a href="https://sqlite.org/src/info/b899b6042f97f5">b899b6042f97f5</a>
189 <li> Fix a potential integer overflow problem when compiling a particular
190 horrendous common table expression. This was another problem discovered
191 by OSSFuzz. Check-in <a href="https://sqlite.org/src/info/6ee8cb6ae5">6ee8cb6ae5</a>.
192 <li> Fix a potential out-of-bound read when querying a corrupt database file,
193 a problem detected by Natalie Silvanovich of Google Project Zero.
194 Check-in <a href="https://sqlite.org/src/info/04925dee41a21f">04925dee41a21f</a>.
195 </ol>
196 <p><b>Hashes:</b>
197 <li>SQLITE_SOURCE_ID: "2017-10-24 18:55:49 1a584e499906b5c87ec7d43d4abce641fdf017c42125b083109bc77c4de48827"
198 <li>SHA3-256 for sqlite3.c: 84c181c0283d0320f488357fc8aab51898370c157601459ebee49d779036fe03
199
200 </ol></p>
201
202 <p>A <a href="../changes.html">complete list of SQLite releases</a>
203 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
204 A detailed history of every
205 check-in is available at
206 <a href="https://sqlite.org/src/timeline">
207 SQLite version control site</a>.</p>
208
209