Debian Codegraph @

www/releaselog/3_7_15.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.15 On 2012-12-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.15 On 2012-12-12</h2><p><ol class='lessindent'>
119 <li>Added the <a href="../c3ref/errcode.html">sqlite3_errstr()</a> interface.
120 <li>Avoid invoking the <a href="../c3ref/profile.html">sqlite3_trace()</a> callback multiple times when a
121 statement is automatically reprepared due to <a href="../rescode.html#schema">SQLITE_SCHEMA</a> errors.
122 <li>Added support for Windows Phone 8 platforms
123 <li>Enhance IN operator processing to make use of indices with numeric
124 affinities.
125 <li>Do full-table scans using covering indices when possible, under the
126 theory that an index will be smaller and hence can be scanned with
127 less I/O.
128 <li>Enhance the query optimizer so that ORDER BY clauses are more aggressively
129 optimized, especially in joins where various terms of the ORDER BY clause
130 come from separate tables of the join.
131 <li>Add the ability to implement FROM clause subqueries as coroutines rather
132 that manifesting the subquery into a temporary table.
133 <li>Enhancements the command-line shell:
134 <ol type='a'>
135 <li>Added the ".print" command
136 <li>Negative numbers in the ".width" command cause right-alignment
137 <li>Add the ".wheretrace" command when compiled with SQLITE_DEBUG
138 </ol>
139 <li>Added the <a href="../pragma.html#pragma_busy_timeout">busy_timeout pragma</a>.
140 <li>Added the <a href="../lang_corefunc.html#instr">instr()</a> SQL function.
141 <li>Added the <a href="../c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlbusyhandler">SQLITE_FCNTL_BUSYHANDLER</a> file control, used to allow VFS
142 implementations to get access to the busy handler callback.
143 <li>The xDelete method in the built-in <a href="../vfs.html">VFSes</a> now return
144 SQLITE_IOERR_DELETE_NOENT if the file to be deleted does not exist.
145 <li>Enhanced support for QNX.
146 <li>Work around an optimizer bug in the MSVC compiler when targeting ARM.
147 <li>Bug fix: Avoid various concurrency problems in <a href="../sharedcache.html">shared cache mode</a>.
148 <li>Bug fix: Avoid a deadlock or crash if the <a href="../backup.html">backup API</a>, <a href="../sharedcache.html">shared cache</a>,
149 and the SQLite Encryption Extension are all used at once.
150 <li>Bug fix: SQL functions created using the TCL interface honor the
151 "nullvalue" setting.
152 <li>Bug fix: Fix a 32-bit overflow problem on CREATE INDEX for databases
153 larger than 16GB.
154 <li>Bug fix: Avoid segfault when using the <a href="../lang_expr.html#collateop">COLLATE operator</a> inside of a
155 <a href="../lang_createtable.html#ckconst">CHECK constraint</a> or <a href="../lang_createview.html">view</a> in <a href="../sharedcache.html">shared cache mode</a>.
156
157 <li>SQLITE_SOURCE_ID:
158 "2012-12-12 13:36:53 cd0b37c52658bfdf992b1e3dc467bae1835a94ae"
159 <li>SHA1 for sqlite3.c: 2b413611f5e3e3b6ef5f618f2a9209cdf25cbcff"
160
161 </ol></p>
162
163 <p>A <a href="../changes.html">complete list of SQLite releases</a>
164 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
165 A detailed history of every
166 check-in is available at
167 <a href="https://sqlite.org/src/timeline">
168 SQLite version control site</a>.</p>
169
170