Debian Codegraph @

www/releaselog/3_8_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.8.0 On 2013-08-26</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.8.0 On 2013-08-26</h2><p><ol class='lessindent'>
119 <li>Add support for <a href="../partialindex.html">partial indexes</a></li>
120 <li>Cut-over to the <a href="../queryplanner-ng.html">next generation query planner</a> for faster and better query plans.
121 <li>The <a href="../eqp.html">EXPLAIN QUERY PLAN</a> output no longer shows an estimate of the number of
122 rows generated by each loop in a join.
123 <li>Added the <a href="../fts3.html#fts4notindexed">FTS4 notindexed option</a>, allowing non-indexed columns in an FTS4 table.
124 <li>Added the <a href="../c3ref/c_stmtstatus_counter.html#sqlitestmtstatusvmstep">SQLITE_STMTSTATUS_VM_STEP</a> option to <a href="../c3ref/stmt_status.html">sqlite3_stmt_status()</a>.
125 <li>Added the <a href="../pragma.html#pragma_cache_spill">cache_spill pragma</a>.
126 <li>Added the <a href="../pragma.html#pragma_query_only">query_only pragma</a>.
127 <li>Added the <a href="../pragma.html#pragma_defer_foreign_keys">defer_foreign_keys pragma</a> and the
128 <a href="../c3ref/db_status.html">sqlite3_db_status</a>(db, <a href="../c3ref/c_dbstatus_options.html#sqlitedbstatusdeferredfks">SQLITE_DBSTATUS_DEFERRED_FKS</a>,...) C-language interface.
129 <li>Added the "percentile()" function as a <a href="../loadext.html">loadable extension</a> in the ext/misc
130 subdirectory of the source tree.
131 <li>Added the <a href="../compile.html#allow_uri_authority">SQLITE_ALLOW_URI_AUTHORITY</a> compile-time option.
132 <li>Add the <a href="../c3ref/cancel_auto_extension.html">sqlite3_cancel_auto_extension(X)</a> interface.
133 <li>A running SELECT statement that lacks a FROM clause (or any other statement that
134 never reads or writes from any database file) will not prevent a read
135 transaction from closing.
136 <li>Add the <a href="../compile.html#default_automatic_index">SQLITE_DEFAULT_AUTOMATIC_INDEX</a> compile-time option. Setting this option
137 to 0 disables automatic indices by default.
138 <li>Issue an <a href="../rescode.html#warning_autoindex">SQLITE_WARNING_AUTOINDEX</a> warning on the <a href="../c3ref/c_config_covering_index_scan.html#sqliteconfiglog">SQLITE_CONFIG_LOG</a> whenever
139 the query planner uses an automatic index.
140 <li>Added the <a href="../compile.html#fts3_max_expr_depth">SQLITE_FTS3_MAX_EXPR_DEPTH</a> compile-time option.
141 <li>Added an optional 5th parameter defining the collating sequence to the
142 next_char() extension SQL function.
143 <li>The <a href="../rescode.html#busy_snapshot">SQLITE_BUSY_SNAPSHOT</a> extended error code is returned in WAL mode when
144 a read transaction cannot be upgraded to a write transaction because the read is
145 on an older snapshot.
146 <li>Enhancements to the sqlite3_analyzer utility program to provide size
147 information separately for each individual index of a table, in addition to
148 the aggregate size.
149 <li>Allow read transactions to be freely opened and closed by SQL statements run
150 from within the implementation of <a href="../appfunc.html">application-defined SQL functions</a> if the
151 function is called by a SELECT statement that does not access any database table.
152 <li>Disable the use of posix_fallocate() on all (unix) systems unless the
153 HAVE_POSIX_FALLOCATE compile-time option is used.
154 <li>Update the ".import" command in the <a href="../cli.html">command-line shell</a> to support multi-line
155 fields and correct RFC-4180 quoting and to issue warning and/or error messages
156 if the input text is not strictly RFC-4180 compliant.
157 <li>Bug fix: In the <a href="../fts3.html#unicode61">unicode61</a> tokenizer of <a href="../fts3.html#fts4">FTS4</a>, treat all private code points
158 as identifier symbols.
159 <li>Bug fix: Bare identifiers in ORDER BY clauses bind more tightly to output column
160 names, but identifiers in expressions bind more tightly to input column names.
161 Identifiers in GROUP BY clauses always prefer output column names, however.
162 <li>Bug fixes: Multiple problems in the legacy query optimizer were fixed by the
163 move to <a href="../queryplanner-ng.html">NGQP</a>.
164
165 <li>SQLITE_SOURCE_ID:
166 "2013-08-26 04:50:08 f64cd21e2e23ed7cff48f7dafa5e76adde9321c2"
167 <li>SHA1 for sqlite3.c: b7347f4b4c2a840e6ba12040093d606bd16ea21e
168
169 </ol></p>
170
171 <p>A <a href="../changes.html">complete list of SQLite releases</a>
172 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
173 A detailed history of every
174 check-in is available at
175 <a href="https://sqlite.org/src/timeline">
176 SQLite version control site</a>.</p>
177
178