pkgsrc-Changes-HG archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/f38316b7286b
branches:  trunk
changeset: 770309:f38316b7286b
user:      adam <adam%pkgsrc.org@localhost>
date:      Sun Nov 28 20:48:28 2021 +0000

description:
sqlite3: updated to 3.37.0

SQLite Release 3.37.0 On 2021-11-27

STRICT tables provide a prescriptive style of data type management, for developers who prefer that kind of thing.
When adding columns that contain a CHECK constraint or a generated column containing a NOT NULL constraint, the ALTER TABLE ADD COLUMN now checks new constraints against preexisting rows in the 
database and will only proceed if no constraints are violated.
Added the PRAGMA table_list statement.
CLI enhancements:
Add the .connection command, allowing the CLI to keep multiple database connections open at the same time.
Add the --safe command-line option that disables dot-commands and SQL statements that might cause side-effects that extend beyond the single database file named on the command-line.
Performance improvements when reading SQL statements that span many lines.
Added the sqlite3_autovacuum_pages() interface.
The sqlite3_deserialize() does not and has never worked for the TEMP database. That limitation is now noted in the documentation.
The query planner now omits ORDER BY clauses on subqueries and views if removing those clauses does not change the semantics of the query.
The generate_series table-valued function extension is modified so that the first parameter ("START") is now required. This is done as a way to demonstrate how to write table-valued functions with 
required parameters. The legacy behavior is available using the -DZERO_ARGUMENT_GENERATE_SERIES compile-time option.
Added new sqlite3_changes64() and sqlite3_total_changes64() interfaces.
Added the SQLITE_OPEN_EXRESCODE flag option to sqlite3_open_v2().
Use less memory to hold the database schema.

diffstat:

 databases/sqlite3-docs/PLIST            |   7 ++++-
 databases/sqlite3-docs/distinfo         |   8 ++--
 databases/sqlite3-tcl/distinfo          |   8 ++--
 databases/sqlite3/Makefile              |   3 +-
 databases/sqlite3/Makefile.common       |   6 ++--
 databases/sqlite3/distinfo              |   9 ++---
 databases/sqlite3/patches/patch-shell.c |  48 ---------------------------------
 devel/lemon/distinfo                    |   8 ++--
 8 files changed, 26 insertions(+), 71 deletions(-)

diffs (190 lines):

diff -r 9b5ce20cc1e0 -r f38316b7286b databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Sun Nov 28 20:27:45 2021 +0000
+++ b/databases/sqlite3-docs/PLIST      Sun Nov 28 20:48:28 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.104 2021/06/25 21:21:31 adam Exp $
+@comment $NetBSD: PLIST,v 1.105 2021/11/28 20:48:28 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -20,6 +20,7 @@
 share/doc/sqlite3/c3ref/aggregate_count.html
 share/doc/sqlite3/c3ref/api_routines.html
 share/doc/sqlite3/c3ref/auto_extension.html
+share/doc/sqlite3/c3ref/autovacuum_pages.html
 share/doc/sqlite3/c3ref/backup.html
 share/doc/sqlite3/c3ref/backup_finish.html
 share/doc/sqlite3/c3ref/bind_blob.html
@@ -270,6 +271,7 @@
 share/doc/sqlite3/fileformat.html
 share/doc/sqlite3/fileformat2.html
 share/doc/sqlite3/fileio.html
+share/doc/sqlite3/flextypegood.html
 share/doc/sqlite3/floatingpoint.html
 share/doc/sqlite3/footprint.html
 share/doc/sqlite3/foreignkeys.html
@@ -631,6 +633,7 @@
 share/doc/sqlite3/releaselog/3_35_4.html
 share/doc/sqlite3/releaselog/3_35_5.html
 share/doc/sqlite3/releaselog/3_36_0.html
+share/doc/sqlite3/releaselog/3_37_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
@@ -829,6 +832,7 @@
 share/doc/sqlite3/sqlite.css~
 share/doc/sqlite3/sqlite.html
 share/doc/sqlite3/stmt.html
+share/doc/sqlite3/stricttables.html
 share/doc/sqlite3/support.html
 share/doc/sqlite3/swarmvtab.html
 share/doc/sqlite3/syntax.html
@@ -892,6 +896,7 @@
 share/doc/sqlite3/syntax/sql-stmt-list.html
 share/doc/sqlite3/syntax/sql-stmt.html
 share/doc/sqlite3/syntax/table-constraint.html
+share/doc/sqlite3/syntax/table-options.html
 share/doc/sqlite3/syntax/table-or-subquery.html
 share/doc/sqlite3/syntax/type-name.html
 share/doc/sqlite3/syntax/update-stmt-limited.html
diff -r 9b5ce20cc1e0 -r f38316b7286b databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Sun Nov 28 20:27:45 2021 +0000
+++ b/databases/sqlite3-docs/distinfo   Sun Nov 28 20:48:28 2021 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.107 2021/10/26 10:10:05 nia Exp $
+$NetBSD: distinfo,v 1.108 2021/11/28 20:48:28 adam Exp $
 
-BLAKE2s (sqlite-doc-3360000.zip) = 4bf60a58ed2f84cb9993fec9723875b6e67d15c230c2a6829a010355a22c4db4
-SHA512 (sqlite-doc-3360000.zip) = c9b5628f823c322688e2fcce0effe7564dccaf8bcdbb3397ee09c433975bfb5fd63fd81830c5c6d573314e1e55d25cdf1b3842d798f7be63b9b88b32f6694add
-Size (sqlite-doc-3360000.zip) = 12274411 bytes
+BLAKE2s (sqlite-doc-3370000.zip) = 805b096d27353253ddf402e7a3447ee58628bdfb4ca89a633683345a4cf10522
+SHA512 (sqlite-doc-3370000.zip) = f245731675c67347318578e773b8d5f548c26eac7a333d6028cf7e11c4c9d2c3314da0a5428533ff26416f4194dce5c805d7f61f1fef27e02e9b91efa3c6d4c7
+Size (sqlite-doc-3370000.zip) = 10509325 bytes
diff -r 9b5ce20cc1e0 -r f38316b7286b databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Sun Nov 28 20:27:45 2021 +0000
+++ b/databases/sqlite3-tcl/distinfo    Sun Nov 28 20:48:28 2021 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.119 2021/10/26 10:10:05 nia Exp $
+$NetBSD: distinfo,v 1.120 2021/11/28 20:48:29 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3360000.tar.gz) = 41933bf3a5296420336e87d7b1a4acecc685f7433035c5c339de1545f25d5863
-SHA512 (sqlite-autoconf-3360000.tar.gz) = e59c57f421b4956c7759af528a2da929167e15179ab9d28267474683e2272f93c901203e5a648732f1a3d43e7be3ac4217c3cdd7adf108c378b9127b771a7cd0
-Size (sqlite-autoconf-3360000.tar.gz) = 2977080 bytes
+BLAKE2s (sqlite-autoconf-3370000.tar.gz) = df964e39d338c8a4ba4fecd8a0be9d1b8536867cd0b8e27ed168fc8c202200fb
+SHA512 (sqlite-autoconf-3370000.tar.gz) = 413655d7b61b4d0a510bc42eb2e4f3e801ff35dee7d825d84b8397c956f23c5eac6a1a73134d3d7a63e40704968a4607d5762a137557e688ec5f87efb5b729ea
+Size (sqlite-autoconf-3370000.tar.gz) = 3001298 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
diff -r 9b5ce20cc1e0 -r f38316b7286b databases/sqlite3/Makefile
--- a/databases/sqlite3/Makefile        Sun Nov 28 20:27:45 2021 +0000
+++ b/databases/sqlite3/Makefile        Sun Nov 28 20:48:28 2021 +0000
@@ -1,10 +1,9 @@
-# $NetBSD: Makefile,v 1.142 2021/10/17 07:14:27 wiz Exp $
+# $NetBSD: Makefile,v 1.143 2021/11/28 20:48:28 adam Exp $
 
 .include "Makefile.common"
 
 DISTNAME=      sqlite-autoconf-${SQLITE3_DISTVERSION}
 PKGNAME=       sqlite3-${SQLITE3_VERSION}
-PKGREVISION=   1
 CATEGORIES=    databases
 
 MAINTAINER=    pkgsrc-users%NetBSD.org@localhost
diff -r 9b5ce20cc1e0 -r f38316b7286b databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Sun Nov 28 20:27:45 2021 +0000
+++ b/databases/sqlite3/Makefile.common Sun Nov 28 20:48:28 2021 +0000
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.81 2021/06/25 21:21:31 adam Exp $
+# $NetBSD: Makefile.common,v 1.82 2021/11/28 20:48:28 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=   3360000
-SQLITE3_VERSION=       3.36.0
+SQLITE3_DISTVERSION=   3370000
+SQLITE3_VERSION=       3.37.0
 
 MASTER_SITES=  http://www.sqlite.org/2021/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2021/
diff -r 9b5ce20cc1e0 -r f38316b7286b databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Sun Nov 28 20:27:45 2021 +0000
+++ b/databases/sqlite3/distinfo        Sun Nov 28 20:48:28 2021 +0000
@@ -1,7 +1,6 @@
-$NetBSD: distinfo,v 1.174 2021/10/26 10:10:05 nia Exp $
+$NetBSD: distinfo,v 1.175 2021/11/28 20:48:28 adam Exp $
 
-BLAKE2s (sqlite-autoconf-3360000.tar.gz) = 41933bf3a5296420336e87d7b1a4acecc685f7433035c5c339de1545f25d5863
-SHA512 (sqlite-autoconf-3360000.tar.gz) = e59c57f421b4956c7759af528a2da929167e15179ab9d28267474683e2272f93c901203e5a648732f1a3d43e7be3ac4217c3cdd7adf108c378b9127b771a7cd0
-Size (sqlite-autoconf-3360000.tar.gz) = 2977080 bytes
+BLAKE2s (sqlite-autoconf-3370000.tar.gz) = df964e39d338c8a4ba4fecd8a0be9d1b8536867cd0b8e27ed168fc8c202200fb
+SHA512 (sqlite-autoconf-3370000.tar.gz) = 413655d7b61b4d0a510bc42eb2e4f3e801ff35dee7d825d84b8397c956f23c5eac6a1a73134d3d7a63e40704968a4607d5762a137557e688ec5f87efb5b729ea
+Size (sqlite-autoconf-3370000.tar.gz) = 3001298 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4
-SHA1 (patch-shell.c) = d20cddef6cf75753c78d95b7dd1ae928caba5df6
diff -r 9b5ce20cc1e0 -r f38316b7286b databases/sqlite3/patches/patch-shell.c
--- a/databases/sqlite3/patches/patch-shell.c   Sun Nov 28 20:27:45 2021 +0000
+++ /dev/null   Thu Jan 01 00:00:00 1970 +0000
@@ -1,48 +0,0 @@
-$NetBSD: patch-shell.c,v 1.1 2021/10/17 07:14:27 wiz Exp $
-
-Fix Segmentation fault in idxGetTableInfo (CVE-2021-36690)
-https://sqlite.org/src/info/b1e0c22ec981cf5f
-
---- shell.c.orig       2021-06-18 18:52:24.000000000 +0000
-+++ shell.c
-@@ -9852,11 +9852,13 @@ static int idxGetTableInfo(
-   rc = idxPrintfPrepareStmt(db, &p1, pzErrmsg, "PRAGMA table_xinfo=%Q", zTab);
-   while( rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(p1) ){
-     const char *zCol = (const char*)sqlite3_column_text(p1, 1);
-+    const char *zColSeq = 0;
-     nByte += 1 + STRLEN(zCol);
-     rc = sqlite3_table_column_metadata(
--        db, "main", zTab, zCol, 0, &zCol, 0, 0, 0
-+        db, "main", zTab, zCol, 0, &zColSeq, 0, 0, 0
-     );
--    nByte += 1 + STRLEN(zCol);
-+    if( zColSeq==0 ) zColSeq = "binary";
-+    nByte += 1 + STRLEN(zColSeq);
-     nCol++;
-     nPk += (sqlite3_column_int(p1, 5)>0);
-   }
-@@ -9876,6 +9878,7 @@ static int idxGetTableInfo(
-   nCol = 0;
-   while( rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(p1) ){
-     const char *zCol = (const char*)sqlite3_column_text(p1, 1);
-+    const char *zColSeq = 0;
-     int nCopy = STRLEN(zCol) + 1;
-     pNew->aCol[nCol].zName = pCsr;
-     pNew->aCol[nCol].iPk = (sqlite3_column_int(p1, 5)==1 && nPk==1);
-@@ -9883,12 +9886,13 @@ static int idxGetTableInfo(
-     pCsr += nCopy;
- 
-     rc = sqlite3_table_column_metadata(
--        db, "main", zTab, zCol, 0, &zCol, 0, 0, 0
-+        db, "main", zTab, zCol, 0, &zColSeq, 0, 0, 0
-     );
-     if( rc==SQLITE_OK ){
--      nCopy = STRLEN(zCol) + 1;
-+      if( zColSeq==0 ) zColSeq = "binary";
-+      nCopy = STRLEN(zColSeq) + 1;
-       pNew->aCol[nCol].zColl = pCsr;
--      memcpy(pCsr, zCol, nCopy);
-+      memcpy(pCsr, zColSeq, nCopy);
-       pCsr += nCopy;
-     }
- 
diff -r 9b5ce20cc1e0 -r f38316b7286b devel/lemon/distinfo
--- a/devel/lemon/distinfo      Sun Nov 28 20:27:45 2021 +0000
+++ b/devel/lemon/distinfo      Sun Nov 28 20:48:28 2021 +0000
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.48 2021/10/26 10:15:13 nia Exp $
+$NetBSD: distinfo,v 1.49 2021/11/28 20:48:29 adam Exp $
 
-BLAKE2s (sqlite-src-3360000.zip) = 9a7d289fd601660861657b5b5b5131a8f7409bb1b894056275154079d976890e
-SHA512 (sqlite-src-3360000.zip) = 4083f96265c59001d21dce4d0288ddc6ea80ae079cbce2144c0fc3200b1904fd0d665fc54b08978c6b818527580042cde025c03b73d20d0bc56ccbeb75a330c3
-Size (sqlite-src-3360000.zip) = 12985683 bytes
+BLAKE2s (sqlite-src-3370000.zip) = 0925ae0bdd00ab5371f9145510a2cc0a5dc3a6596b7bfbfc4ff729569762448f
+SHA512 (sqlite-src-3370000.zip) = 5a3c358c42782bc248a0795ca78a10d834861f98ab0a021a05d8358ba1716f3febb3da29ded187dfd205902f77bbf284ed3207aabe4979b68b90d0557d1676f7
+Size (sqlite-src-3370000.zip) = 13141152 bytes
Home | Main Index | Thread Index | Old Index