Debian Codegraph @

www/releaselog/3_8_5.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.8.5 On 2014-06-04</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.8.5 On 2014-06-04</h2><p><ol class='lessindent'>
119 <li>Added support for <a href="../queryplanner.html#partialsort">partial sorting by index</a>.
120 <li>Enhance the query planner so that it always prefers an index that uses a superset of
121 WHERE clause terms relative to some other index.
122 <li>Improvements to the <a href="../fts3.html#*fts4automergecmd">automerge command</a> of <a href="../fts3.html#fts4">FTS4</a> to better control the index size
123 for a full-text index that is subject to a large number of updates.
124 <li>Added the <a href="../rtree.html#xquery">sqlite3_rtree_query_callback()</a> interface to <a href="../rtree.html">R-Tree extension</a>
125 <li>Added new <a href="../uri.html#coreqp">URI query parameters</a> "nolock" and "immutable".
126 <li>Use less memory by not remembering CHECK constraints on read-only
127 database connections.
128 <li>Enable the <a href="../queryplanner.html#or_in_where">OR optimization</a> for <a href="../withoutrowid.html">WITHOUT ROWID</a> tables.
129 <li>Render expressions of the form "x IN (?)" (with a single value in
130 the list on the right-hand side of the IN operator) as if they where "x==?",
131 Similarly optimize "x NOT IN (?)"
132 <li>Add the ".system" and ".once" commands to the <a href="../cli.html">command-line shell</a>.
133 <li>Added the <a href="../c3ref/c_iocap_atomic.html">SQLITE_IOCAP_IMMUTABLE</a> bit to the set of bits that can be returned by
134 the xDeviceCharacteristics method of a <a href="../vfs.html">VFS</a>.
135 <li>Added the <a href="../c3ref/c_testctrl_always.html">SQLITE_TESTCTRL_BYTEORDER</a> test control.
136 <p><b>Bug Fixes:</b>
137 <li>OFFSET clause ignored on queries without a FROM clause.
138 Ticket <a href="https://sqlite.org/src/info/07d6a0453d">07d6a0453d</a>
139 <li>Assertion fault on queries involving expressions of the form
140 "x IN (?)". Ticket <a href="https://sqlite.org/src/info/e39d032577">e39d032577</a>.
141 <li>Incorrect column datatype reported.
142 Ticket <a href="https://sqlite.org/src/info/a8a0d2996a">a8a0d2996a</a>
143 <li>Duplicate row returned on a query against a table with more than
144 16 indices, each on a separate column, and all used via OR-connected constraints.
145 Ticket <a href="https://sqlite.org/src/info/10fb063b11">10fb063b11</a>
146 <li>Partial index causes assertion fault on UPDATE OR REPLACE.
147 Ticket <a href="https://sqlite.org/src/info/2ea3e9fe63">2ea3e9fe63</a>
148 <li>Crash when calling undocumented SQL function sqlite_rename_parent()
149 with NULL parameters.
150 Ticket <a href="https://sqlite.org/src/info/264b970c4379fd">264b970c43</a>
151 <li>ORDER BY ignored if the query has an identical GROUP BY.
152 Ticket <a href="https://sqlite.org/src/info/b75a9ca6b0499">b75a9ca6b0</a>
153 <li>The group_concat(x,'') SQL function returns NULL instead of an empty string
154 when all inputs are empty strings.
155 Ticket <a href="https://sqlite.org/src/info/55746f9e65f85">55746f9e65</a>
156 <li>Fix a bug in the VDBE code generator that caused crashes when
157 doing an INSERT INTO ... SELECT statement where the number of columns
158 being inserted is larger than the number of columns in the destination
159 table.
160 Ticket <a href="https://sqlite.org/src/info/e9654505cfda9">e9654505cfd</a>
161 <li>Fix a problem in CSV import in the <a href="../cli.html">command-line shell</a>
162 where if the leftmost field of the first row
163 in the CSV file was both zero bytes in size and unquoted no data would
164 be imported.
165 <li>Fix a problem in FTS4 where the left-most column that contained
166 the <a href="../fts3.html#fts4notindexed">notindexed column</a> name as a prefix
167 was not indexed rather than the column whose name matched exactly.
168 <li>Fix the <a href="../c3ref/db_readonly.html">sqlite3_db_readonly()</a> interface so that it returns true if
169 the database is read-only due to the file format write version number
170 being too large.
171
172 <li>SQLITE_SOURCE_ID: "2014-06-04 14:06:34 b1ed4f2a34ba66c29b130f8d13e9092758019212"
173 <li>SHA1 for sqlite3.c: 7bc194957238c61b1a47f301270286be5bc5208c
174
175 </ol></p>
176
177 <p>A <a href="../changes.html">complete list of SQLite releases</a>
178 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
179 A detailed history of every
180 check-in is available at
181 <a href="https://sqlite.org/src/timeline">
182 SQLite version control site</a>.</p>
183
184