Debian Codegraph @

www/releaselog/3_13_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.13.0 On 2016-05-18</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.13.0 On 2016-05-18</h2><p><ol class='lessindent'>
119 <li>Postpone I/O associated with TEMP files for as long as possible, with the hope
120 that the I/O can ultimately be avoided completely.
121 <li>Merged the <a href="../sessionintro.html">session</a> extension into trunk.
122 <li>Added the ".auth ON|OFF" command to the <a href="../cli.html">command-line shell</a>.
123 <li>Added the "--indent" option to the ".schema" and ".fullschema" commands of
124 the <a href="../cli.html">command-line shell</a>, to turn on pretty-printing.
125 <li>Added the ".eqp full" option to the <a href="../cli.html">command-line shell</a>, that does both <a href="../lang_explain.html">EXPLAIN</a>
126 and <a href="../eqp.html">EXPLAIN QUERY PLAN</a> on each statement that is evaluated.
127 <li>Improved unicode filename handling in the <a href="../cli.html">command-line shell</a> on Windows.
128 <li>Improved resistance against goofy query planner decisions caused by
129 incomplete or incorrect modifications to the <a href="../fileformat2.html#stat1tab">sqlite_stat1</a>
130 table by the application.
131 <li>Added the <a href="../c3ref/db_config.html">sqlite3_db_config</a>(db,<a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfigenableloadextension">SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION</a>) interface
132 which allows the <a href="../c3ref/load_extension.html">sqlite3_load_extension()</a> C-API to be enabled while keeping the
133 <a href="../lang_corefunc.html#load_extension">load_extension()</a> SQL function disabled for security.
134 <li>Change the <a href="../tempfiles.html#tempdir">temporary directory search algorithm</a> on Unix to allow directories with
135 write and execute permission, but without read permission, to serve as temporary
136 directories. Apply this same standard to the "." fallback directory.
137 <p><b>Bug Fixes:</b>
138 <li>Fix a problem with the multi-row one-pass DELETE optimization that was
139 causing it to compute incorrect answers with a self-referential subquery in
140 the WHERE clause. Fix for ticket
141 <a href="https://sqlite.org/src/info/dc6ebeda9396087">dc6ebeda9396087</a>
142 <li>Fix a possible segfault with DELETE when table is a <a href="../rowidtable.html">rowid table</a> with an
143 <a href="../lang_createtable.html#rowid">INTEGER PRIMARY KEY</a> and the WHERE clause contains a OR and
144 the table has one or more indexes that are able to trigger the OR optimization,
145 but none of the indexes reference any table columns other than the INTEGER PRIMARY KEY.
146 Ticket <a href="https://sqlite.org/src/info/16c9801ceba49">16c9801ceba49</a>.
147 <li>When checking for the <a href="../optoverview.html#pushdown">WHERE-clause push-down optimization</a>, verify that all terms
148 of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket
149 <a href="https://sqlite.org/src/info/f7f8c97e97597">f7f8c97e97597</a>.
150 <li>Fix a locking race condition in Windows that can occur when two or more processes
151 attempt to recover the same <a href="../fileformat2.html#hotjrnl">hot journal</a> at the same time.
152 <p><b>Hashes:</b>
153 <li>SQLITE_SOURCE_ID: "2016-05-18 10:57:30 fc49f556e48970561d7ab6a2f24fdd7d9eb81ff2"
154 <li>SHA1 for sqlite3.c: 9b9171b1e6ce7a980e6b714e9c0d9112657ad552
155
156 <p><b>Bug fixes backported into patch release 3.12.2 (2016-04-18):</b></p>
157
158 <li>Fix a backwards compatibility problem in version 3.12.0 and 3.12.1:
159 Columns declared as <tt>"INTEGER" PRIMARY KEY</tt> (with quotes around
160 the datatype keyword) were not being recognized as an
161 <a href="../lang_createtable.html#rowid">INTEGER PRIMARY KEY</a>, which resulted in an incompatible database file.
162 Ticket <a href="https://sqlite.org/src/info/7d7525cb01b68">7d7525cb01b68</a>
163 <li>Fix a bug (present since <a href="../releaselog/3_9_0.html">version 3.9.0</a>) that can cause the <a href="../lang_delete.html">DELETE</a>
164 operation to miss rows if <a href="../pragma.html#pragma_reverse_unordered_selects">PRAGMA reverse_unordered_selects</a> is turned on.
165 Ticket <a href="https://sqlite.org/src/info/a306e56ff68b8fa5">a306e56ff68b8fa5</a>
166 <li>Fix a bug in the code generator that can cause incorrect results if
167 two or more <a href="../vtab.html">virtual tables</a> are joined and the virtual table used in
168 outer loop of the join has an <a href="../lang_expr.html#in_op">IN operator</a> constraint.
169 <li>Correctly interpret negative "PRAGMA cache_size" values when determining
170 the cache size used for sorting large amounts of data.
171
172 <p><b>Bug fixes backported into patch release 3.12.1 (2016-04-08):</b></p>
173
174 <li>Fix a boundary condition error introduced by version 3.12.0
175 that can result in a crash during heavy <a href="../lang_savepoint.html">SAVEPOINT</a> usage.
176 Ticket <a href="https://sqlite.org/src/info/7f7f8026eda38">7f7f8026eda38</a>.
177 <li>Fix <a href="../lang_createview.html">views</a> so that they inherit column datatypes from the
178 table that they are defined against, when possible.
179 <li>Fix the query planner so that IS and IS NULL operators are able
180 to drive an index on a LEFT OUTER JOIN.
181
182 </ol></p>
183
184 <p>A <a href="../changes.html">complete list of SQLite releases</a>
185 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
186 A detailed history of every
187 check-in is available at
188 <a href="https://sqlite.org/src/timeline">
189 SQLite version control site</a>.</p>
190
191