Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Increase the version number and adjust documentation prior to the next release. (CVS 2609) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
b15ed7db4d5186d8b22c0b51cd44c4d9 |
User & Date: | drh 2005-08-21 18:40:21.000 |
Context
2005-08-21
| ||
18:54 | Version 3.2.3 (CVS 2610) (check-in: f620319b44 user: drh tags: trunk) | |
18:40 | Increase the version number and adjust documentation prior to the next release. (CVS 2609) (check-in: b15ed7db4d user: drh tags: trunk) | |
18:21 | Disable malloc tests when not compiled with SQLITE_DEBUG. (CVS 2608) (check-in: f372682fa3 user: drh tags: trunk) | |
Changes
Changes to VERSION.
|
| | | 1 | 3.2.3 |
Changes to www/changes.tcl.
︙ | ︙ | |||
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | </p> <DL> } proc chng {date desc} { puts "<DT><B>$date</B></DT>" puts "<DD><P><UL>$desc</UL></P></DD>" } chng {2005 June 13 (3.2.2)} { <li>Added the sqlite3_db_handle() API</li> <li>Added the sqlite3_get_autocommit() API</li> <li>Added a REGEXP operator to the parser. There is no function to back up this operator in the standard build but users can add their own using sqlite3_create_function()</li> | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 | </p> <DL> } proc chng {date desc} { if {[regexp {\(([0-9.]+)\)} $date all vers]} { set label [string map {. _} $vers] puts "<A NAME=\"version_$label\">" } puts "<DT><B>$date</B></DT>" puts "<DD><P><UL>$desc</UL></P></DD>" } chng {2005 August 21 (3.2.3)} { <li>Added support for the CAST operator</li> <li>Tcl interface allows BLOB values to be transferred to user-defined functions</li> <li>Added the "transaction" method to the Tcl interface</li> <li>Allow the DEFAULT value of a column to call functions that have constant operands</li> <li>Added the ANALYZE command for gathering statistics on indices and using those statistics when picking an index in the optimizer</li> <li>Remove the limit (formerly 100) on the number of terms in the WHERE clause</li> <li>The right-hand side of the IN operator can now be a list of expressions instead of just a list of constants</li> <li>Rework the optimizer so that it is able to make better use of indices</li> <li>The order of tables in a join is adjusted automatically to make better use of indices</li> <li>The IN operator is now a candidate for optimization even if the left-hand side is not the left-most term of the index. Multiple IN operators can be used with the same index.</li> <li>WHERE clause expressions using BETWEEN and OR are now candidates for optimization</li> <li>Added the "case_sensitive_like" pragma and the SQLITE_CASE_SENSITIVE_LIKE compile-time option to set its default value to "on".</li> <li>Use indices to help with GLOB expressions and LIKE expressions too when the case_sensitive_like pragma is enabled</li> <li>Added support for grave-accent quoting for compatibility with MySQL</li> <li>Improved test coverage</li> <li>Dozens of minor bug fixes</li> } chng {2005 June 13 (3.2.2)} { <li>Added the sqlite3_db_handle() API</li> <li>Added the sqlite3_get_autocommit() API</li> <li>Added a REGEXP operator to the parser. There is no function to back up this operator in the standard build but users can add their own using sqlite3_create_function()</li> |
︙ | ︙ |
Changes to www/index.tcl.
︙ | ︙ | |||
58 59 60 61 62 63 64 65 66 67 68 69 70 71 | proc newsitem {date title text} { puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt puts "<p>$txt</p>" puts "<hr width=\"50%\">" } newsitem {2005-Aug-2} {2005 Open Source Award for SQLite} { <table align="right" border="0"><tr><td> <a href="http://osdir.com/Article6677.phtml"> <img src="2005osaward.gif"></a> </td></tr></table> SQLite and its primary author D. Richard Hipp have been honored with | > > > > > > > > | 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 | proc newsitem {date title text} { puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt puts "<p>$txt</p>" puts "<hr width=\"50%\">" } newsitem {2005-Aug-21} {Version 3.2.3} { This release adds the <a href="lang_analyze.html">ANALYZE</a> command, the <a href="lang_expr.html">CAST</a> operator, and many very substantial improvements to the query optimizer. See the <a href="changes.html#version_3_2_3">change log</a> for additional information. } newsitem {2005-Aug-2} {2005 Open Source Award for SQLite} { <table align="right" border="0"><tr><td> <a href="http://osdir.com/Article6677.phtml"> <img src="2005osaward.gif"></a> </td></tr></table> SQLite and its primary author D. Richard Hipp have been honored with |
︙ | ︙ | |||
97 98 99 100 101 102 103 | within that transaction an UPDATE or INSERT statement fails due to a constraint, then you try to rollback the whole transaction, the rollback might not work correctly. See <a href="http://www.sqlite.org/cvstrac/tktview?tn=1171">Ticket #1171</a> for details. Upgrading is recommended for all users. } | < < < < < < < < < < < < < < < < < < < < < < < < < | | 105 106 107 108 109 110 111 112 113 114 115 116 117 | within that transaction an UPDATE or INSERT statement fails due to a constraint, then you try to rollback the whole transaction, the rollback might not work correctly. See <a href="http://www.sqlite.org/cvstrac/tktview?tn=1171">Ticket #1171</a> for details. Upgrading is recommended for all users. } puts { <p align="right"><a href="oldnews.html">Old news...</a></p> </td></tr></table> } footer {$Id: index.tcl,v 1.118 2005/08/21 18:40:21 drh Exp $} |
Changes to www/oldnews.tcl.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | #!/usr/bin/tclsh source common.tcl header {SQLite Older News} proc newsitem {date title text} { puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt puts "<p>$txt</p>" puts "<hr width=\"50%\">" } newsitem {2005-Feb-15} {Versions 2.8.16 and 3.1.2 Released} { A critical bug in the VACUUM command that can lead to database corruption has been fixed in both the 2.x branch and the main 3.x line. This bug has existed in all prior versions of SQLite. Even though it is unlikely you will ever encounter this bug, it is suggested that all users upgrade. See <a href="http://www.sqlite.org/cvstrac/tktview?tn=1116"> | > > > > > > > > > > > > > > > > > > > > > > > > > | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 | #!/usr/bin/tclsh source common.tcl header {SQLite Older News} proc newsitem {date title text} { puts "<h3>$date - $title</h3>" regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt puts "<p>$txt</p>" puts "<hr width=\"50%\">" } newsitem {2005-Mar-16} {Version 3.1.6} { Version 3.1.6 fixes a critical bug that can cause database corruption when inserting rows into tables with around 125 columns. This bug was introduced in version 3.0.0. See <a href="http://www.sqlite.org/cvstrac/tktview?tn=1163">Ticket #1163</a> for additional information. } newsitem {2005-Mar-11} {Versions 3.1.4 and 3.1.5 Released} { Version 3.1.4 fixes a critical bug that could cause database corruption if the autovacuum mode of version 3.1.0 is turned on (it is off by default) and a CREATE UNIQUE INDEX is executed within a transaction but fails because the indexed columns are not unique. Anyone using the autovacuum feature and unique indices should upgrade. Version 3.1.5 adds the ability to disable the F_FULLFSYNC ioctl() in OS-X by setting "PRAGMA synchronous=on" instead of the default "PRAGMA synchronous=full". There was an attempt to add this capability in 3.1.4 but it did not work due to a spelling error. } newsitem {2005-Feb-19} {Version 3.1.3 Released} { Version 3.1.3 cleans up some minor issues discovered in version 3.1.2. } newsitem {2005-Feb-15} {Versions 2.8.16 and 3.1.2 Released} { A critical bug in the VACUUM command that can lead to database corruption has been fixed in both the 2.x branch and the main 3.x line. This bug has existed in all prior versions of SQLite. Even though it is unlikely you will ever encounter this bug, it is suggested that all users upgrade. See <a href="http://www.sqlite.org/cvstrac/tktview?tn=1116"> |
︙ | ︙ | |||
192 193 194 195 196 197 198 | changes to both the C-language API and the underlying file format that will enable SQLite to better support internationalization. The first beta is schedule for release on 2004-July-01. Plans are to continue to support SQLite version 2.8 with bug fixes. But all new development will occur in version 3.0. } | | | 217 218 219 220 221 222 223 224 | changes to both the C-language API and the underlying file format that will enable SQLite to better support internationalization. The first beta is schedule for release on 2004-July-01. Plans are to continue to support SQLite version 2.8 with bug fixes. But all new development will occur in version 3.0. } footer {$Id: oldnews.tcl,v 1.12 2005/08/21 18:40:21 drh Exp $} |