Debian Codegraph @

www/releaselog/3_19_2.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.19.2 On 2017-05-25</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.19.2 On 2017-05-25</h2><p><b>Prior changes from version 3.19.0 (2017-05-22):</b></p>
119 <p><ol class='lessindent'>
120 <li value='1'> The <a href="../c3ref/c_alter_table.html">SQLITE_READ</a> <a href="../c3ref/set_authorizer.html">authorizer callback</a> is invoked once
121 with a column name that is an empty string
122 for every table referenced in a query from which no columns are extracted.
123 <li> When using an index on an expression, try to use expression values already
124 available in the index, rather than loading the original columns and recomputing
125 the expression.
126 <li> Enhance the <a href="../optoverview.html#flattening">flattening optimization</a> so that it is able to flatten views
127 on the right-hand side of a LEFT JOIN.
128 <li> Use <a href="../lang_corefunc.html#replace">replace()</a> instead of <a href="../lang_corefunc.html#char">char()</a> for escaping newline and carriage-return
129 characters embedded in strings in the .dump output from the <a href="../cli.html">command-line shell</a>.
130 <li> Avoid unnecessary foreign key processing in UPDATE statements that do not
131 touch the columns that are constrained by the foreign keys.
132 <li> On a DISTINCT query that uses an index, try to skip ahead to the next distinct
133 entry using the index rather than stepping through rows, when an appropriate
134 index is available.
135 <li> Avoid unnecessary invalidation of <a href="../c3ref/blob.html">sqlite3_blob</a> handles when making
136 changes to unrelated tables.
137 <li> Transfer any terms of the HAVING clause that use only columns mentioned in
138 the GROUP BY clause over to the WHERE clause for faster processing.
139 <li> Reuse the same materialization of a VIEW if that VIEW appears more than
140 once in the same query.
141 <li> Enhance <a href="../pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> so that it identifies tables that have two
142 or more rows with the same <a href="../lang_createtable.html#rowid">rowid</a>.
143 <li> Enhance the <a href="../fts5.html">FTS5</a> query syntax so that <a href="../fts5.html#fts5_column_filters">column filters</a>
144 may be applied to arbitrary expressions.
145 <li> Enhance the <a href="../json1.html#jex">json_extract()</a> function to cache and reuse parses of JSON
146 input text.
147 <li> Added the <a href="https://sqlite.org/src/file/ext/misc/anycollseq.c">anycollseq.c</a>
148 <a href="../loadext.html">loadable extension</a> that allows a generic SQLite database connection to
149 read a schema that contains unknown and/or
150 application-specific <a href="../datatype3.html#collation">collating sequences</a>.
151 <p><b>Bug Fixes:</b>
152 <li> Fix a problem in <a href="../lang_replace.html">REPLACE</a> that can result in a corrupt database containing
153 two or more rows with the same <a href="../lang_createtable.html#rowid">rowid</a>. Fix for ticket
154 <a href="https://sqlite.org/src/info/f68dc596c4e6018d">f68dc596c4e6018d</a>.
155 <li> Fix a problem in <a href="../pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> that was causing a subsequent
156 <a href="../lang_vacuum.html">VACUUM</a> to behave suboptimally.
157 <li> Fix the <a href="../pragma.html#pragma_foreign_key_check">PRAGMA foreign_key_check</a> command so that it works correctly with
158 foreign keys on <a href="../withoutrowid.html">WITHOUT ROWID</a> tables.
159 <li> Fix a bug in the b-tree logic that can result in incorrect duplicate answers
160 for IN operator queries. Ticket
161 <a href="https://sqlite.org/src/info/61fe9745">61fe9745</a>
162 <li> Disallow leading zeros in numeric constants in JSON. Fix for ticket
163 <a href="https://sqlite.org/src/info/b93be8729a895a528e2">b93be8729a895a528e2</a>.
164 <li> Disallow control characters inside of strings in JSON. Fix for ticket
165 <a href="https://sqlite.org/src/info/6c9b5514077fed34551">6c9b5514077fed34551</a>.
166 <li> Limit the depth of recursion for JSON objects and arrays in order to avoid
167 excess stack usage in the recursive descent parser. Fix for ticket
168 <a href="https://sqlite.org/src/info/981329adeef51011052">981329adeef51011052</a>.
169 </ol>
170 <p><b>Prior changes from version 3.19.1 (2017-05-24):</b></p>
171 <p><ol class='lessindent'>
172 <li value='21'>Fix a bug in the LEFT JOIN <a href="../optoverview.html#flattening">flattening optimization</a>. Ticket
173 <a href="https://sqlite.org/src/info/cad1ab4cb7b0fc">cad1ab4cb7b0fc</a>.
174 <li>Remove a surplus semicolon that was causing problems for older versions of MSVC.
175 </ol>
176 <p><b>Changes in this specific patch release, version 3.19.2 (2017-05-25):</b></p>
177 <p><ol class='lessindent'>
178 <li value='23'>Fix more bugs in the LEFT JOIN <a href="../optoverview.html#flattening">flattening optimization</a>. Ticket
179 <a href="https://sqlite.org/src/info/7fde638e94287d2c">7fde638e94287d2c</a>.
180 <p><b>Hashes:</b>
181 <li>SQLITE_SOURCE_ID: "2017-05-25 16:50:27 edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9"
182 <li>SHA3-256 for sqlite3.c: 1be0c457869c1f7eba58c3b5097b9ec307a15be338308bee8e5be8570bcf5d1e
183
184 </ol></p>
185
186 <p>A <a href="../changes.html">complete list of SQLite releases</a>
187 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
188 A detailed history of every
189 check-in is available at
190 <a href="https://sqlite.org/src/timeline">
191 SQLite version control site</a>.</p>
192
193