Subject: CVS commit: pkgsrc/databases
To: None <>
From: Thomas Klausner <>
List: pkgsrc-changes
Date: 09/30/2005 12:17:39
Module Name:	pkgsrc
Committed By:	wiz
Date:		Fri Sep 30 12:17:39 UTC 2005

Modified Files:
	pkgsrc/databases/sqlite3: Makefile.common distinfo
	pkgsrc/databases/sqlite3-tcl: Makefile

Log Message:
Update to 3.2.7:

2005 September 24 (3.2.7)

* GROUP BY now considers NULLs to be equal again, as it should
* Now compiles on Solaris and OpenBSD and other Unix variants that lack the
  fdatasync() function
* Now compiles on MSVC++6 again
* Fix uninitialized variables causing malfunctions for various obscure queries
* Correctly compute a LEFT OUTER JOINs that is constrained on the left table only

2005 September 17 (3.2.6)

* Fix a bug that can cause database corruption if a VACUUM (or autovacuum) fails
  and is rolled back on a database that is larger than 1GiB
* LIKE optiization now works for columns with COLLATE NOCASE
* ORDER BY and GROUP BY now use bounded memory
* Added support for COUNT(DISTINCT expr)
* Change the way SUM() handles NULL values in order to comply with the SQL standard
* Use fdatasync() instead of fsync() where possible in order to speed up commits
* Use of the CROSS keyword in a join turns off the table reordering optimization
* Added the experimental and undocumented EXPLAIN QUERY PLAN capability
* Use the unicode API in windows

2005 August 27 (3.2.5)

* Fix a bug effecting DELETE and UPDATE statements that changed more than 40960
* Change the makefile so that it no longer requires GNUmake extensions
* Fix the --enable-threadsafe option on the configure script
* Fix a code generator bug that occurs when the left-hand side of an IN operator is
  constant and the right-hand side is a SELECT statement
* The PRAGMA synchronous=off statement now disables syncing of the master journal
  file in addition to the normal rollback journals

2005 August 24 (3.2.4)

* Fix a bug introduced in the previous release that can cause a segfault while
  generating code for complex WHERE clauses.
* Allow floating point literals to begin or end with a decimal point.

2005 August 21 (3.2.3)

* Added support for the CAST operator
* Tcl interface allows BLOB values to be transferred to user-defined functions
* Added the "transaction" method to the Tcl interface
* Allow the DEFAULT value of a column to call functions that have constant operands
* Added the ANALYZE command for gathering statistics on indices and using those
  statistics when picking an index in the optimizer
* Remove the limit (formerly 100) on the number of terms in the WHERE clause
* The right-hand side of the IN operator can now be a list of expressions instead
  of just a list of constants
* Rework the optimizer so that it is able to make better use of indices
* The order of tables in a join is adjusted automatically to make better use of
* 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.
* WHERE clause expressions using BETWEEN and OR are now candidates for optimization
* Added the "case_sensitive_like" pragma and the SQLITE_CASE_SENSITIVE_LIKE
  compile-time option to set its default value to "on".
* Use indices to help with GLOB expressions and LIKE expressions too when the
  case_sensitive_like pragma is enabled
* Added support for grave-accent quoting for compatibility with MySQL
* Improved test coverage

To generate a diff of this commit:
cvs rdiff -r1.5 -r1.6 pkgsrc/databases/sqlite3/Makefile.common \
cvs rdiff -r1.1.1.1 -r1.2 pkgsrc/databases/sqlite3-tcl/Makefile

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.