[pkgsrc/trunk]: pkgsrc sqlite3: updated to 3.38.0

To: pkgsrc-changes-hg%NetBSD.org@localhost
Subject: [pkgsrc/trunk]: pkgsrc sqlite3: updated to 3.38.0
From: adam <adam%pkgsrc.org@localhost>
Date: Wed, 23 Feb 2022 18:23:49 +0000
details:   https://anonhg.NetBSD.org/pkgsrc/rev/0c7c09bd859e
branches:  trunk
changeset: 374584:0c7c09bd859e
user:      adam <adam%pkgsrc.org@localhost>
date:      Wed Feb 23 17:07:36 2022 +0000

description:
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.

diffstat:

 databases/sqlite3-docs/PLIST      |  7 ++++++-
 databases/sqlite3-docs/distinfo   |  8 ++++----
 databases/sqlite3-tcl/distinfo    |  8 ++++----
 databases/sqlite3/Makefile.common |  6 +++---
 databases/sqlite3/distinfo        |  8 ++++----
 devel/lemon/distinfo              |  8 ++++----
 6 files changed, 25 insertions(+), 20 deletions(-)

diffs (103 lines):

diff -r 8df10477728e -r 0c7c09bd859e databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Wed Feb 23 16:58:43 2022 +0000
+++ b/databases/sqlite3-docs/PLIST      Wed Feb 23 17:07:36 2022 +0000
@@ -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_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_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
diff -r 8df10477728e -r 0c7c09bd859e databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Wed Feb 23 16:58:43 2022 +0000
+++ b/databases/sqlite3-docs/distinfo   Wed Feb 23 17:07:36 2022 +0000
@@ -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
diff -r 8df10477728e -r 0c7c09bd859e databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Wed Feb 23 16:58:43 2022 +0000
+++ b/databases/sqlite3-tcl/distinfo    Wed Feb 23 17:07:36 2022 +0000
@@ -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
diff -r 8df10477728e -r 0c7c09bd859e databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Wed Feb 23 16:58:43 2022 +0000
+++ b/databases/sqlite3/Makefile.common Wed Feb 23 17:07:36 2022 +0000
@@ -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/
diff -r 8df10477728e -r 0c7c09bd859e databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Wed Feb 23 16:58:43 2022 +0000
+++ b/databases/sqlite3/distinfo        Wed Feb 23 17:07:36 2022 +0000
@@ -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
diff -r 8df10477728e -r 0c7c09bd859e devel/lemon/distinfo
--- a/devel/lemon/distinfo      Wed Feb 23 16:58:43 2022 +0000
+++ b/devel/lemon/distinfo      Wed Feb 23 17:07:36 2022 +0000
@@ -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
Prev by Date: [pkgsrc/trunk]: pkgsrc/doc Updated databases/sqlite3, databases/sqlite3-docs,...
Next by Date: [pkgsrc/trunk]: pkgsrc/doc TODO: - sqlite, done
Previous by Thread: [pkgsrc/trunk]: pkgsrc/doc Updated databases/sqlite3, databases/sqlite3-docs,...
Next by Thread: [pkgsrc/trunk]: pkgsrc/doc TODO: - sqlite, done
Indexes:
Home | Main Index | Thread Index | Old Index