Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2019-07-12 12:04:27
Message id: 20190712100427.8670DFBF4@cvs.NetBSD.org

Log Message:
sqlite3: updated to 3.29.0

SQLite Release 3.29.0:
Added the SQLITE_DBCONFIG_DQS_DML and SQLITE_DBCONFIG_DQS_DDL actions to \ 
sqlite3_db_config() for activating and deactivating the double-quoted string \ 
literal misfeature. Both default to "on" for legacy compatibility, but \ 
developers are encouraged to turn them "off", perhaps using the \ 
-DSQLITE_DQS=0 compile-time option.
-DSQLITE_DQS=0 is now a recommended compile-time option.

Improvements to the query planner:
Improved optimization of AND and OR operators when one or the other operand is a \ 
constant.
Enhancements to the LIKE optimization for cases when the left-hand side column \ 
has numeric affinity.
Added the "sqlite_dbdata" virtual table for extracting raw low-level \ 
content from an SQLite database, even a database that is corrupt.

Enhancements to the CLI:
Add the ".recover" command which tries to recover as much content as \ 
possible from a corrupt database file.
Add the ".filectrl" command useful for testing.
Add the long-standing ".testctrl" command to the ".help" menu.
Added the ".dbconfig" command

Files:
RevisionActionfile
1.28modifypkgsrc/devel/lemon/distinfo
1.99modifypkgsrc/databases/sqlite3-tcl/distinfo
1.87modifypkgsrc/databases/sqlite3-docs/distinfo
1.86modifypkgsrc/databases/sqlite3-docs/PLIST
1.152modifypkgsrc/databases/sqlite3/distinfo
1.63modifypkgsrc/databases/sqlite3/Makefile.common