📄 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_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 to interpret and render variable-length integers.</li><li>Fix a buffer-overrun problem in <a href="c3ref/mprintf.html">sqlite3_mprintf()</a> which occurs when a string without a zero-terminator is passed to "%.*s".</li><li>Always convert IEEE floating point NaN values into NULL during processing. (<a href="http://www.sqlite.org/cvstrac/tktview?tn=3060">Ticket #3060</a>)</li><li>Make sure that when a connection blocks on a RESERVED lock that it is able to continue after the lock is released. (<a href="http://www.sqlite.org/cvstrac/tktview?tn=3093">Ticket #3093</a>)</li><li>The "configure" scripts should now automatically configure Unix systems for large file support. Improved error messages for when large files are encountered and large file support is disabled.</li><li>Avoid cache pages leaks following disk-full or I/O errors</li><li>And, many more minor bug fixes and performance enhancements....</li></ul></p><a name="version_3_5_8"></a><h3>2008 Apr 16 (3.5.8)</h3><p><ul><li>Expose SQLite's internal pseudo-random number generator (PRNG) via the <a href="c3ref/randomness.html">sqlite3_randomness()</a> interface</li><li>New interface <a href="c3ref/context_db_handle.html">sqlite3_context_db_handle()</a> that returns the <a href="c3ref/sqlite3.html">database connection</a> handle that has invoked an application-defined SQL function.</li><li>New interface <a href="c3ref/limit.html">sqlite3_limit()</a> allows size and length limits to be set on a per-connection basis and at run-time.</li><li>Improved crash-robustness: write the database page size into the rollback journal header.</li><li>Allow the <a href="lang_vacuum.html">VACUUM</a> command to change the page size of a database file.</li><li>The xAccess() method of the VFS is allowed to return -1 to signal a memory allocation error.</li><li>Performance improvement: The OP_IdxDelete opcode uses unpacked records, obviating the need for one OP_MakeRecord opcode call for each index record deleted.</li><li>Performance improvement: Constant subexpressions are factored out of loops.</li><li>Performance improvement: Results of OP_Column are reused rather than issuing multiple OP_Column opcodes.</li><li>Fix a bug in the RTRIM collating sequence.</li><li>Fix a bug in the SQLITE_SECURE_DELETE option that was causing Firefox crashes. Make arrangements to always test SQLITE_SECURE_DELETE prior to each release.</li><li>Other miscellaneous performance enhancements.</li><li>Other miscellaneous minor bug fixes.</li></ul></p><a name="version_3_5_7"></a><h3>2008 Mar 17 (3.5.7)</h3><p><ul><li>Fix a bug (<a href="http://www.sqlite.org/cvstrac/tktview?tn=2927">ticket #2927</a>) in the register allocation forcompound selects - introduced by the new VM code in version 3.5.5.</li><li>ALTER TABLE uses double-quotes instead of single-quotes for quotingfilenames.</li><li>Use the WHERE clause to reduce the size of a materialized VIEW inan UPDATE or DELETE statement. (Optimization)</li><li>Do not apply the flattening optimization if the outer query is anaggregate and the inner query contains ORDER BY. (<a href="http://www.sqlite.org/cvstrac/tktview?tn=2943">Ticket #2943</a>)</li><li>Additional OS/2 updates</li><li>Added an experimental power-of-two, first-fit memory allocator.</li>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -