CVS commit: pkgsrc/databases

[Thomas Klausner <wiz%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   wiz
Date:           Tue Mar  4 10:46:55 UTC 2008

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

Log Message:
Update to 3.5.6:

2008 Feb 6 (3.5.6)

   * Fix a bug ( ticket #2913) that prevented virtual tables from working
     in a LEFT JOIN. The problem was introduced into shortly before the
     3.5.5 release.
   * Bring the OS/2 porting layer up-to-date.
   * Add the new sqlite3_result_error_code() API and use it in the
     implementation of ATTACH so that proper error codes are returned when
     an ATTACH fails.

2008 Jan 31 (3.5.5)

   * Convert the underlying virtual machine to be a register-based machine
     rather than a stack-based machine. The only user-visible change is in
     the output of EXPLAIN.
   * Add the build-in RTRIM collating sequence.

2007 Dec 14 (3.5.4)

   * Fix a critical bug in UPDATE or DELETE that occurs when an OR REPLACE
     clause or a trigger causes rows in the same table to be deleted as
     side effects. (See ticket #2832.) The most likely result of this bug
     is a segmentation fault, though database corruption is a possibility.
   * Bring the processing of ORDER BY into compliance with the SQL standard
     for case where a result alias and a table column name are in conflict.
     Correct behavior is to prefer the result alias. Older versions of
     SQLite incorrectly picked the table column. (See ticket #2822.)
   * The VACUUM command preserves the setting of the legacy_file_format
     pragma. ( Ticket #2804.)
   * Productize and officially support the group_concat() SQL function.
   * Better optimization of some IN operator expressions.
   * Add the ability to change the auto_vacuum status of a database by
     setting the auto_vaccum pragma and VACUUMing the database.
   * Prefix search in FTS3 is much more efficient.
   * Relax the SQL statement length restriction in the CLI so that the
     ".dump" output of databases with very large BLOBs and strings can be
     played back to recreate the database.
   * Other small bug fixes and optimizations.

2007 Nov 27 (3.5.3)

   * Move website and documentation files out of the source tree into a
     separate CM system.
   * Fix a long-standing bug in INSERT INTO ... SELECT ... statements where
     the SELECT is compound.
   * Fix a long-standing bug in RAISE(IGNORE) as used in BEFORE triggers.
   * Fixed the operator precedence for the ~ operator.
   * On win32, do not return an error when attempting to delete a file that
     does not exist.
   * Allow collating sequence names to be quoted.
   * Modify the TCL interface to use sqlite3_prepare_v2().
   * Fix multiple bugs that can occur following a malloc() failure.
   * sqlite3_step() returns SQLITE_MISUSE instead of crashing when called
     with a NULL parameter.
   * FTS3 now uses the SQLite memory allocator exclusively. The FTS3
     amalgamation can now be appended to the SQLite amalgamation to
     generate a super-amalgamation containing both.
   * The DISTINCT keyword now will sometimes use an INDEX if an appropriate
     index is available and the optimizer thinks its use might be
     advantageous.


To generate a diff of this commit:
cvs rdiff -r1.17 -r1.18 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -r1.15 -r1.16 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -r1.6 -r1.7 pkgsrc/databases/sqlite3-tcl/Makefile

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