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.6.0 On 2008 July 16 (3.6.0 beta)</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.6.0 On 2008 July 16 (3.6.0 beta)</h2><p><ul>
121
<li>Modifications to the <a href="../c3ref/vfs.html">virtual file system</a> interface
122
to support a wider range of embedded systems.
123
See <a href="../35to36.html">35to36.html</a> for additional information.
124
<font color="red">*** Potentially incompatible change ***</font></li>
125
<li>All C-preprocessor macros used to control compile-time options
126
now begin with the prefix "SQLITE_". This may require changes to
127
applications that compile SQLite using their own makefiles and with
128
custom compile-time options, hence we mark this as a
129
<font color="red">*** Potentially incompatible change ***</font></li>
130
<li>The SQLITE_MUTEX_APPDEF compile-time option is no longer supported.
131
Alternative mutex implementations can now be added at run-time using
132
the <a href="../c3ref/config.html">sqlite3_config()</a> interface with the <a href="../c3ref/c_config_getmalloc.html#sqliteconfigmutex">SQLITE_CONFIG_MUTEX</a> verb.
133
<font color="red">*** Potentially incompatible change ***</font></li>
134
<li>The handling of IN and NOT IN operators that contain a NULL on their
135
right-hand side expression is brought into compliance with the SQL
136
standard and with other SQL database engines. This is a bug fix,
137
but as it has the potential to break legacy applications that depend
138
on the older buggy behavior, we mark that as a
139
<font color="red">*** Potentially incompatible change ***</font></li>
140
<li>The result column names generated for compound subqueries have been
141
simplified to show only the name of the column of the original table and
142
omit the table name. This makes SQLite operate more like other SQL
143
database engines.</li>
144
<li>Added the <a href="../c3ref/config.html">sqlite3_config()</a> interface for doing run-time configuration
145
of the entire SQLite library.</li>
146
<li>Added the <a href="../c3ref/status.html">sqlite3_status()</a> interface used for querying run-time status
147
information about the overall SQLite library and its subsystems.</li>
148
<li>Added the <a href="../c3ref/initialize.html">sqlite3_initialize()</a> and <a href="../c3ref/initialize.html">sqlite3_shutdown()</a> interfaces.</li>
149
<li>The <a href="../c3ref/c_open_autoproxy.html">SQLITE_OPEN_NOMUTEX</a> option was added to <a href="../c3ref/open.html">sqlite3_open_v2()</a>.</li>
150
<li>Added the <a href="../pragma.html#pragma_page_count">PRAGMA page_count</a> command.</li>
151
<li>Added the <a href="../c3ref/next_stmt.html">sqlite3_next_stmt()</a> interface.</li>
152
<li>Added a new <a href="../rtree.html">R*Tree virtual table</a></li>
154
<p>A <a href="../changes.html">complete list of SQLite releases</a>
155
in a single page is also available. A detailed history of every
156
check-in is available at
157
<a href="http://www.sqlite.org/src/timeline">
158
http://www.sqlite.org/src/timeline</a>.</p>