📄 changes.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html><head><title>SQLite changes</title><style type="text/css">body { margin: auto; font-family: "Verdana" "sans-serif"; padding: 8px 1%;}a { color: #45735f }a:visited { color: #734559 }.logo { position:absolute; margin:3px; }.tagline { float:right; text-align:right; font-style:italic; width:240px; margin:12px; margin-top:58px;}.toolbar { font-variant: small-caps; text-align: center; line-height: 1.6em; margin: 0; padding:1px 8px;}.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }.toolbar a:visited { color: white; }.toolbar a:hover { color: #80a796; background: white; }.content { margin: 5%; }.content dt { font-weight:bold; }.content dd { margin-bottom: 25px; margin-left:20%; }.content ul { padding:0px; padding-left: 15px; margin:0px; }/* rounded corners */.se { background: url(images/se.png) 100% 100% no-repeat #80a796}.sw { background: url(images/sw.png) 0% 100% no-repeat }.ne { background: url(images/ne.png) 100% 0% no-repeat }.nw { background: url(images/nw.png) 0% 0% no-repeat }</style><meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head><body><div><!-- container div to satisfy validator --><a href="index.html"><img class="logo" src="images/SQLite.gif" alt="SQLite Logo" border="0"></a><div><!-- IE hack to prevent disappearing logo--></div><div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div><table width=100% style="clear:both"><tr><td> <div class="se"><div class="sw"><div class="ne"><div class="nw"> <div class="toolbar"> <a href="about.html">About</a> <a href="sitemap.html">Sitemap</a> <a href="docs.html">Documentation</a> <a href="download.html">Download</a> <a href="copyright.html">License</a> <a href="news.html">News</a> <a href="http://www.sqlite.org/cvstrac/index">Developers</a> <a href="support.html">Support</a> </div></div></div></div></div></td></tr></table> <?xml version="1.0" encoding="Windows-1252"?><p>This page provides a high-level summary of changes to SQLite.For more detail, refer the the checkin logs generated byCVS at<a href="http://www.sqlite.org/cvstrac/timeline">http://www.sqlite.org/cvstrac/timeline</a>.</p><a name="version_3_6_10"></a><h3>2009 Jan 15 (3.6.10)</h3><p><ul><li>Fix a cache coherency problem that could lead to database corruption. <a href="http://www.sqlite.org/cvstrac/tktview?tn=3584">Ticket #3584</a>.</ul></p><a name="version_3_6_9"></a><h3>2009 Jan 14 (3.6.9)</h3><p><ul><li>Fix two bugs, which when combined might result in incorrect query results. Both bugs were harmless by themselves; only when they team up do they cause problems. <a href="http://www.sqlite.org/cvstrac/tktview?tn=3581">Ticket #3581</a>.</ul></p><a name="version_3_6_8"></a><h3>2009 Jan 12 (3.6.8)</h3><p><ul><li>Added support for <a href="lang_savepoint.html">nested transactions</a></li><li>Enhanced the query optimizer so that it is able to use multiple indices to efficiently process <a href="optoverview.html#or_opt">OR-connected constraints</a> in a WHERE clause.</li><li>Added support for parentheses in FTS3 query patterns using the <a href="compile.html#enable_fts3_parenthesis">SQLITE_ENABLE_FTS3_PARENTHESIS</a> compile-time option.</li></ul></p><a name="version_3_6_7"></a><h3>2008 Dec 16 (3.6.7)</h3><p><ul><li>Reorganize the Unix interface in os_unix.c</li><li>Added support for "Proxy Locking" on MacOSX.</li><li>Changed the prototype of the <a href="c3ref/auto_extension.html">sqlite3_auto_extension()</a> interface in a way that is backwards compatible but which might cause warnings in new builds of applications that use that interface.</li><li>Changed the signature of the xDlSym method of the <a href="c3ref/vfs.html">sqlite3_vfs</a> object in a way that is backwards compatible but which might cause compiler warnings.</li><li>Added superfluous casts and variable initializations in order to suppress nuisance compiler warnings.</li><li>Fixes for various minor bugs.</li></ul></p><a name="version_3_6_6_2"></a><h3>2008 Nov 26 (3.6.6.2)</h3><p><ul><li>Fix a bug in the b-tree delete algorithm that seems like it might be able to cause database corruption. The bug was first introduced in <a href="#version_3_6_6">version 3.6.6</a> by check-in [5899] on 2008-11-13.</li><li>Fix a memory leak that can occur following a disk I/O error.</li></ul></p><a name="version_3_6_6_1"></a><h3>2008 Nov 22 (3.6.6.1)</h3><p><ul><li>Fix a bug in the page cache that can lead database corruption following a rollback. This bug was first introduced in <a href="#version_3_6_4">version 3.6.4</a>.</li><li>Two other very minor bug fixes</li></ul></p><a name="version_3_6_6"></a><h3>2008 Nov 19 (3.6.6)</h3><p><ul><li>Fix a #define that prevented <a href="malloc.html#memsys5">memsys5</a> from compiling</li><li>Fix a problem in the virtual table commit mechanism that was causing a crash in FTS3. <a href="http://www.sqlite.org/cvstrac/tktview?tn=3497">Ticket #3497</a>.</li><li>Add the <a href="c3ref/pcache_methods.html">application-defined page cache</a></li><li>Added built-in support for VxWorks</li></ul></p><a name="version_3_6_5"></a><h3>2008 Nov 12 (3.6.5)</h3><p><ul><li>Add the MEMORY option to the <a href="pragma.html#pragma_journal_mode">journal_mode pragma</a>.</li><li>Added the <a href="c3ref/db_mutex.html">sqlite3_db_mutex()</a> interface.</li><li>Added the <a href="compile.html#omit_truncate_optimization">SQLITE_OMIT_TRUNCATE_OPTIMIZATION</a> compile-time option.</li><li>Fixed the <a href="lang_delete.html#trucateopt">truncate optimization</a> so that <a href="c3ref/changes.html">sqlite3_changes()</a> and <a href="c3ref/total_changes.html">sqlite3_total_changes()</a> interfaces and the <a href="pragma.html#pragma_count_changes">count_changes pragma</a> return the correct values.</li><li>Added the <a href="c3ref/errcode.html">sqlite3_extended_errcode()</a> interface.</li><li>The <a href="lang_transaction.html">COMMIT</a> command now succeeds even if there are pending queries. It returns <a href="c3ref/c_abort.html">SQLITE_BUSY</a> if there are pending incremental BLOB I/O requests.<li>The error code is changed to <a href="c3ref/c_abort.html">SQLITE_BUSY</a> (instead of <a href="c3ref/c_abort.html">SQLITE_ERROR</a>) when an attempt is made to <a href="lang_transaction.html">ROLLBACK</a> while one or more queries are still pending.</li><li>Drop all support for the <a href="malloc.html#memsysx">experimental memory allocators</a> memsys4 and memsys6.</li><li>Added the <a href="compile.html#zero_malloc">SQLITE_ZERO_MALLOC</a> compile-time option.</li></ul></p><a name="version_3_6_4"></a><h3>2008 Oct 15 (3.6.4)</h3><p><ul><li>Add option support for LIMIT and ORDER BY clauses on <a href="lang_delete.html">DELETE</a> and <a href="lang_update.html">UPDATE</a> statements. Only works if SQLite is compiled with <a href="compile.html#enable_update_delete_limit">SQLITE_ENABLE_UPDATE_DELETE_LIMIT</a>.<li>Added the <a href="c3ref/stmt_status.html">sqlite3_stmt_status()</a> interface for performance monitoring.</li><li>Add the <a href="lang_indexedby.html">INDEXED BY</a> clause.</li><li>The LOCKING_STYLE extension is now enabled by default on Mac OS X</li><li>Added the TRUNCATE option to <a href="pragma.html#pragma_journal_mode">PRAGMA journal_mode</a></li><li>Performance enhancements to tree balancing logic in the B-Tree layer.</li><li>Added the <a href="http://www.sqlite.org/cvstrac/fileview?f=sqlite/tool/genfkey.c"> source code</a> and <a href="http://www.sqlite.org/cvstrac/fileview?f=sqlite/tool/genfkey.README"> documentation</a> for the <b>genfkey</b> program for automatically generating triggers to enforce foreign key constraints.</li><li>Added the <a href="compile.html#omit_truncate_optimization">SQLITE_OMIT_TRUNCATE_OPTIMIZATION</a> compile-time option.</li><li>The <a href="lang.html">SQL language documentation</a> is converted to use <a href="syntaxdiagrams.html">syntax diagrams</a> instead of BNF.</li><li>Other minor bug fixes</li></ul></p><a name="version_3_6_3"></a><h3>2008 Sep 22 (3.6.3)</h3><p><ul><li>Fix for a bug in the SELECT DISTINCT logic that was introduced by the prior version.</li><li>Other minor bug fixes</li></ul></p><a name="version_3_6_2"></a><h3>2008 Aug 30 (3.6.2)</h3><p><ul><li>Split the pager subsystem into separate pager and pcache subsystems.</li><li>Factor out indentifier resolution procedures into separate files.</li><li>Bug fixes</li></ul></p><a name="version_3_6_1"></a><h3>2008 Aug 6 (3.6.1)</h3><p><ul><li>Added the <a href="malloc.html#lookaside">lookaside memory allocator</a> for a speed improvement in excess of 15% on some workloads. (Your mileage may vary.)</li><li>Added the <a href="c3ref/c_config_getmalloc.html">SQLITE_CONFIG_LOOKASIDE</a> verb to <a href="c3ref/config.html">sqlite3_config()</a> to control the default lookaside configuration.</li><li>Added verbs <a href="c3ref/c_status_malloc_size.html">SQLITE_STATUS_PAGECACHE_SIZE</a> and <a href="c3ref/c_status_malloc_size.html">SQLITE_STATUS_SCRATCH_SIZE</a> to the <a href="c3ref/status.html">sqlite3_status()</a> interface.<li>Modified <a href="c3ref/c_config_getmalloc.html">SQLITE_CONFIG_PAGECACHE</a> and <a href="c3ref/c_config_getmalloc.html">SQLITE_CONFIG_SCRATCH</a> to remove the "+4" magic number in the buffer size computation.<li>Added the <a href="c3ref/db_config.html">sqlite3_db_config()</a> and <a href="c3ref/db_status.html">sqlite3_db_status()</a> interfaces for controlling and monitoring the lookaside allocator separately on each <a href="c3ref/sqlite3.html">database connection</a>.</li><li>Numerious other performance enhancements</li><li>Miscellaneous minor bug fixes</li></ul></p><h3>2008 July 16 (3.6.0 beta)</h3><p><ul><li>Modifications to the <a href="c3ref/vfs.html">virtual file system</a> interface to support a wider range of embedded systems. See <a href="35to36.html">35to36.html</a> for additional information. <font color="red">*** Potentially incompatible change ***</font></li><li>All C-preprocessor macros used to control compile-time options now begin with the prefix "SQLITE_". This may require changes to applications that compile SQLite using their own makefiles and with custom compile-time options, hence we mark this as a <font color="red">*** Potentially incompatible change ***</font></li><li>The SQLITE_MUTEX_APPDEF compile-time option is no longer supported. Alternative mutex implementations can now be added at run-time using the <a href="c3ref/config.html">sqlite3_config()</a> interface with the <a href="c3ref/c_config_getmalloc.html">SQLITE_CONFIG_MUTEX</a> verb. <font color="red">*** Potentially incompatible change ***</font></li><li>The handling of IN and NOT IN operators that contain a NULL on their right-hand side expression is brought into compliance with the SQL standard and with other SQL database engines. This is a bug fix, but as it has the potential to break legacy applications that depend on the older buggy behavior, we mark that as a <font color="red">*** Potentially incompatible change ***</font></li><li>The result column names generated for compound subqueries have been simplified to show only the name of the column of the original table and omit the table name. This makes SQLite operate more like other SQL database engines.</li><li>Added the <a href="c3ref/config.html">sqlite3_config()</a> interface for doing run-time configuration of the entire SQLite library.</li><li>Added the <a href="c3ref/status.html">sqlite3_status()</a> interface used for querying run-time status information about the overall SQLite library and its subsystems.</li><li>Added the <a href="c3ref/initialize.html">sqlite3_initialize()</a> and <a href="c3ref/initialize.html">sqlite3_shutdown()</a> interfaces.</li><li>The <a href="c3ref/c_open_create.html">SQLITE_OPEN_NOMUTEX</a> option was added to <a href="c3ref/open.html">sqlite3_open_v2()</a>.</li><li>Added the <a href="pragma.html#pragma_page_count">PRAGMA page_count</a> command.</li><li>Added the <a href="c3ref/next_stmt.html">sqlite3_next_stmt()</a> interface.</li><li>Added a new <a href="rtree.html">R*Tree virtual table</a></li></ul></p><a name="version_3_5_9"></a><h3>2008 May 14 (3.5.9)</h3><p><ul><li>Added <em>experimental</em> support for the <a href="pragma.html#pragma_journal_mode">journal_mode</a> PRAGMA and persistent journal.</li><li><a href="pragma.html#pragma_journal_mode">Journal mode PERSIST</a> is the default behavior in <a href="pragma.html#pragma_locking_mode">exclusive locking mode</a>.</li><li>Fix a performance regression on LEFT JOIN (see <a href="http://www.sqlite.org/cvstrac/tktview?tn=3015">ticket #3015</a>) that was mistakenly introduced in <a href="#version_3_5_8">version 3.5.8</a>.</li><li>Performance enhancement: Reengineer the internal routines used⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -