CVS commit: pkgsrc/databases

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Mar 20 21:00:47 UTC 2012

Modified Files:
        pkgsrc/databases/sqlite3: Makefile builtin.mk distinfo
        pkgsrc/databases/sqlite3-docs: Makefile PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: Makefile distinfo

Log Message:
Changes 3.7.11:
* Enhance the INSERT syntax to allow multiple rows to be inserted via
  the VALUES clause.
* Enhance the CREATE VIRTUAL TABLE command to support the IF NOT EXISTS clause.
* Added the sqlite3_stricmp() interface as a counterpart to sqlite3_strnicmp().
* Added the sqlite3_db_readonly() interface.
* Added the SQLITE_FCNTL_PRAGMA file control, giving VFS implementations
  the ability to add new PRAGMA statements or to override built-in PRAGMAs.
* Queries of the form: "SELECT max(x), y FROM table" returns the value of y on
  the same row that contains the maximum x value.
* Added support for the FTS4 languageid option.
* Documented support for the FTS4 content option. This feature has actually
  been in the code since version 3.7.9 but is only now considered to be
  officially supported.
* Pending statements no longer block ROLLBACK. Instead, the pending statement
  will return SQLITE_ABORT upon next access after the ROLLBACK.
* Improvements to the handling of CSV inputs in the command-line shell
* Fix a bug introduced in version 3.7.10 that might cause a LEFT JOIN to be
  incorrectly converted into an INNER JOIN if the WHERE clause indexable terms
  connected by OR.


To generate a diff of this commit:
cvs rdiff -u -r1.48 -r1.49 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/sqlite3/builtin.mk
cvs rdiff -u -r1.66 -r1.67 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/sqlite3-docs/Makefile \
    pkgsrc/databases/sqlite3-docs/PLIST \
    pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.30 -r1.31 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.19 -r1.20 pkgsrc/databases/sqlite3-tcl/distinfo

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