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.diff -r1.84 -r1.85 pkgsrc/databases/sqlite3/Makefile.common
(adam)
@@ -1,15 +1,15 @@ | @@ -1,15 +1,15 @@ | |||
1 | # $NetBSD: Makefile.common,v 1.84 2022/01/07 21:06:28 adam Exp $ | 1 | # $NetBSD: Makefile.common,v 1.85 2022/02/23 17:07:36 adam Exp $ | |
2 | # | 2 | # | |
3 | # used by databases/sqlite3/Makefile | 3 | # used by databases/sqlite3/Makefile | |
4 | # used by databases/sqlite3-docs/Makefile | 4 | # used by databases/sqlite3-docs/Makefile | |
5 | # used by databases/sqlite3-tcl/Makefile | 5 | # used by databases/sqlite3-tcl/Makefile | |
6 | # used by devel/lemon/Makefile | 6 | # used by devel/lemon/Makefile | |
7 | 7 | |||
8 | SQLITE3_DISTVERSION= 3370200 | 8 | SQLITE3_DISTVERSION= 3380000 | |
9 | SQLITE3_VERSION= 3.37.2 | 9 | SQLITE3_VERSION= 3.38.0 | |
10 | 10 | |||
11 | MASTER_SITES= http://www.sqlite.org/2022/ | 11 | MASTER_SITES= http://www.sqlite.org/2022/ | |
12 | MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/ | 12 | MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2022/ | |
13 | 13 | |||
14 | HOMEPAGE?= http://www.sqlite.org/ | 14 | HOMEPAGE?= http://www.sqlite.org/ | |
15 | LICENSE= public-domain | 15 | LICENSE= public-domain |
@@ -1,6 +1,6 @@ | @@ -1,6 +1,6 @@ | |||
1 | $NetBSD: distinfo,v 1.177 2022/01/07 21:06:28 adam Exp $ | 1 | $NetBSD: distinfo,v 1.178 2022/02/23 17:07:36 adam Exp $ | |
2 | 2 | |||
3 | BLAKE2s (sqlite-autoconf-3370200.tar.gz) = 02e087a45653742a3a3e949f3a617eb5f54300ada84e075a910a262a8575cf32 | 3 | BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c | |
4 | SHA512 (sqlite-autoconf-3370200.tar.gz) = d41049ce4a2007c57f81c54b1cdc3f812abbfafd40736134604392ab16d2d4c29e40f4b927f1deb133b128a869cfdb3434c8640ec227bc4a5da1686024f65d4e | 4 | SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28 | |
5 | Size (sqlite-autoconf-3370200.tar.gz) = 3001797 bytes | 5 | Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes | |
6 | SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 | 6 | SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4 |
@@ -1,14 +1,14 @@ | @@ -1,14 +1,14 @@ | |||
1 | @comment $NetBSD: PLIST,v 1.107 2022/01/07 21:06:28 adam Exp $ | 1 | @comment $NetBSD: PLIST,v 1.108 2022/02/23 17:07:36 adam Exp $ | |
2 | share/doc/sqlite3/34to35.html | 2 | share/doc/sqlite3/34to35.html | |
3 | share/doc/sqlite3/35to36.html | 3 | share/doc/sqlite3/35to36.html | |
4 | share/doc/sqlite3/about.html | 4 | share/doc/sqlite3/about.html | |
5 | share/doc/sqlite3/aff_short.html | 5 | share/doc/sqlite3/aff_short.html | |
6 | share/doc/sqlite3/affcase1.html | 6 | share/doc/sqlite3/affcase1.html | |
7 | share/doc/sqlite3/amalgamation.html | 7 | share/doc/sqlite3/amalgamation.html | |
8 | share/doc/sqlite3/appfileformat.html | 8 | share/doc/sqlite3/appfileformat.html | |
9 | share/doc/sqlite3/appfunc.html | 9 | share/doc/sqlite3/appfunc.html | |
10 | share/doc/sqlite3/arch.html | 10 | share/doc/sqlite3/arch.html | |
11 | share/doc/sqlite3/assert.html | 11 | share/doc/sqlite3/assert.html | |
12 | share/doc/sqlite3/asyncvfs.html | 12 | share/doc/sqlite3/asyncvfs.html | |
13 | share/doc/sqlite3/atomiccommit.html | 13 | share/doc/sqlite3/atomiccommit.html | |
14 | share/doc/sqlite3/autoinc.html | 14 | share/doc/sqlite3/autoinc.html | |
@@ -203,28 +203,32 @@ share/doc/sqlite3/c3ref/unlock_notify.ht | @@ -203,28 +203,32 @@ share/doc/sqlite3/c3ref/unlock_notify.ht | |||
203 | share/doc/sqlite3/c3ref/update_hook.html | 203 | share/doc/sqlite3/c3ref/update_hook.html | |
204 | share/doc/sqlite3/c3ref/uri_boolean.html | 204 | share/doc/sqlite3/c3ref/uri_boolean.html | |
205 | share/doc/sqlite3/c3ref/user_data.html | 205 | share/doc/sqlite3/c3ref/user_data.html | |
206 | share/doc/sqlite3/c3ref/value.html | 206 | share/doc/sqlite3/c3ref/value.html | |
207 | share/doc/sqlite3/c3ref/value_blob.html | 207 | share/doc/sqlite3/c3ref/value_blob.html | |
208 | share/doc/sqlite3/c3ref/value_dup.html | 208 | share/doc/sqlite3/c3ref/value_dup.html | |
209 | share/doc/sqlite3/c3ref/value_subtype.html | 209 | share/doc/sqlite3/c3ref/value_subtype.html | |
210 | share/doc/sqlite3/c3ref/vfs.html | 210 | share/doc/sqlite3/c3ref/vfs.html | |
211 | share/doc/sqlite3/c3ref/vfs_find.html | 211 | share/doc/sqlite3/c3ref/vfs_find.html | |
212 | share/doc/sqlite3/c3ref/vtab.html | 212 | share/doc/sqlite3/c3ref/vtab.html | |
213 | share/doc/sqlite3/c3ref/vtab_collation.html | 213 | share/doc/sqlite3/c3ref/vtab_collation.html | |
214 | share/doc/sqlite3/c3ref/vtab_config.html | 214 | share/doc/sqlite3/c3ref/vtab_config.html | |
215 | share/doc/sqlite3/c3ref/vtab_cursor.html | 215 | share/doc/sqlite3/c3ref/vtab_cursor.html | |
216 | share/doc/sqlite3/c3ref/vtab_distinct.html | |||
217 | share/doc/sqlite3/c3ref/vtab_in.html | |||
218 | share/doc/sqlite3/c3ref/vtab_in_first.html | |||
216 | share/doc/sqlite3/c3ref/vtab_nochange.html | 219 | share/doc/sqlite3/c3ref/vtab_nochange.html | |
217 | share/doc/sqlite3/c3ref/vtab_on_conflict.html | 220 | share/doc/sqlite3/c3ref/vtab_on_conflict.html | |
221 | share/doc/sqlite3/c3ref/vtab_rhs_value.html | |||
218 | share/doc/sqlite3/c3ref/wal_autocheckpoint.html | 222 | share/doc/sqlite3/c3ref/wal_autocheckpoint.html | |
219 | share/doc/sqlite3/c3ref/wal_checkpoint.html | 223 | share/doc/sqlite3/c3ref/wal_checkpoint.html | |
220 | share/doc/sqlite3/c3ref/wal_checkpoint_v2.html | 224 | share/doc/sqlite3/c3ref/wal_checkpoint_v2.html | |
221 | share/doc/sqlite3/c3ref/wal_hook.html | 225 | share/doc/sqlite3/c3ref/wal_hook.html | |
222 | share/doc/sqlite3/c3ref/win32_set_directory.html | 226 | share/doc/sqlite3/c3ref/win32_set_directory.html | |
223 | share/doc/sqlite3/c_interface.html | 227 | share/doc/sqlite3/c_interface.html | |
224 | share/doc/sqlite3/capi3.html | 228 | share/doc/sqlite3/capi3.html | |
225 | share/doc/sqlite3/capi3ref.html | 229 | share/doc/sqlite3/capi3ref.html | |
226 | share/doc/sqlite3/carray.html | 230 | share/doc/sqlite3/carray.html | |
227 | share/doc/sqlite3/changes.html | 231 | share/doc/sqlite3/changes.html | |
228 | share/doc/sqlite3/chronology.html | 232 | share/doc/sqlite3/chronology.html | |
229 | share/doc/sqlite3/cintro.html | 233 | share/doc/sqlite3/cintro.html | |
230 | share/doc/sqlite3/cksumvfs.html | 234 | share/doc/sqlite3/cksumvfs.html | |
@@ -627,26 +631,27 @@ share/doc/sqlite3/releaselog/3_32_3.html | @@ -627,26 +631,27 @@ share/doc/sqlite3/releaselog/3_32_3.html | |||
627 | share/doc/sqlite3/releaselog/3_33_0.html | 631 | share/doc/sqlite3/releaselog/3_33_0.html | |
628 | share/doc/sqlite3/releaselog/3_34_0.html | 632 | share/doc/sqlite3/releaselog/3_34_0.html | |
629 | share/doc/sqlite3/releaselog/3_34_1.html | 633 | share/doc/sqlite3/releaselog/3_34_1.html | |
630 | share/doc/sqlite3/releaselog/3_35_0.html | 634 | share/doc/sqlite3/releaselog/3_35_0.html | |
631 | share/doc/sqlite3/releaselog/3_35_1.html | 635 | share/doc/sqlite3/releaselog/3_35_1.html | |
632 | share/doc/sqlite3/releaselog/3_35_2.html | 636 | share/doc/sqlite3/releaselog/3_35_2.html | |
633 | share/doc/sqlite3/releaselog/3_35_3.html | 637 | share/doc/sqlite3/releaselog/3_35_3.html | |
634 | share/doc/sqlite3/releaselog/3_35_4.html | 638 | share/doc/sqlite3/releaselog/3_35_4.html | |
635 | share/doc/sqlite3/releaselog/3_35_5.html | 639 | share/doc/sqlite3/releaselog/3_35_5.html | |
636 | share/doc/sqlite3/releaselog/3_36_0.html | 640 | share/doc/sqlite3/releaselog/3_36_0.html | |
637 | share/doc/sqlite3/releaselog/3_37_0.html | 641 | share/doc/sqlite3/releaselog/3_37_0.html | |
638 | share/doc/sqlite3/releaselog/3_37_1.html | 642 | share/doc/sqlite3/releaselog/3_37_1.html | |
639 | share/doc/sqlite3/releaselog/3_37_2.html | 643 | share/doc/sqlite3/releaselog/3_37_2.html | |
644 | share/doc/sqlite3/releaselog/3_38_0.html | |||
640 | share/doc/sqlite3/releaselog/3_3_0.html | 645 | share/doc/sqlite3/releaselog/3_3_0.html | |
641 | share/doc/sqlite3/releaselog/3_3_1.html | 646 | share/doc/sqlite3/releaselog/3_3_1.html | |
642 | share/doc/sqlite3/releaselog/3_3_10.html | 647 | share/doc/sqlite3/releaselog/3_3_10.html | |
643 | share/doc/sqlite3/releaselog/3_3_11.html | 648 | share/doc/sqlite3/releaselog/3_3_11.html | |
644 | share/doc/sqlite3/releaselog/3_3_12.html | 649 | share/doc/sqlite3/releaselog/3_3_12.html | |
645 | share/doc/sqlite3/releaselog/3_3_13.html | 650 | share/doc/sqlite3/releaselog/3_3_13.html | |
646 | share/doc/sqlite3/releaselog/3_3_14.html | 651 | share/doc/sqlite3/releaselog/3_3_14.html | |
647 | share/doc/sqlite3/releaselog/3_3_15.html | 652 | share/doc/sqlite3/releaselog/3_3_15.html | |
648 | share/doc/sqlite3/releaselog/3_3_16.html | 653 | share/doc/sqlite3/releaselog/3_3_16.html | |
649 | share/doc/sqlite3/releaselog/3_3_17.html | 654 | share/doc/sqlite3/releaselog/3_3_17.html | |
650 | share/doc/sqlite3/releaselog/3_3_2.html | 655 | share/doc/sqlite3/releaselog/3_3_2.html | |
651 | share/doc/sqlite3/releaselog/3_3_3.html | 656 | share/doc/sqlite3/releaselog/3_3_3.html | |
652 | share/doc/sqlite3/releaselog/3_3_4.html | 657 | share/doc/sqlite3/releaselog/3_3_4.html |
@@ -1,5 +1,5 @@ | @@ -1,5 +1,5 @@ | |||
1 | $NetBSD: distinfo,v 1.110 2022/01/07 21:06:28 adam Exp $ | 1 | $NetBSD: distinfo,v 1.111 2022/02/23 17:07:36 adam Exp $ | |
2 | 2 | |||
3 | BLAKE2s (sqlite-doc-3370200.zip) = 1e2232c02989f511a9809b02702dc9af71884d956f1a60ef1d0cb99da89a7cc4 | 3 | BLAKE2s (sqlite-doc-3380000.zip) = 86d1732125b456fdfb4b86131ff4b2ac27aec58eef4a31044b2167ef24aaa9b7 | |
4 | SHA512 (sqlite-doc-3370200.zip) = 02c68a3906aee3fd05a4340549144032a239e5ab885d9b3b09236ed2b74a90c770de373e4ca9f99e72f92df090d0fb6789213fb361e954d9dd6709af20336857 | 4 | SHA512 (sqlite-doc-3380000.zip) = 8e1f77504a1057cd23a8a6c2a285d63c5df50ceaf6ab84054a6f5422286dd868bdb3d5bd9be180b7834caba2b65ca185ffff60455bb504df30801157b62a62ef | |
5 | Size (sqlite-doc-3370200.zip) = 10542395 bytes | 5 | Size (sqlite-doc-3380000.zip) = 10603776 bytes |
@@ -1,6 +1,6 @@ | @@ -1,6 +1,6 @@ | |||
1 | $NetBSD: distinfo,v 1.122 2022/01/07 21:06:28 adam Exp $ | 1 | $NetBSD: distinfo,v 1.123 2022/02/23 17:07:37 adam Exp $ | |
2 | 2 | |||
3 | BLAKE2s (sqlite-autoconf-3370200.tar.gz) = 02e087a45653742a3a3e949f3a617eb5f54300ada84e075a910a262a8575cf32 | 3 | BLAKE2s (sqlite-autoconf-3380000.tar.gz) = 4fd427938f2d2e2436b5e7c8e8d7b143654a6a98e51a7099d526fdd0be71742c | |
4 | SHA512 (sqlite-autoconf-3370200.tar.gz) = d41049ce4a2007c57f81c54b1cdc3f812abbfafd40736134604392ab16d2d4c29e40f4b927f1deb133b128a869cfdb3434c8640ec227bc4a5da1686024f65d4e | 4 | SHA512 (sqlite-autoconf-3380000.tar.gz) = 30577730e54ac4f83acfe0ff2fac9cb2ba6eb917907d7584f2b18ca852382f2f4ff596e1e1cd4ce41fe90ac271501ee97b5e508b7e5072cda713855aae562d28 | |
5 | Size (sqlite-autoconf-3370200.tar.gz) = 3001797 bytes | 5 | Size (sqlite-autoconf-3380000.tar.gz) = 3030934 bytes | |
6 | SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 | 6 | SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 |
@@ -1,5 +1,5 @@ | @@ -1,5 +1,5 @@ | |||
1 | $NetBSD: distinfo,v 1.51 2022/01/07 21:06:28 adam Exp $ | 1 | $NetBSD: distinfo,v 1.52 2022/02/23 17:07:37 adam Exp $ | |
2 | 2 | |||
3 | BLAKE2s (sqlite-src-3370200.zip) = bebcb8c5cfd84f8b39edc09b8b999d36a8341d4d6856ba8cd851bc9d6daf4d12 | 3 | BLAKE2s (sqlite-src-3380000.zip) = 1239ff74cd5245e1f5180438a595a0ee68b17c277b8877ca3b6acf87afc5da80 | |
4 | SHA512 (sqlite-src-3370200.zip) = 2db103965934bb34c8336cf82ff7d77e75dc1ca00fa6324ac5697f3bf4b41bffff355dec7593515a68816449e5c9827a9503f6d7841c4c13981c231d3414ff76 | 4 | SHA512 (sqlite-src-3380000.zip) = 9f4d3c406df5e6290f3f0b5e24b568723ab54bb085cb8cd7621ab42b0b8cd4f76e9784a4a29b42ea8cb0d1b7d759267c3cd980913d490d08e7172df05949131d | |
5 | Size (sqlite-src-3370200.zip) = 13145234 bytes | 5 | Size (sqlite-src-3380000.zip) = 13236840 bytes |