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.10 On 2012 January 16 (3.7.10)</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.10 On 2012 January 16 (3.7.10)</h2><p><ul>
121
<li>The default <a href="../fileformat2.html#schemaformat">schema format number</a> is changed from 1 to 4.
122
This means that, unless
123
the <a href="../pragma.html#pragma_legacy_file_format">PRAGMA legacy_file_format=ON</a> statement is
124
run, newly created database files will be unreadable by version of SQLite
125
prior to 3.3.0 (2006-01-10). It also means that the <a href="../lang_createindex.html#descidx">descending indices</a>
126
are enabled by default.
127
<li>The sqlite3_pcache_methods structure and the <a href="../c3ref/c_config_getmalloc.html#sqliteconfigpcache">SQLITE_CONFIG_PCACHE</a>
128
and <a href="../c3ref/c_config_getmalloc.html#sqliteconfiggetpcache">SQLITE_CONFIG_GETPCACHE</a> configuration parameters are deprecated.
129
They are replaced by a new <a href="../c3ref/pcache_methods2.html">sqlite3_pcache_methods2</a> structure and
130
<a href="../c3ref/c_config_getmalloc.html#sqliteconfigpcache2">SQLITE_CONFIG_PCACHE2</a> and <a href="../c3ref/c_config_getmalloc.html#sqliteconfiggetpcache2">SQLITE_CONFIG_GETPCACHE2</a> configuration
132
<li>Added the <a href="../psow.html">powersafe overwrite</a> property to the VFS interface. Provide
133
the <a href="../c3ref/c_iocap_atomic.html">SQLITE_IOCAP_POWERSAFE_OVERWRITE</a> I/O capability, the
134
<a href="../compile.html#powersafe_overwrite">SQLITE_POWERSAFE_OVERWRITE</a> compile-time option, and the
135
"psow=BOOLEAN" query parameter for <a href="../uri.html">URI filenames</a>.
136
<li>Added the <a href="../c3ref/db_release_memory.html">sqlite3_db_release_memory()</a> interface and the
137
<a href="../pragma.html#pragma_shrink_memory">shrink_memory pragma</a>.
138
<li>Added the <a href="../c3ref/db_filename.html">sqlite3_db_filename()</a> interface.
139
<li>Added the <a href="../c3ref/stmt_busy.html">sqlite3_stmt_busy()</a> interface.
140
<li>Added the <a href="../c3ref/uri_boolean.html">sqlite3_uri_boolean()</a> and <a href="../c3ref/uri_boolean.html">sqlite3_uri_int64()</a> interfaces.
141
<li>If the argument to <a href="../pragma.html#pragma_cache_size">PRAGMA cache_size</a> is negative N, that means to use
142
approximately -1024*N bytes of memory for the page cache regardless of
144
<li>Enhanced the default memory allocator to make use of _msize() on windows,
145
malloc_size() on Mac, and malloc_usable_size() on Linux.
146
<li>Enhanced the query planner to support index queries with range constraints
148
<li>Enhanced the query planner flattening logic to allow UNION ALL compounds
149
to be promoted upwards to replace a simple wrapper SELECT even if the
151
<li>Enhanced the query planner so that the xfer optimization can be used with
152
INTEGER PRIMARY KEY ON CONFLICT as long as the destination table is
154
<li>Enhanced the windows <a href="../vfs.html">VFS</a> so that all system calls can be overridden
155
using the xSetSystemCall interface.
156
<li>Updated the "unix-dotfile" <a href="../vfs.html">VFS</a> to use locking directories with mkdir()
157
and rmdir() instead of locking files with open() and unlink().
158
<li>Enhancements to the test_quota.c extension to support stdio-like interfaces
160
<li>Change the unix <a href="../vfs.html">VFS</a> to be tolerant of read() system calls that return
161
less then the full number of requested bytes.
162
<li>Change both unix and windows <a href="../vfs.html">VFSes</a> to report a sector size of 4096
163
instead of the old default of 512.
164
<li>In the <a href="../tclsqlite.html">TCL Interface</a>, add the -uri option to the "sqlite3" TCL command
165
used for creating new database connection objects.
166
<li>Added the <a href="../c3ref/c_testctrl_always.html">SQLITE_TESTCTRL_EXPLAIN_STMT</a> test-control option with the
167
<a href="../compile.html#enable_tree_explain">SQLITE_ENABLE_TREE_EXPLAIN</a> compile-time option to enable the
168
<a href="../sqlite.html">command-line shell</a> to display ASCII-art parse trees of SQL statements
169
that it processes, for debugging and analysis.
171
Add an additional xSync when restarting a WAL in order to prevent an
172
exceedingly unlikely but theoretically possible
173
database corruption following power-loss.
174
Ticket <a href="http://www.sqlite.org/src/info/ff5be73dee">ff5be73dee</a>.
176
Change the VDBE so that all registers are initialized to Invalid
178
Ticket <a href="http://www.sqlite.org/src/info/7bbfb7d442">7bbfb7d442</a>
180
Fix problems that can result from 32-bit integer overflow.
181
Ticket <a href="http://www.sqlite.org/src/info/ac0ff496b7e2">ac00f496b7e2</a>
182
<li>SQLITE_SOURCE_ID:
183
"2012-01-16 13:28:40 ebd01a8deffb5024a5d7494eef800d2366d97204"
184
<li>SHA1 for sqlite3.c: 6497cbbaad47220bd41e2e4216c54706e7ae95d4
186
<p>A <a href="../changes.html">complete list of SQLite releases</a>
187
in a single page is also available. A detailed history of every
188
check-in is available at
189
<a href="http://www.sqlite.org/src/timeline">
190
http://www.sqlite.org/src/timeline</a>.</p>