Debian Codegraph @

www/releaselog/3_25_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.25.2 On 2018-09-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.25.2 On 2018-09-25</h2><p><b>Prior changes from version 3.25.0 (2018-09-15):</b></p>
119 <p><ol class='lessindent'>
120 <li value='1'> Add support for <a href="../windowfunctions.html">window functions</a>
121 <li> Enhancements the <a href="../lang_altertable.html">ALTER TABLE</a> command:
122 <ol type="a">
123 <li> Add support for renaming columns within a table using
124 ALTER TABLE <i>table</i> RENAME COLUMN <i>oldname</i> TO <i>newname</i>.
125 <li> Fix table rename feature so that it also updates references
126 to the renamed table in <a href="../lang_createtrigger.html">triggers</a> and <a href="../lang_createview.html">views</a>.
127 </ol>
128 <li> Query optimizer improvements:
129 <ol type="a">
130 <li> Avoid unnecessary loads of columns in an aggregate query that
131 are not within an aggregate function and that are not part
132 of the GROUP BY clause.
133 <li> The IN-early-out optimization: When doing a look-up on a
134 multi-column index and an IN operator is used on a column
135 other than the left-most column, then if no rows match against
136 the first IN value, check to make sure there exist rows that
137 match the columns to the right before continuing with the
138 next IN value.
139 <li> Use the transitive property to try to propagate constant
140 values within the WHERE clause. For example, convert
141 "a=99 AND b=a" into "a=99 AND b=99".
142 </ol>
143 <li> Use a separate mutex on every inode in the unix <a href="../vfs.html">VFS</a>, rather than
144 a single mutex shared among them all, for slightly better concurrency
145 in multi-threaded environments.
146 <li> Enhance the <a href="../pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> command for improved detection
147 of problems on the page freelist.
148 <li> Output infinity as 1e999 in the ".dump" command of the
149 <a href="../cli.html">command-line shell</a>.
150 <li> Added the <a href="../c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntldataversion">SQLITE_FCNTL_DATA_VERSION</a> file-control.
151 <li> Added the <a href="../geopoly.html">Geopoly module</a>
152 <p><b>Bug fixes:</b>
153 <li> The ORDER BY LIMIT optimization might have caused an infinite loop
154 in the byte code of the prepared statement under very obscure
155 circumstances,
156 due to a confluence of minor defects in the query optimizer.
157 Fix for ticket
158 <a href="https://sqlite.org/src/info/9936b2fa443fec03ff25">9936b2fa443fec03ff25</a>
159 <li> On an UPSERT when the order of constraint checks is rearranged,
160 ensure that the affinity transformations on the inserted content
161 occur before any of the constraint checks. Fix for ticket
162 <a href="https://sqlite.org/src/info/79cad5e4b2e219dd197242e9e">79cad5e4b2e219dd197242e9e</a>.
163 <li> Avoid using a prepared statement for ".stats on" command of the
164 <a href="../cli.html">CLI</a> after it has been closed by the ".eqp full" logicc. Fix for ticket
165 <a href="https://sqlite.org/src/info/7be932dfa60a8a6b3b26bcf76">7be932dfa60a8a6b3b26bcf76</a>.
166 <li> The LIKE optimization was generating incorrect byte-code and hence
167 getting the wrong answer
168 if the left-hand operand has numeric affinity and the right-hand-side
169 pattern is '/%' or if the pattern begins with the ESCAPE character.
170 Fix for ticket
171 <a href="https://sqlite.org/src/info/c94369cae9b561b1f996d0054b">c94369cae9b561b1f996d0054b</a>
172 </ol>
173 <p><b>Prior changes from version 3.25.1 (2018-09-18):</b></p>
174 <p><ol class='lessindent'>
175 <li value='13'> Extra sanity checking added to ALTER TABLE in the 3.25.0 release
176 sometimes raises a false-positive
177 when the table being modified has a trigger that
178 updates a virtual table. The false-positive caused the ALTER
179 TABLE to rollback, thus leaving the schema unchanged.
180 Ticket <a href="https://sqlite.org/src/info/b41031ea2b537237">b41031ea2b537237</a>.
181 <li> The fix in the 3.25.0 release for the endless-loop in the byte-code
182 associated with the ORDER BY LIMIT optimization did not work for
183 some queries involving window functions. An additional correction
184 is required. Ticket
185 <a href="https://sqlite.org/src/info/510cde277783b5fb">510cde277783b5fb</a>
186 </ol>
187 <p><b>Changes in this specific patch release, version 3.25.2 (2018-09-25):</b></p>
188 <p><ol class='lessindent'>
189 <li value='15'> Add the <a href="../pragma.html#pragma_legacy_alter_table">PRAGMA legacy_alter_table=ON</a> command that causes the
190 "ALTER TABLE RENAME" command to behave as it did in SQLite versions 3.24.0
191 and earlier: references to the renamed table inside the bodies of triggers
192 and views are not updated. This new pragma provides a compatibility
193 work around for older programs that expected the older, wonky behavior
194 of ALTER TABLE RENAME.
195 <li> Fix a problem with the new <a href="../windowfunctions.html">window functions</a> implementation that caused
196 a malfunction when complicated expressions involving window functions were used
197 inside of a view.
198 <li> Fixes for various other compiler warnings and minor problems associated
199 with obscure configurations.
200 <p><b>Hashes:</b>
201 <li>SQLITE_SOURCE_ID: "2018-09-25 19:08:10 fb90e7189ae6d62e77ba3a308ca5d683f90bbe633cf681865365b8e92792d1c7"
202 <li>SHA3-256 for sqlite3.c: 34c23ff91631ae10354f8c9d62fd7d65732b3d7f3acfd0bbae31ff4a62fe28af
203
204 </ol></p>
205
206 <p>A <a href="../changes.html">complete list of SQLite releases</a>
207 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
208 A detailed history of every
209 check-in is available at
210 <a href="https://sqlite.org/src/timeline">
211 SQLite version control site</a>.</p>
212
213