Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2022-02-23 18:07:37
Message id: 20220223170737.62295FB24@cvs.NetBSD.org

Log Message:
sqlite3: updated to 3.38.0

SQLite Release 3.38.0 On 2022-02-22

Added the -> and ->> operators for easier processing of JSON. The new \ 
operators are compatible with MySQL and PostgreSQL.
The JSON functions are now built-ins. It is no longer necessary to use the \ 
-DSQLITE_ENABLE_JSON1 compile-time option to enable JSON support. JSON is on by \ 
default. Disable the JSON interface using the new -DSQLITE_OMIT_JSON \ 
compile-time option.
Enhancements to date and time functions:
Added the unixepoch() function.
Added the auto modifier and the julianday modifier.
Rename the printf() SQL function to format() for better compatibility. The \ 
original printf() name is retained as an alias for backwards compatibility.
Added the sqlite3_error_offset() interface, which can sometimes help to localize \ 
an SQL error to a specific character in the input SQL text, so that applications \ 
can provide better error messages.
Enhanced the interface to virtual tables as follows:
Added the sqlite3_vtab_distinct() interface.
Added the sqlite3_vtab_rhs_value() interface.
Added new operator types SQLITE_INDEX_CONSTRAINT_LIMIT and \ 
SQLITE_INDEX_CONSTRAINT_OFFSET.
Added the sqlite3_vtab_in() interface (and related) to enable a virtual table to \ 
process IN operator constraints all at once, rather than processing each value \ 
of the right-hand side of the IN operator separately.
CLI enhancements:
Columnar output modes are enhanced to correctly handle tabs and newlines \ 
embedded in text.
Added options like "--wrap N", "--wordwrap on", and \ 
"--quote" to the columnar output modes.
Added the .mode qbox alias.
The .import command automatically disambiguates column names.
Use the new sqlite3_error_offset() interface to provide better error messages.
Query planner enhancements:
Use a Bloom filter to speed up large analytic queries.
Use a balanced merge tree to evaluate UNION or UNION ALL compound SELECT \ 
statements that have an ORDER BY clause.
The ALTER TABLE statement is changed to silently ignores entries in the \ 
sqlite_schema table that do not parse when PRAGMA writable_schema=ON.

Files:
RevisionActionfile
1.85modifypkgsrc/databases/sqlite3/Makefile.common
1.178modifypkgsrc/databases/sqlite3/distinfo
1.108modifypkgsrc/databases/sqlite3-docs/PLIST
1.111modifypkgsrc/databases/sqlite3-docs/distinfo
1.123modifypkgsrc/databases/sqlite3-tcl/distinfo
1.52modifypkgsrc/devel/lemon/distinfo