Debian Codegraph @

www/releaselog/3_4_0.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.4.0 On 2007-06-18</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.4.0 On 2007-06-18</h2><p><ol class='lessindent'>
119 <li>Fix a bug that can lead to database corruption if an <a href="../rescode.html#busy">SQLITE_BUSY</a> error
120 occurs in the middle of an explicit transaction and that transaction
121 is later committed. Ticket #2409.
122 <li>Fix a bug that can lead to database corruption if autovacuum mode is
123 on and a malloc() failure follows a CREATE TABLE or CREATE INDEX statement
124 which itself follows a cache overflow inside a transaction. See
125 ticket #2418.
126 </li>
127 <li>Added explicit <a href="../limits.html">upper bounds</a> on the sizes and
128 quantities of things SQLite can process. This change might cause
129 compatibility problems for
130 applications that use SQLite in the extreme, which is why the current
131 release is 3.4.0 instead of 3.3.18.</li>
132 <li>Added support for <a href="../c3ref/blob_open.html">Incremental BLOB I/O</a>.</li>
133 <li>Added the <a href="../c3ref/bind_blob.html">sqlite3_bind_zeroblob()</a> API</a>
134 and the <a href="../lang_corefunc.html#zeroblob">zeroblob()</a> SQL function.</li>
135 <li>Added support for <a href="../pragma.html#pragma_incremental_vacuum">
136 Incremental Vacuum</a>.</li>
137 <li>Added the SQLITE_MIXED_ENDIAN_64BIT_FLOAT compile-time option to support
138 ARM7 processors with goofy endianness.</li>
139 <li>Removed all instances of sprintf() and strcpy() from the core library.</li>
140 <li>Added support for
141 <a href="https://icu.unicode.org">International Components for Unicode (ICU)</a>
142 to the full-text search extensions.
143 <li>In the Windows OS driver, reacquire a SHARED lock if an attempt to
144 acquire an EXCLUSIVE lock fails. Ticket #2354</li>
145 <li>Fix the REPLACE() function so that it returns NULL if the second argument
146 is an empty string. Ticket #2324.</li>
147 <li>Document the hazards of type conversions in
148 <a href="../c3ref/column_blob.html">sqlite3_column_blob()</a>
149 and related APIs. Fix unnecessary type conversions. Ticket #2321.</li>
150 <li>Internationalization of the TRIM() function. Ticket #2323</li>
151 <li>Use memmove() instead of memcpy() when moving between memory regions
152 that might overlap. Ticket #2334</li>
153 <li>Fix an optimizer bug involving subqueries in a compound SELECT that has
154 both an ORDER BY and a LIMIT clause. Ticket #2339.</li>
155 <li>Make sure the <a href="../c3ref/mprintf.html">sqlite3_snprintf()</a>
156 interface does not zero-terminate the buffer if the buffer size is
157 less than 1. Ticket #2341</li>
158 <li>Fix the built-in printf logic so that it prints "NaN" not "Inf" for
159 floating-point NaNs. Ticket #2345</li>
160 <li>When converting BLOB to TEXT, use the text encoding of the main database.
161 Ticket #2349</li>
162 <li>Keep the full precision of integers (if possible) when casting to
163 NUMERIC. Ticket #2364</li>
164 <li>Fix a bug in the handling of UTF16 codepoint 0xE000</li>
165 <li>Consider explicit collate clauses when matching WHERE constraints
166 to indices in the query optimizer. Ticket #2391</li>
167 <li>Fix the query optimizer to correctly handle constant expressions in
168 the ON clause of a LEFT JOIN. Ticket #2403</li>
169 <li>Fix the query optimizer to handle rowid comparisons to NULL
170 correctly. Ticket #2404</li>
171 <li>Fix many potential segfaults that could be caused by malicious SQL
172 statements.</li>
173
174 </ol></p>
175
176 <p>A <a href="../changes.html">complete list of SQLite releases</a>
177 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
178 A detailed history of every
179 check-in is available at
180 <a href="https://sqlite.org/src/timeline">
181 SQLite version control site</a>.</p>
182
183