Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2020-08-19 07:48:37
Message id: 20200819054837.AD5C1FB28@cvs.NetBSD.org

Log Message:
sqlite3: updated to 3.33.0

SQLite Release 3.33.0

Support for UPDATE FROM following the PostgreSQL syntax.
Increase the maximum size of database files to 281 TB.
Extended the PRAGMA integrity_check statement so that it can optionally be \ 
limited to verifying just a single table and its indexes, rather than the entire \ 
database file.
Added the decimal extension for doing arbitrary-precision decimal arithmetic.
Enhancements to the ieee754 extension for working with IEEE 754 binary64 numbers.
CLI enhancements:
Added four new output modes: "box", "json", \ 
"markdown", and "table".
The "column" output mode automatically expands columns to contain the \ 
longest output row and automatically turns ".header" on if it has not \ 
been previously set.
The "quote" output mode honors ".separator"
The decimal extension and the ieee754 extension are built-in to the CLI
Query planner improvements:
Add the ability to find a full-index-scan query plan for queries using INDEXED \ 
BY which previously would fail with "no query solution".
Do a better job of detecting missing, incomplete, and/or dodgy sqlite_stat1 data \ 
and generates good query plans in spite of the misinformation.
Improved performance of queries like "SELECT min(x) FROM t WHERE y IN \ 
(?,?,?)" assuming an index on t(x,y).
In WAL mode, if a writer crashes and leaves the shm file in an inconsistent \ 
state, subsequent transactions are now able to recover the shm file even if \ 
there are active read transactions. Before this enhancement, shm file recovery \ 
that scenario would result in an SQLITE_PROTOCOL error.

Files:
RevisionActionfile
1.72modifypkgsrc/databases/sqlite3/Makefile.common
1.161modifypkgsrc/databases/sqlite3/distinfo
1.95modifypkgsrc/databases/sqlite3-docs/PLIST
1.96modifypkgsrc/databases/sqlite3-docs/distinfo
1.108modifypkgsrc/databases/sqlite3-tcl/distinfo
1.37modifypkgsrc/devel/lemon/distinfo