Debian Codegraph @

www/releaselog/3_7_16_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.7.16.2 On 2013-04-12</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.7.16.2 On 2013-04-12</h2><p><ol class='lessindent'>
119 <li>Added the <a href="../pragma.html#pragma_foreign_key_check">PRAGMA foreign_key_check</a> command.
120 <li>Added new extended error codes for all SQLITE_CONSTRAINT errors
121 <li>Added the SQLITE_READONLY_ROLLBACK extended error code for when a database
122 cannot be opened because it needs rollback recovery but is read-only.
123 <li>Added SQL functions <a href="../lang_corefunc.html#unicode">unicode(A)</a> and <a href="../lang_corefunc.html#char">char(X1,...,XN)</a>.
124 <li>Performance improvements for <a href="../pragma.html#pragma_incremental_vacuum">PRAGMA incremental_vacuum</a>, especially in
125 cases where the number of free pages is greater than what will fit on a
126 single trunk page of the freelist.
127 <li>Improved optimization of queries containing aggregate min() or max().
128 <li>Enhance virtual tables so that they can potentially use an index when
129 the WHERE clause contains the IN operator.
130 <li>Allow indices to be used for sorting even if prior terms of the index
131 are constrained by IN operators in the WHERE clause.
132 <li>Enhance the <a href="../pragma.html#pragma_table_info">PRAGMA table_info</a> command so that the "pk" column is an
133 increasing integer to show the order of columns in the primary key.
134 <li>Enhance the query optimizer to exploit transitive join constraints.
135 <li>Performance improvements in the query optimizer.
136 <li>Allow the error message from <a href="../pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> to be longer than
137 20000 bytes.
138 <li>Improved name resolution for deeply nested queries.
139 <li>Added the test_regexp.c module as a demonstration of how to implement
140 the REGEXP operator.
141 <li>Improved error messages in the <a href="../rtree.html">RTREE</a> extension.
142 <li>Enhance the <a href="../cli.html">command-line shell</a> so that a non-zero argument to the
143 ".exit" command causes the shell to exit immediately without cleanly
144 shutting down the database connection.
145 <li>Improved error messages for invalid boolean arguments to dot-commands
146 in the <a href="../cli.html">command-line shell</a>.
147 <li>Improved error messages for "foreign key mismatch" showing the names of
148 the two tables involved.
149 <li>Remove all uses of umask() in the unix VFS.
150 <li>Added the <a href="../pragma.html#pragma_vdbe_addoptrace">PRAGMA vdbe_addoptrace</a> and <a href="../pragma.html#pragma_vdbe_debug">PRAGMA vdbe_debug</a> commands.
151 <li>Change to use strncmp() or the equivalent instead of memcmp() when
152 comparing non-zero-terminated strings.
153 <li>Update cygwin interfaces to omit deprecated API calls.
154 <li>Enhance the <a href="../spellfix1.html">spellfix1</a> extension so that the edit distance cost table can
155 be changed at runtime by inserting a string like 'edit_cost_table=TABLE'
156 into the "command" field.
157
158 <li>Bug fix: repair a long-standing problem that could cause incorrect query
159 results in a 3-way or larger join that compared INTEGER fields against TEXT
160 fields in two or more places.
161 Ticket <a href="https://sqlite.org/src/info/fc7bd6358f">fc7bd6358f</a>
162 <li>Bug fix: Issue an error message if the 16-bit reference counter on a
163 view overflows due to an overly complex query.
164 <li>Bug fix: Avoid leaking memory on LIMIT and OFFSET clauses in deeply
165 nested UNION ALL queries.
166 <li>Bug fix: Make sure the schema is up-to-date prior to running pragmas
167 table_info, index_list, index_info, and foreign_key_list.
168
169 </ol></p><p><ol class='lessindent'>
170 <li>Fix for a bug in the ORDER BY optimizer that was introduced in
171 <a href="../releaselog/3_7_15.html">version 3.7.15</a> which would sometimes optimize out the sorting step
172 when in fact the sort was required.
173 Ticket <a href="https://sqlite.org/src/info/a179fe7465">a179fe7465</a>
174 <li>Fix a long-standing bug in the <a href="../lang_expr.html#castexpr">CAST expression</a> that would recognize UTF16
175 characters as digits even if their most-significant-byte was not zero.
176 Ticket <a href="https://sqlite.org/src/info/689137afb6da41">689137afb6da41</a>.
177 <li>Fix a bug in the NEAR operator of <a href="../fts3.html">FTS3</a> when applied to subfields.
178 Ticket <a href="https://sqlite.org/src/info/38b1ae018f">38b1ae018f</a>.
179 <li>Fix a long-standing bug in the storage engine that would (very rarely)
180 cause a spurious report of an SQLITE_CORRUPT error but which was otherwise
181 harmless.
182 Ticket <a href="https://sqlite.org/src/info/6bfb98dfc0c">6bfb98dfc0c</a>.
183 <li>The SQLITE_OMIT_MERGE_SORT option has been removed. The merge sorter is
184 now a required component of SQLite.
185 <li>Fixed lots of spelling errors in the source-code comments
186 </ol></p><p><ol class='lessindent'>
187 <li>Fix a bug (present since version 3.7.13) that could result in database corruption
188 on windows if two or more processes try to access the same database file at the
189 same time and immediately after third process crashed in the middle of committing
190 to that same file. See ticket
191 <a href="https://sqlite.org/src/info/7ff3120e4f">7ff3120e4f</a> for further
192 information.
193
194 <li>SQLITE_SOURCE_ID:
195 "2013-04-12 11:52:43 cbea02d93865ce0e06789db95fd9168ebac970c7"
196 <li>SHA1 for sqlite3.c: d466b54789dff4fb0238b9232e74896deaefab94
197
198 </ol></p>
199
200 <p>A <a href="../changes.html">complete list of SQLite releases</a>
201 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
202 A detailed history of every
203 check-in is available at
204 <a href="https://sqlite.org/src/timeline">
205 SQLite version control site</a>.</p>
206
207