📄 3_5_4.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html><head><title>SQLite Release 3.5.4 On 2007 Dec 14 (3.5.4)</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> <h2>SQLite Release 3.5.4 On 2007 Dec 14 (3.5.4)</h2><p>Changes associated with this release include the following:</p><p><ul><li>Fix a critical bug in UPDATE or DELETE that occurs when anOR REPLACE clause or a trigger causes rows in the same table tobe deleted as side effects. (See <a href="http://www.sqlite.org/cvstrac/tktview?tn=2832">ticket #2832</a>.) The most likelyresult of this bug is a segmentation fault, though databasecorruption is a possibility.</li><li>Bring the processing of ORDER BY into compliance with the SQL standard for case where a result alias and a table column nameare in conflict. Correct behavior is to prefer the result alias.Older versions of SQLite incorrectly picked the table column.(See <a href="http://www.sqlite.org/cvstrac/tktview?tn=2822">ticket #2822</a>.)</li><li>The <a href="../lang_vacuum.html">VACUUM</a> command preservesthe setting of the <a href="../pragma.html#pragma_legacy_file_format">legacy_file_format pragma</a>.(<a href="http://www.sqlite.org/cvstrac/tktview?tn=2804">Ticket #2804</a>.)</li><li>Productize and officially support the group_concat() SQL function.</li><li>Better optimization of some IN operator expressions.</li><li>Add the ability to change the <a href="../pragma.html#pragma_auto_vacuum">auto_vacuum</a> status of adatabase by setting the auto_vaccum pragma and VACUUMing the database.</li><li>Prefix search in FTS3 is much more efficient.</li><li>Relax the SQL statement length restriction in the CLI so thatthe ".dump" output of databases with very large BLOBs and strings canbe played back to recreate the database.</li><li>Other small bug fixes and optimizations.</li></ul></p> <p>A <a href="../changes.html">complete list of SQLite releases</a> in a single pages is also available. A detailed history of every check-in is available at <a href="http://www.sqlite.org/cvstrac/timeline"> http://www.sqlite.org/cvstrac/timeline</a>.</p> <hr><small><i>This page last modified 2008/05/14 12:07:20 UTC</i></small></div></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -