Debian Codegraph @

www/releaselog/3_7_9.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.9 On 2011-11-01</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.9 On 2011-11-01</h2><p><ol class='lessindent'>
119 <li>If a search token (on the right-hand side of the MATCH operator) in
120 <a href="../fts3.html#fts4">FTS4</a> begins with "&#94;" then that token must be the first in its field
121 of the document. <b>** Potentially Incompatible Change **</b>
122 <li>Added options <a href="../c3ref/c_dbstatus_options.html#sqlitedbstatuscachehit">SQLITE_DBSTATUS_CACHE_HIT</a> and <a href="../c3ref/c_dbstatus_options.html#sqlitedbstatuscachemiss">SQLITE_DBSTATUS_CACHE_MISS</a>
123 to the <a href="../c3ref/db_status.html">sqlite3_db_status()</a> interface.
124 <li>Removed support for <a href="../compile.html#enable_stat2">SQLITE_ENABLE_STAT2</a>, replacing it with the much
125 more capable <a href="../compile.html#enable_stat3">SQLITE_ENABLE_STAT3</a> option.
126 <li>Enhancements to the sqlite3_analyzer utility program, including the
127 --pageinfo and --stats options and support for multiplexed databases.
128 <li>Enhance the <a href="../c3ref/data_count.html">sqlite3_data_count()</a> interface so that it can be used to
129 determine if SQLITE_DONE has been seen on the prepared statement.
130 <li>Added the <a href="../c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntloverwrite">SQLITE_FCNTL_OVERWRITE</a> file-control by which the SQLite core
131 indicates to the VFS that the current transaction will overwrite the
132 entire database file.
133 <li>Increase the default <a href="../malloc.html#lookaside">lookaside memory allocator</a> allocation size from
134 100 to 128 bytes.
135 <li>Enhanced the query planner so that it can factor terms in and out of
136 OR expressions in the WHERE clause in an effort to find better indices.
137 <li>Added the <a href="../compile.html#direct_overflow_read">SQLITE_DIRECT_OVERFLOW_READ</a> compile-time option, causing
138 <a href="../fileformat2.html#ovflpgs">overflow pages</a> to be read directly from the database file,
139 bypassing the <a href="../c3ref/pcache_methods2.html">page cache</a>.
140 <li>Remove limits on the magnitude of precision and width value in the
141 format specifiers of the <a href="../c3ref/mprintf.html">sqlite3_mprintf()</a> family of string rendering
142 routines.
143 <li>Fix a bug that prevent <a href="../lang_altertable.html">ALTER TABLE ... RENAME</a> from working
144 on some virtual tables in a database with a UTF16 encoding.
145 <li>Fix a bug in ASCII-to-float conversion that causes slow performance and
146 incorrect results when converting numbers with ridiculously large exponents.
147 <li>Fix a bug that causes incorrect results in aggregate queries that use
148 multiple aggregate functions whose arguments contain complicated expressions
149 that differ only in the case of string literals contained within those
150 expressions.
151 <li>Fix a bug that prevented the <a href="../pragma.html#pragma_page_count">page_count</a> and <a href="../pragma.html#pragma_quick_check">quick_check</a> pragmas from
152 working correctly if their names were capitalized.
153 <li>Fix a bug that caused <a href="../lang_vacuum.html">VACUUM</a> to fail if the <a href="../pragma.html#pragma_count_changes">count_changes pragma</a> was
154 engaged.
155 <li>Fix a bug in <a href="../vtab.html">virtual table</a> implementation that causes a crash if
156 an <a href="../fts3.html#fts4">FTS4</a> table is <a href="../lang_droptable.html">dropped</a> inside a transaction and
157 a <a href="../lang_savepoint.html">SAVEPOINT</a> occurs afterwards.
158 <li>SQLITE_SOURCE_ID:
159 "2011-11-01 00:52:41 c7c6050ef060877ebe77b41d959e9df13f8c9b5e"
160 <li>SHA1 for sqlite3.c: becd16877f4f9b281b91c97e106089497d71bb47
161
162 </ol></p>
163
164 <p>A <a href="../changes.html">complete list of SQLite releases</a>
165 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
166 A detailed history of every
167 check-in is available at
168 <a href="https://sqlite.org/src/timeline">
169 SQLite version control site</a>.</p>
170
171