Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2020-12-02 08:57:19
Message id: 20201202075719.9D241FA9D@cvs.NetBSD.org

Log Message:
sqlite3: updated to 3.34.0

SQLite Release 3.34.0

Added the sqlite3_txn_state() interface for reporting on the current transaction \ 
state of the database connection.
Enhance recursive common table expressions to support two or more recursive \ 
terms as is done by SQL Server, since this helps make queries against graphs \ 
easier to write and faster to execute.
Improved error messages on CHECK constraint failures.
CLI enhancements:
The .read dot-command now accepts a pipeline in addition to a filename.
Added options --data-only and --nosys to the .dump dot-command.
Added the --nosys option to the .schema dot-command.
Table name quoting works correctly for the .import dot-command.
The generate_series(START,END,STEP) table-valued function extension is now built \ 
into the CLI.
The .databases dot-command now show the status of each database file as \ 
determined by sqlite3_db_readonly() and sqlite3_txn_state().
Added the --tabs command-line option that sets .mode tabs.
The --init option reports an error if the file named as its argument cannot be \ 
opened. The --init option also now honors the --bail option.
Query planner improvements:
Improved estimates for the cost of running a DISTINCT operator.
When doing an UPDATE or DELETE using a multi-column index where only a few of \ 
the earlier columns of the index are useful for the index lookup, postpone doing \ 
the main table seek until after all WHERE clause constraints have been \ 
evaluated, in case those constraints can be covered by unused later terms of the \ 
index, thus avoiding unnecessary main table seeks.
The new OP_SeekScan opcode is used to improve performance of multi-column index \ 
look-ups when later columns are constrained by an IN operator.
The BEGIN IMMEDIATE and BEGIN EXCLUSIVE commands now work even if one or more \ 
attached database files are read-only.
Enhanced FTS5 to support trigram indexes.
Improved performance of WAL mode locking primitives in cases where there are \ 
hundreds of connections all accessing the same database file at once.
Enhanced the carray() table-valued function to include a single-argument form \ 
that is bound using the auxiliary sqlite3_carray_bind() interface.
The substr() SQL function can now also be called "substring()" for \ 
compatibility with SQL Server.
The syntax diagrams are now implemented as Pikchr scripts and rendered as SVG \ 
for improved legibility and ease of maintenance.

Files:
RevisionActionfile
1.138modifypkgsrc/databases/sqlite3/Makefile
1.73modifypkgsrc/databases/sqlite3/Makefile.common
1.162modifypkgsrc/databases/sqlite3/distinfo
1.96modifypkgsrc/databases/sqlite3-docs/PLIST
1.97modifypkgsrc/databases/sqlite3-docs/distinfo
1.105modifypkgsrc/databases/sqlite3-tcl/Makefile
1.109modifypkgsrc/databases/sqlite3-tcl/distinfo
1.38modifypkgsrc/devel/lemon/distinfo