CVS commit: pkgsrc/databases

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Jun  5 15:10:20 UTC 2014

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

Log Message:
Changes 3.8.5:
Added support for partial sorting by index.
Enhance the query planner so that it always prefers an index that uses a 
superset of WHERE clause terms relative to some other index.
Improvements to the automerge command of FTS4 to better control the index size 
for a full-text index that is subject to a large number of updates.
Added the sqlite3_rtree_query_callback() interface to R-Tree extension
Added new URI query parameters "nolock" and "immutable".
Use less memory by not remembering CHECK constraints on read-only database 
connections.
Enable the OR optimization for WITHOUT ROWID tables.
Render expressions of the form "x IN (?)" (with a single value in the list on 
the right-hand side of the IN operator) as if they where "x==?", Similarly 
optimize "x NOT IN (?)"
Add the ".system" and ".once" commands to the command-line shell.
Added the SQLITE_IOCAP_IMMUTABLE bit to the set of bits that can be returned by 
the xDeviceCharacteristics method of a VFS.
Added the SQLITE_TESTCTRL_BYTEORDER test control.

Bug Fixes:
----------
OFFSET clause ignored on queries without a FROM clause.
Assertion fault on queries involving expressions of the form "x IN (?)".
Incorrect column datatype reported.
Duplicate row returned on a query against a table with more than 16 indices, 
each on a separate column, and all used via OR-connected constraints.
Partial index causes assertion fault on UPDATE OR REPLACE.
Crash when calling undocumented SQL function sqlite_rename_parent() with NULL 
parameters.
ORDER BY ignored if the query has an identical GROUP BY.
The group_concat(x,'') SQL function returns NULL instead of an empty string 
when all inputs are empty strings.
Fix a bug in the VDBE code generator that caused crashes when doing an INSERT 
INTO ... SELECT statement where the number of columns being inserted is larger 
than the number of columns in the destination table.
Fix a problem in CSV import in the command-line shell where if the leftmost 
field of the first row in the CSV file was both zero bytes in size and unquoted 
no data would be imported.
Fix a problem in FTS4 where the left-most column that contained the notindexed 
column name as a prefix was not indexed rather than the column whose name 
matched exactly.
Fix the sqlite3_db_readonly() interface so that it returns true if the database 
is read-only due to the file format write version number being too large.


To generate a diff of this commit:
cvs rdiff -u -r1.78 -r1.79 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.88 -r1.89 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.30 -r1.31 pkgsrc/databases/sqlite3-docs/Makefile
cvs rdiff -u -r1.28 -r1.29 pkgsrc/databases/sqlite3-docs/PLIST \
    pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.60 -r1.61 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.41 -r1.42 pkgsrc/databases/sqlite3-tcl/distinfo

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