CVS commit: pkgsrc/databases

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Jan  8 14:43:10 UTC 2016

Modified Files:
        pkgsrc/databases/sqlite3: Makefile Makefile.version distinfo
        pkgsrc/databases/sqlite3-docs: Makefile PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: Makefile distinfo
        pkgsrc/databases/sqlite3/patches: patch-configure

Log Message:
Changes 3.10.0:

General improvements:
---------------------
Added support for LIKE, GLOB, and REGEXP operators on virtual tables.
Added the colUsed field to sqlite3_index_info for use by the sqlite3_module.xBestIndex method.
Enhance the PRAGMA cache_spill statement to accept a 32-bit integer parameter which is the threshold below which cache spilling is prohibited.
On unix, if a symlink to a database file is opened, then the corresponding journal files are based on the actual filename, not the symlink name.
Added the "--transaction" option to sqldiff.
Added the sqlite3_db_cacheflush() interface.
Added the sqlite3_strlike() interface.
When using memory-mapped I/O map the database file read-only so that stray pointers and/or array overruns in the application cannot accidently modify the database file.
Added the experimental sqlite3_snapshot_get(), sqlite3_snapshot_open(), and sqlite3_snapshot_free() interfaces. These are subject to change or removal in a subsequent release.
Enhance the 'utc' modifier in the date and time functions so that it is a no-op if the date/time is known to already be in UTC. (This is not a compatibility break since the behavior has long been 
documented as "undefined" in that case.)
Added the json_group_array() and json_group_object() SQL functions in the json extension.
Added the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.
Many small performance optimizations.

Portability enhancements:
-------------------------
Work around a sign-exension bug in the optimizer of the HP C compiler on HP/UX. (details)

Enhancements to the command-line shell:
---------------------------------------
Added the ".changes ON|OFF" and ".vfsinfo" dot-commands.
Translate between MBCS and UTF8 when running in cmd.exe on Windows.

Enhancements to makefiles:
--------------------------
Added the --enable-editline and --enable-static-shell options to the various autoconf-generated configure scripts.
Omit all use of "awk" in the makefiles, to make building easier for MSVC users.

Important fixes:
----------------
Fix inconsistent integer to floating-point comparison operations that could result in a corrupt index if the index is created on a table column that contains both large integers and floating point 
values of similar magnitude. Ticket 38a97a87a6.
Fix an infinite-loop in the query planner that could occur on malformed common table expressions.
Various bug fixes in the sqldiff tool.


To generate a diff of this commit:
cvs rdiff -u -r1.99 -r1.100 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/sqlite3/Makefile.version
cvs rdiff -u -r1.112 -r1.113 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.42 -r1.43 pkgsrc/databases/sqlite3-docs/Makefile
cvs rdiff -u -r1.47 -r1.48 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.48 -r1.49 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.76 -r1.77 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.61 -r1.62 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.1 -r1.2 pkgsrc/databases/sqlite3/patches/patch-configure

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