From ade570b9d9913b93659679363f25132651af5ea8 Mon Sep 17 00:00:00 2001 From: adam Date: Wed, 23 Feb 2022 17:07:36 +0000 Subject: 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. --- 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(-) diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST index d4d29e79a5e..6c9793b8a03 100644 --- a/databases/sqlite3-docs/PLIST +++ b/databases/sqlite3-docs/PLIST @@ -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 diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo index 3a96619b43d..4ee8ebaec4b 100644 --- a/databases/sqlite3-docs/distinfo +++ b/databases/sqlite3-docs/distinfo @@ -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 --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo index 5ab2e88c606..12bb4dfa5fa 100644 --- a/databases/sqlite3-tcl/distinfo +++ b/databases/sqlite3-tcl/distinfo @@ -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 --git a/databases/sqlite3/Makefile.common b/databases/sqlite3/Makefile.common index eba395e32d4..feb1dc3ed01 100644 --- a/databases/sqlite3/Makefile.common +++ b/databases/sqlite3/Makefile.common @@ -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 --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo index 2ee97bb5119..8c68ec329a3 100644 --- a/databases/sqlite3/distinfo +++ b/databases/sqlite3/distinfo @@ -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 --git a/devel/lemon/distinfo b/devel/lemon/distinfo index fb1de4cfa1b..998ac04a0be 100644 --- a/devel/lemon/distinfo +++ b/devel/lemon/distinfo @@ -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 -- cgit v1.2.3