1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
3
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
4
<title>SQLite Release 3.7.12 On 2012 May 14 (3.7.12)</title>
5
<style type="text/css">
8
font-family: Verdana, sans-serif;
13
a:visited { color: #734559 }
15
.logo { position:absolute; margin:3px; }
31
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
32
.toolbar a:visited { color: white; }
33
.toolbar a:hover { color: #044a64; background: white; }
35
.content { margin: 5%; }
36
.content dt { font-weight:bold; }
37
.content dd { margin-bottom: 25px; margin-left:20%; }
38
.content ul { padding:0px; padding-left: 15px; margin:0px; }
41
.se { background: url(../images/se.gif) 100% 100% no-repeat #044a64}
42
.sw { background: url(../images/sw.gif) 0% 100% no-repeat }
43
.ne { background: url(../images/ne.gif) 100% 0% no-repeat }
44
.nw { background: url(../images/nw.gif) 0% 0% no-repeat }
46
/* Things for "fancyformat" documents start here. */
47
.fancy img+p {font-style:italic}
48
.fancy .codeblock i { color: darkblue; }
49
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
50
.fancy h2 { margin-left: 10px }
51
.fancy h3 { margin-left: 20px }
52
.fancy h4 { margin-left: 30px }
53
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
54
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
55
.fancy #toc a { color: darkblue ; text-decoration: none }
56
.fancy .todo { color: #AA3333 ; font-style : italic }
57
.fancy .todo:before { content: 'TODO:' }
58
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
59
.fancy img { display:block; }
60
.fancy :link:hover, .fancy :visited:hover { background: wheat }
61
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
62
.fancy li p { margin: 1em 0 }
63
/* End of "fancyformat" specific rules. */
69
<div><!-- container div to satisfy validator -->
71
<a href="../index.html">
72
<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite Logo"
74
<div><!-- IE hack to prevent disappearing logo--></div>
75
<div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
77
<table width=100% style="clear:both"><tr><td>
78
<div class="se"><div class="sw"><div class="ne"><div class="nw">
79
<table width=100% style="padding:0;margin:0;cell-spacing:0"><tr>
82
<a href="../about.html">About</a>
83
<a href="../sitemap.html">Sitemap</a>
84
<a href="../docs.html">Documentation</a>
85
<a href="../download.html">Download</a>
86
<a href="../copyright.html">License</a>
87
<a href="../news.html">News</a>
88
<a href="../support.html">Support</a>
91
gMsg = "Search SQLite Docs..."
92
function entersearch() {
93
var q = document.getElementById("q");
94
if( q.value == gMsg ) { q.value = "" }
95
q.style.color = "black"
96
q.style.fontStyle = "normal"
98
function leavesearch() {
99
var q = document.getElementById("q");
100
if( q.value == "" ) {
102
q.style.color = "#044a64"
103
q.style.fontStyle = "italic"
108
<div style="padding:0 1em 0px 0;white-space:nowrap">
109
<form name=f method="GET" action="http://www.sqlite.org/search">
110
<input id=q name=q type=text
111
onfocus="entersearch()" onblur="leavesearch()" style="width:24ex;padding:1px 1ex; border:solid white 1px; font-size:0.9em ; font-style:italic;color:#044a64;" value="Search SQLite Docs...">
112
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
116
</div></div></div></div>
118
<div class=startsearch></div>
120
<h2>SQLite Release 3.7.12 On 2012 May 14 (3.7.12)</h2><p><ul>
121
<li>Add the <a href="../c3ref/c_dbstatus_options.html#sqlitedbstatuscachewrite">SQLITE_DBSTATUS_CACHE_WRITE</a> option for <a href="../c3ref/db_status.html">sqlite3_db_status()</a>.
122
<li>Optimize the <a href="../lang_corefunc.html#typeof">typeof()</a> and <a href="../lang_corefunc.html#length">length()</a> SQL functions so that they avoid
123
unnecessary reading of database content from disk.
124
<li>Add the <a href="../fts3.html#*fts4mergecmd">FTS4 "merge" command</a>, the <a href="../fts3.html#*fts4automergecmd">FTS4 "automerge" command</a>, and
125
the <a href="../fts3.html#*fts4ickcmd">FTS4 "integrity-check" command</a>.
126
<li>Report the name of specific <a href="../lang_createtable.html#ckconst">CHECK</a> constraints that fail.
127
<li>In the command-line shell, use popen() instead of fopen() if the first
128
character of the argument to the ".output" command is "|".
129
<li>Make use of OVERLAPPED in the windows <a href="../vfs.html">VFS</a> to avoid some system calls
130
and thereby obtain a performance improvement.
131
<li>More aggressive optimization of the AND operator when one side or the
132
other is always false.
133
<li>Improved performance of queries with many OR-connected terms in the
134
WHERE clause that can all be indexed.
135
<li>Add the <a href="../compile.html#rtree_int_only">SQLITE_RTREE_INT_ONLY</a> compile-time option to force the
136
<a href="../rtree.html">R*Tree Extension Module</a> to use integer instead of
137
floating point values for both storage and computation.
138
<li>Enhance the <a href="../pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> command to use much less memory when
139
processing multi-gigabyte databases.
140
<li>New interfaces added to the test_quota.c add-on module.
141
<li>Added the ".trace" dot-command to the command-line shell.
142
<li>Allow virtual table constructors to be invoked recursively.
143
<li>Improved optimization of ORDER BY clauses on compound queries.
144
<li>Improved optimization of aggregate subqueries contained within an
146
<li>Bug fix: Fix the <a href="../lang_savepoint.html">RELEASE</a> command so that it does not cancel pending
147
queries. This repairs a problem introduced in 3.7.11.
148
<li>Bug fix: Do not discard the DISTINCT as superfluous unless a subset of
149
the result set is subject to a UNIQUE constraint <em>and</em> it none
150
of the columns in that subset can be NULL.
151
Ticket <a href="http://www.sqlite.org/src/info/385a5b56b9">385a5b56b9</a>.
152
<li>Bug fix: Do not optimize away an ORDER BY clause that has the same terms
153
as a UNIQUE index unless those terms are also NOT NULL.
154
Ticket <a href="http://www.sqlite.org/src/info/2a5629202f">2a5629202f</a>.
155
<li>SQLITE_SOURCE_ID:
156
"2012-05-14 01:41:23 8654aa9540fe9fd210899d83d17f3f407096c004"
157
<li>SHA1 for sqlite3.c: 57e2104a0f7b3f528e7f6b7a8e553e2357ccd2e1
160
<p>A <a href="../changes.html">complete list of SQLite releases</a>
161
in a single page is also available. A detailed history of every
162
check-in is available at
163
<a href="http://www.sqlite.org/src/timeline">
164
http://www.sqlite.org/src/timeline</a>.</p>