Debian Codegraph @

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