CVS commit: pkgsrc/databases

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Dec  6 19:26:58 UTC 2013

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.2:
Changed the defined behavior for the CAST expression when floating point values 
greater than +9223372036854775807 are cast into into integers so that the 
result is the largest possible integer, +9223372036854775807, instead of the 
smallest possible integer, -9223372036854775808. After this change, 
CAST(9223372036854775809.0 as INT) yields +9223372036854775807 instead of 
-9223372036854775808. ← Potentially Incompatible Change!
Added support for WITHOUT ROWID tables.
Added the skip-scan optimization to the query planner.
Extended the virtual table interface, and in particular the sqlite3_index_info 
object to allow a virtual table to report its estimate on the number of rows 
that will be returned by a query.
Update the R-Tree extension to make use of the enhanced virtual table interface.
Add the SQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option.
Enhanced the comments that are inserted into EXPLAIN output when the 
SQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option is enabled.
Performance enhancements in the VDBE, especially to the OP_Column opcode.
Factor constant subexpressions in inner loops out to the initialization code in 
prepared statements.
Enhanced the ".explain" output formatting of the command-line shell so that 
loops are indented to better show the structure of the program.
Enhanced the ".timer" feature of the command-line shell so that it shows 
wall-clock time in addition to system and user times.


To generate a diff of this commit:
cvs rdiff -u -r1.70 -r1.71 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.81 -r1.82 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/sqlite3-docs/Makefile
cvs rdiff -u -r1.21 -r1.22 pkgsrc/databases/sqlite3-docs/PLIST \
    pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.51 -r1.52 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.34 -r1.35 pkgsrc/databases/sqlite3-tcl/distinfo

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