CVS commit: pkgsrc

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed Feb 23 17:07:37 UTC 2022

Modified Files:
        pkgsrc/databases/sqlite3: Makefile.common distinfo
        pkgsrc/databases/sqlite3-docs: PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: distinfo
        pkgsrc/devel/lemon: distinfo

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.


To generate a diff of this commit:
cvs rdiff -u -r1.84 -r1.85 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.177 -r1.178 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.107 -r1.108 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.110 -r1.111 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.122 -r1.123 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.51 -r1.52 pkgsrc/devel/lemon/distinfo

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

Modified files:

Index: pkgsrc/databases/sqlite3/Makefile.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.84 pkgsrc/databases/sqlite3/Makefile.common:1.85
--- pkgsrc/databases/sqlite3/Makefile.common:1.84       Fri Jan  7 21:06:28 2022
+++ pkgsrc/databases/sqlite3/Makefile.common    Wed Feb 23 17:07:36 2022
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.84 2022/01/07 21:06:28 adam Exp $
+# $NetBSD: Makefile.common,v 1.85 2022/02/23 17:07:36 adam Exp $
 #
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 # used by devel/lemon/Makefile
 
-SQLITE3_DISTVERSION=   3370200
-SQLITE3_VERSION=       3.37.2
+SQLITE3_DISTVERSION=   3380000
+SQLITE3_VERSION=       3.38.0
 
 MASTER_SITES=  http://www.sqlite.org/2022/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.177 pkgsrc/databases/sqlite3/distinfo:1.178
--- pkgsrc/databases/sqlite3/distinfo:1.177     Fri Jan  7 21:06:28 2022
+++ pkgsrc/databases/sqlite3/distinfo   Wed Feb 23 17:07:36 2022
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.177 2022/01/07 21:06:28 adam Exp $
+$NetBSD: distinfo,v 1.178 2022/02/23 17:07:36 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3370200.tar.gz) = 02e087a45653742a3a3e949f3a617eb5f54300ada84e075a910a262a8575cf32
-SHA512 (sqlite-autoconf-3370200.tar.gz) = d41049ce4a2007c57f81c54b1cdc3f812abbfafd40736134604392ab16d2d4c29e40f4b927f1deb133b128a869cfdb3434c8640ec227bc4a5da1686024f65d4e
-Size (sqlite-autoconf-3370200.tar.gz) = 3001797 bytes
+BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c
+SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28
+Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.107 pkgsrc/databases/sqlite3-docs/PLIST:1.108
--- pkgsrc/databases/sqlite3-docs/PLIST:1.107   Fri Jan  7 21:06:28 2022
+++ pkgsrc/databases/sqlite3-docs/PLIST Wed Feb 23 17:07:36 2022
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.107 2022/01/07 21:06:28 adam Exp $
+@comment $NetBSD: PLIST,v 1.108 2022/02/23 17:07:36 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -213,8 +213,12 @@ share/doc/sqlite3/c3ref/vtab.html
 share/doc/sqlite3/c3ref/vtab_collation.html
 share/doc/sqlite3/c3ref/vtab_config.html
 share/doc/sqlite3/c3ref/vtab_cursor.html
+share/doc/sqlite3/c3ref/vtab_distinct.html
+share/doc/sqlite3/c3ref/vtab_in.html
+share/doc/sqlite3/c3ref/vtab_in_first.html
 share/doc/sqlite3/c3ref/vtab_nochange.html
 share/doc/sqlite3/c3ref/vtab_on_conflict.html
+share/doc/sqlite3/c3ref/vtab_rhs_value.html
 share/doc/sqlite3/c3ref/wal_autocheckpoint.html
 share/doc/sqlite3/c3ref/wal_checkpoint.html
 share/doc/sqlite3/c3ref/wal_checkpoint_v2.html
@@ -637,6 +641,7 @@ share/doc/sqlite3/releaselog/3_36_0.html
 share/doc/sqlite3/releaselog/3_37_0.html
 share/doc/sqlite3/releaselog/3_37_1.html
 share/doc/sqlite3/releaselog/3_37_2.html
+share/doc/sqlite3/releaselog/3_38_0.html
 share/doc/sqlite3/releaselog/3_3_0.html
 share/doc/sqlite3/releaselog/3_3_1.html
 share/doc/sqlite3/releaselog/3_3_10.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.110 pkgsrc/databases/sqlite3-docs/distinfo:1.111
--- pkgsrc/databases/sqlite3-docs/distinfo:1.110        Fri Jan  7 21:06:28 2022
+++ pkgsrc/databases/sqlite3-docs/distinfo      Wed Feb 23 17:07:36 2022
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.110 2022/01/07 21:06:28 adam Exp $
+$NetBSD: distinfo,v 1.111 2022/02/23 17:07:36 adam Exp $
 
-BLAKE2s (sqlite-doc-3370200.zip) = 1e2232c02989f511a9809b02702dc9af71884d956f1a60ef1d0cb99da89a7cc4
-SHA512 (sqlite-doc-3370200.zip) = 02c68a3906aee3fd05a4340549144032a239e5ab885d9b3b09236ed2b74a90c770de373e4ca9f99e72f92df090d0fb6789213fb361e954d9dd6709af20336857
-Size (sqlite-doc-3370200.zip) = 10542395 bytes
+BLAKE2s (sqlite-doc-3380000.zip) = 86d1732125b456fdfb4b86131ff4b2ac27aec58eef4a31044b2167ef24aaa9b7
+SHA512 (sqlite-doc-3380000.zip) = 8e1f77504a1057cd23a8a6c2a285d63c5df50ceaf6ab84054a6f5422286dd868bdb3d5bd9be180b7834caba2b65ca185ffff60455bb504df30801157b62a62ef
+Size (sqlite-doc-3380000.zip) = 10603776 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.122 pkgsrc/databases/sqlite3-tcl/distinfo:1.123
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.122 Fri Jan  7 21:06:28 2022
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Wed Feb 23 17:07:37 2022
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.122 2022/01/07 21:06:28 adam Exp $
+$NetBSD: distinfo,v 1.123 2022/02/23 17:07:37 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3370200.tar.gz) = 02e087a45653742a3a3e949f3a617eb5f54300ada84e075a910a262a8575cf32
-SHA512 (sqlite-autoconf-3370200.tar.gz) = d41049ce4a2007c57f81c54b1cdc3f812abbfafd40736134604392ab16d2d4c29e40f4b927f1deb133b128a869cfdb3434c8640ec227bc4a5da1686024f65d4e
-Size (sqlite-autoconf-3370200.tar.gz) = 3001797 bytes
+BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c
+SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28
+Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.51 pkgsrc/devel/lemon/distinfo:1.52
--- pkgsrc/devel/lemon/distinfo:1.51    Fri Jan  7 21:06:28 2022
+++ pkgsrc/devel/lemon/distinfo Wed Feb 23 17:07:37 2022
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.51 2022/01/07 21:06:28 adam Exp $
+$NetBSD: distinfo,v 1.52 2022/02/23 17:07:37 adam Exp $
 
-BLAKE2s (sqlite-src-3370200.zip) = bebcb8c5cfd84f8b39edc09b8b999d36a8341d4d6856ba8cd851bc9d6daf4d12
-SHA512 (sqlite-src-3370200.zip) = 2db103965934bb34c8336cf82ff7d77e75dc1ca00fa6324ac5697f3bf4b41bffff355dec7593515a68816449e5c9827a9503f6d7841c4c13981c231d3414ff76
-Size (sqlite-src-3370200.zip) = 13145234 bytes
+BLAKE2s (sqlite-src-3380000.zip) = 1239ff74cd5245e1f5180438a595a0ee68b17c277b8877ca3b6acf87afc5da80
+SHA512 (sqlite-src-3380000.zip) = 9f4d3c406df5e6290f3f0b5e24b568723ab54bb085cb8cd7621ab42b0b8cd4f76e9784a4a29b42ea8cb0d1b7d759267c3cd980913d490d08e7172df05949131d
+Size (sqlite-src-3380000.zip) = 13236840 bytes