Debian Codegraph @

www/releaselog/3_7_17.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.17 On 2013-05-20</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.17 On 2013-05-20</h2><p><ol class='lessindent'>
119 <li>Add support for <a href="../mmap.html">memory-mapped I/O</a>.
120 <li>Add the <a href="../c3ref/strglob.html">sqlite3_strglob()</a> convenience interface.
121 <li>Assigned the integer at offset 68 in the <a href="../fileformat2.html#database_header">database header</a> as the
122 <a href="../fileformat2.html#appid">Application ID</a> for when SQLite is used as an <a href="../appfileformat.html">application file-format</a>.
123 Added the <a href="../pragma.html#pragma_application_id">PRAGMA application_id</a> command to query and set the Application ID.
124 <li>Report rollback recovery in the <a href="../errlog.html">error log</a> as SQLITE_NOTICE_RECOVER_ROLLBACK.
125 Change the error log code for WAL recover from
126 SQLITE_OK to SQLITE_NOTICE_RECOVER_WAL.
127 <li>Report the risky uses of <a href="../howtocorrupt.html#unlink">unlinked database files</a> and
128 <a href="../howtocorrupt.html#alias">database filename aliasing</a> as SQLITE_WARNING messages in the <a href="../errlog.html">error log</a>.
129 <li>Added the <a href="../compile.html#trace_size_limit">SQLITE_TRACE_SIZE_LIMIT</a> compile-time option.
130 <li>Increase the default value of <a href="../compile.html#max_schema_retry">SQLITE_MAX_SCHEMA_RETRY</a> to 50 and make sure
131 that it is honored in every place that a schema change might force a statement
132 retry.
133 <li>Add a new test harness called "mptester" used to verify correct operation
134 when multiple processes are using the same database file at the same time.
135 <li>Enhance the <a href="../loadext.html">extension loading</a> mechanism to be more flexible (while
136 still maintaining backwards compatibility) in two ways:
137 <ol>
138 <li>If the default entry point "sqlite3_extension_init" is not present in
139 the loadable extension, also try an entry point "sqlite3_X_init" where
140 "X" is based on the shared library filename. This allows every extension
141 to have a different entry point, which allows them to be statically linked
142 with no code changes.
143 <li>The shared library filename passed to <a href="../c3ref/load_extension.html">sqlite3_load_extension()</a> may
144 omit the filename suffix, and an appropriate architecture-dependent
145 suffix (".so", ".dylib", or ".dll") will be added automatically.
146 </ol>
147 <li>Added many new loadable extensions to the source tree, including
148 amatch, closure, fuzzer, ieee754, nextchar, regexp, spellfix,
149 and wholenumber. See header comments on each extension source file
150 for further information about what that extension does.
151 <li>Enhance <a href="../fts3.html">FTS3</a> to avoid using excess stack space when there are a huge
152 number of terms on the right-hand side of the MATCH operator. A side-effect
153 of this change is that the MATCH operator can only accommodate 12 NEAR
154 operators at a time.
155 <li>Enhance the <a href="../fts3.html#fts4aux">fts4aux</a> virtual table so that it can be a TEMP table.
156 <li>Added the <a href="../fts3.html#fts3tok">fts3tokenize virtual table</a> to the <a href="../fts3.html">full-text search</a> logic.
157 <li>Query planner enhancement: Use the transitive property of constraints
158 to move constraints into the outer loops of a join whenever possible,
159 thereby reducing the amount of work that needs to occur in inner loops.
160 <li>Discontinue the use of posix_fallocate() on unix, as it does not work on all
161 filesystems.
162 <li>Improved tracing and debugging facilities in the Windows <a href="../vfs.html">VFS</a>.
163 <li>Bug fix: Fix a potential <b>database corruption bug</b>
164 in <a href="../sharedcache.html">shared cache mode</a> when one
165 <a href="../c3ref/sqlite3.html">database connection</a> is closed while another is in the middle of a write
166 transaction.
167 Ticket <a href="https://sqlite.org/src/info/e636a050b7">e636a050b7</a>
168 <li>Bug fix:
169 Only consider AS names from the result set as candidates for resolving
170 identifiers in the WHERE clause if there are no other matches. In the
171 ORDER BY clause, AS names take priority over any column names.
172 Ticket <a href="https://sqlite.org/src/info/2500cdb9be05">2500cdb9be05</a>
173 <li>Bug fix: Do not allow a virtual table to cancel the ORDER BY clause unless
174 all outer loops are guaranteed to return no more than one row result.
175 Ticket <a href="https://sqlite.org/src/info/ba82a4a41eac1">ba82a4a41eac1</a>.
176 <li>Bug fix: Do not suppress the ORDER BY clause on a virtual table query if
177 an IN constraint is used.
178 Ticket <a href="https://sqlite.org/src/info/f69b96e3076e">f69b96e3076e</a>.
179 <li>Bug fix: The <a href="../cli.html">command-line shell</a> gives an exit code of 0 when terminated
180 using the ".quit" command.
181 <li>Bug fix: Make sure <a href="../pragma.html#syntax">PRAGMA</a> statements appear in <a href="../c3ref/profile.html">sqlite3_trace()</a> output.
182 <li>Bug fix: When a <a href="../lang_select.html#compound">compound query</a> that uses an ORDER BY clause
183 with a <a href="../lang_expr.html#collateop">COLLATE operator</a>, make sure that the sorting occurs
184 according to the specified collation and that the comparisons associate with
185 the compound query use the native collation. Ticket
186 <a href="https://sqlite.org/src/info/6709574d2a8d8">6709574d2a8d8</a>.
187 <li>Bug fix: Makes sure the <a href="../c3ref/set_authorizer.html">authorizer</a> callback gets
188 a valid pointer to the string "ROWID" for the column-name parameter when
189 doing an <a href="../lang_update.html">UPDATE</a> that changes the rowid. Ticket
190 <a href="https://sqlite.org/src/info/0eb70d77cb05bb2272">0eb70d77cb05bb2272</a>
191 <li>Bug fix: Do not move WHERE clause terms inside OR expressions that are
192 contained within an ON clause of a LEFT JOIN. Ticket
193 <a href="https://sqlite.org/src/info/f2369304e4">f2369304e4</a>
194 <li>Bug fix: Make sure an error is always reported when attempting to preform
195 an operation that requires a <a href="../datatype3.html#collation">collating sequence</a> that is missing.
196 Ticket <a href="https://sqlite.org/src/info/0fc59f908b">0fc59f908b</a>
197
198 <li>SQLITE_SOURCE_ID:
199 "2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668"
200 <li>SHA1 for sqlite3.c: 246987605d0503c700a08b9ee99a6b5d67454aab
201
202 </ol></p>
203
204 <p>A <a href="../changes.html">complete list of SQLite releases</a>
205 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
206 A detailed history of every
207 check-in is available at
208 <a href="https://sqlite.org/src/timeline">
209 SQLite version control site</a>.</p>
210
211