Documentation Source Text
Check-in [e45a1175e7]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
SHA1 Hash:e45a1175e7cb473ffc0309b0f2d2184445070875
Date: 2010-02-26 14:05:56
User: drh
Comment:Begin updating the documentation for the 3.6.23 release.
Tags And Properties
Changes
hide diffs unified diffs patch

Changes to pages/changes.in

37 <a href="http://www.sqlite.org/src/timeline"> 37 <a href="http://www.sqlite.org/src/timeline"> 38 http://www.sqlite.org/src/timeline</a>.</p> 38 http://www.sqlite.org/src/timeline</a>.</p> 39 } 39 } 40 hd_close_aux 40 hd_close_aux 41 hd_enable_main 1 41 hd_enable_main 1 42 } 42 } 43 } 43 } > 44 > 45 chng {2010 March 08 (3.6.23)} { > 46 <li> Added the [secure_delete pragma]. > 47 <li> Added the [sqlite3_compileoption_used()] and > 48 [sqlite3_compileoption_get()] interfaces as well as the > 49 [compile_options pragma] and the [sqlite_compile_option_used()] SQL > 50 function. > 51 <li> Added the [sqlite3_log()] interface together with the > 52 [SQLITE_CONFIG_LOG] verb to [sqlite3_config()]. The ".log" command > 53 is added to the [Command Line Interface]. > 54 <li> Improvements to [FTS3]. > 55 <li> Improvements and bug-fixes in support for [SQLITE_OMIT_FLOATING_POINT]. > 56 <li> The [integrity_check pragma] is enhanced to detect out-of-order rowids. > 57 <li> The ".genfkey" operator has been removed from the > 58 [Command Line Interface]. > 59 <li> Updates to the co-hosted Lemon LALR(1) parser generator. (These > 60 updates did not effect SQLite.) > 61 <li> Various minor bug fixes and performance enhancements. > 62 } 44 63 45 chng {2010 Jan 06 (3.6.22)} { 64 chng {2010 Jan 06 (3.6.22)} { 46 <li>Fix bugs that can (rarely) lead to incorrect query results when 65 <li>Fix bugs that can (rarely) lead to incorrect query results when 47 the CAST or OR operators are used in the WHERE clause of a query. 66 the CAST or OR operators are used in the WHERE clause of a query. 48 <li>Continuing enhancements and improvements to [FTS3]. 67 <li>Continuing enhancements and improvements to [FTS3]. 49 <li>Other miscellanous bug fixes. 68 <li>Other miscellanous bug fixes. 50 } 69 }

Changes to pages/index.in

76 76 77 </td> 77 </td> 78 <td width="20"></td><td bgcolor="#80a796" width="1"></td><td width="20"></td> 78 <td width="20"></td><td bgcolor="#80a796" width="1"></td><td width="20"></td> 79 <td valign="top"> 79 <td valign="top"> 80 <h3>Current Status</h3> 80 <h3>Current Status</h3> 81 81 82 <p><ul> 82 <p><ul> 83 <li><a href="releaselog/3_6_22.html">Version 3.6.22</a> | 83 <li><a href="releaselog/3_6_23.html">Version 3.6.23</a> 84 of SQLite is recommended for all new development. Upgrading from 84 of SQLite is recommended for all new development. Upgrading from 85 version 3.6.12 and 3.6.13 is optional. | 85 version 3.6.12, 3.6.13, and 3.6.22 is optional. 86 Upgrading from all other SQLite versions is recommended.</li> 86 Upgrading from all other SQLite versions is recommended.</li> 87 </ul></p> 87 </ul></p> 88 88 89 <h3>Common Links</h3> 89 <h3>Common Links</h3> 90 90 91 <p><ul> 91 <p><ul> 92 <li> <a href="features.html">Features</a> </li> 92 <li> <a href="features.html">Features</a> </li>

Changes to pages/news.in

14 hd_puts "<h3>$date - $title</h3>" 14 hd_puts "<h3>$date - $title</h3>" 15 regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt 15 regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt 16 regsub -all {[Tt]icket #(\d+)} $txt \ 16 regsub -all {[Tt]icket #(\d+)} $txt \ 17 {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt 17 {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt 18 hd_resolve "<p>$txt</p>" 18 hd_resolve "<p>$txt</p>" 19 hd_puts "<hr width=\"50%\">" 19 hd_puts "<hr width=\"50%\">" 20 } 20 } > 21 > 22 newsitem {2010-Mar-09} {Version 3.6.23} { > 23 SQLite [version 3.6.23] is a regular bimonthly release of SQLite. > 24 Upgrading from the prior release is purely optional. > 25 > 26 This release contains new pragmas: the [secure_delete pragma], > 27 the [compile_options pragma], and the [compile_option pragma]. > 28 There are a new SQL functions: [sqlite_compile_option_used()]. > 29 New C/C++ interfaces: [sqlite3_compileoption_used()], > 30 [sqlite3_compileoption_get()], [SQLITE_CONFIG_LOG], and > 31 [sqlite3_log()]. > 32 > 33 This release also includes several minor bug fixes and performance > 34 improvements. Support for [SQLITE_OMIT_FLOATING_POINT] is enhanced. > 35 There are on-going improvements to [FTS3]. > 36 > 37 The ".genfkey" command in the [Command Line Interface] has been > 38 removed. SQLite has supported standard SQL [foreign key constraints] > 39 since [version 3.6.19] and so the ".genfkey" command was seen as > 40 an anachronism. > 41 } 21 42 22 newsitem {2010-Jan-06} {Version 3.6.22} { 43 newsitem {2010-Jan-06} {Version 3.6.22} { 23 SQLite [version 3.6.22] is a bug-fix release. Two bugs have been fixed 44 SQLite [version 3.6.22] is a bug-fix release. Two bugs have been fixed 24 that might cause incorrect query results. 45 that might cause incorrect query results. 25 <ul> 46 <ul> 26 <li>Ticket [http://www.sqlite.org/src/info/31338dca7e | 31338dca7e] 47 <li>Ticket [http://www.sqlite.org/src/info/31338dca7e | 31338dca7e] 27 describes a 48 describes a