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

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/cf8ed3938db4
branches:  trunk
changeset: 449400:cf8ed3938db4
user:      adam <adam%pkgsrc.org@localhost>
date:      Tue Mar 30 07:51:16 2021 +0000

description:
sqlite3: updated to 3.35.3

changes in version 3.35.3

Enhance the OP_OpenDup opcode of the bytecode engine so that it works even if the cursor being duplicated itself came from OP_OpenDup. Fix for ticket bb8a9fd4a9b7fce5. This problem only came to light 
due to the recent MATERIALIZED hint enhancement.
When materializing correlated common table expressions, do so separately for each use case, as that is required for correctness. This fixes a problem that was introduced by the MATERIALIZED hint 
enhancement.
Fix a problem in the filename normalizer of the unix VFS.
Fix the "box" output mode in the CLI so that it works with statements that returns one or more rows of zero columns (such as PRAGMA incremental_vacuum). Forum post afbbcb5b72.
Improvements to error messages generated by faulty common table expressions. Forum post aa5a0431c99e.
Fix some incorrect assert() statements.
Fix to the SELECT statement syntax diagram so that the FROM clause syntax is shown correctly. Forum post 9ed02582fe.
Fix the EBCDIC character classifier so that it understands newlines as whitespace. Forum post 58540ce22dcd.
Improvements the xBestIndex method in the implementation of the (unsupported) wholenumber virtual table extension so that it does a better job of convincing the query planner to avoid trying to 
materialize a table with an infinite number of rows.

diffstat:

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

diffs (98 lines):

diff -r c7c1262993dd -r cf8ed3938db4 databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST      Tue Mar 30 06:59:59 2021 +0000
+++ b/databases/sqlite3-docs/PLIST      Tue Mar 30 07:51:16 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.100 2021/03/19 06:29:04 adam Exp $
+@comment $NetBSD: PLIST,v 1.101 2021/03/30 07:51:16 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -625,6 +625,7 @@
 share/doc/sqlite3/releaselog/3_35_0.html
 share/doc/sqlite3/releaselog/3_35_1.html
 share/doc/sqlite3/releaselog/3_35_2.html
+share/doc/sqlite3/releaselog/3_35_3.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 c7c1262993dd -r cf8ed3938db4 databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo   Tue Mar 30 06:59:59 2021 +0000
+++ b/databases/sqlite3-docs/distinfo   Tue Mar 30 07:51:16 2021 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.101 2021/03/19 06:29:04 adam Exp $
+$NetBSD: distinfo,v 1.102 2021/03/30 07:51:16 adam Exp $
 
-SHA1 (sqlite-doc-3350200.zip) = 3eccd32a15eb373b17ccdd07f91e14d21c7a11e8
-RMD160 (sqlite-doc-3350200.zip) = 5c711e25c5ecfa6acb792677f61ae27bc7b4e078
-SHA512 (sqlite-doc-3350200.zip) = 7ef973b804d059cf00c759a0ae001b7714df0472398e7cd55e34f59222df816a36511cefd15fa99abf67dec4291ee6babbc12bd87855194608ff556a5c1182ae
-Size (sqlite-doc-3350200.zip) = 10182547 bytes
+SHA1 (sqlite-doc-3350300.zip) = 0c75508aef66faef262aea1e69062dd1343e1b94
+RMD160 (sqlite-doc-3350300.zip) = 26de1f96ad13bbbc9d2cf164369f18f9cec70242
+SHA512 (sqlite-doc-3350300.zip) = 260981abaf54f452777e37e99474d100010ec2340c740f78445b7794fa17bcbb814e90f004f870d929a9ccab1d89417ee3d65ffe3b65dbf511ca1de7b6a6a4c8
+Size (sqlite-doc-3350300.zip) = 10197905 bytes
diff -r c7c1262993dd -r cf8ed3938db4 databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo    Tue Mar 30 06:59:59 2021 +0000
+++ b/databases/sqlite3-tcl/distinfo    Tue Mar 30 07:51:16 2021 +0000
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.113 2021/03/19 06:29:04 adam Exp $
+$NetBSD: distinfo,v 1.114 2021/03/30 07:51:16 adam Exp $
 
-SHA1 (sqlite-autoconf-3350200.tar.gz) = ba6994db6d4ffd2797b9340aeb4ad8bd616176f8
-RMD160 (sqlite-autoconf-3350200.tar.gz) = 394c3c2b7212a60e2c9bf1d46306b53be6e433fd
-SHA512 (sqlite-autoconf-3350200.tar.gz) = a755c8647028aee9f862533c5e14a9b8627f494b205962798715ed27010e8fda3074f0da005d8c89c560a86b7510a425bf886824cf2de3f2bf129e5d95eb7d1f
-Size (sqlite-autoconf-3350200.tar.gz) = 2955661 bytes
+SHA1 (sqlite-autoconf-3350300.tar.gz) = d592a0c3ecc28bdb4169b3f108b7ee4b9c675f3b
+RMD160 (sqlite-autoconf-3350300.tar.gz) = 8b3decbed3140ea0a8519694b30ffc3fd658d4cb
+SHA512 (sqlite-autoconf-3350300.tar.gz) = b683d359fab5fe90bf58f059d640831b879dff4c9239f983b06bdf5d710c03adec563e5b143d68e7448f036794185b49d4cc602d3b71ff2629c0eaeb1b3ad79e
+Size (sqlite-autoconf-3350300.tar.gz) = 2956098 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
diff -r c7c1262993dd -r cf8ed3938db4 databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Tue Mar 30 06:59:59 2021 +0000
+++ b/databases/sqlite3/Makefile.common Tue Mar 30 07:51:16 2021 +0000
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.77 2021/03/19 06:29:03 adam Exp $
+# $NetBSD: Makefile.common,v 1.78 2021/03/30 07:51:16 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=   3350200
-SQLITE3_VERSION=       3.35.2
+SQLITE3_DISTVERSION=   3350300
+SQLITE3_VERSION=       3.35.3
 
 MASTER_SITES=  http://www.sqlite.org/2021/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2021/
diff -r c7c1262993dd -r cf8ed3938db4 databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo        Tue Mar 30 06:59:59 2021 +0000
+++ b/databases/sqlite3/distinfo        Tue Mar 30 07:51:16 2021 +0000
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.167 2021/03/19 06:29:03 adam Exp $
+$NetBSD: distinfo,v 1.168 2021/03/30 07:51:16 adam Exp $
 
-SHA1 (sqlite-autoconf-3350200.tar.gz) = ba6994db6d4ffd2797b9340aeb4ad8bd616176f8
-RMD160 (sqlite-autoconf-3350200.tar.gz) = 394c3c2b7212a60e2c9bf1d46306b53be6e433fd
-SHA512 (sqlite-autoconf-3350200.tar.gz) = a755c8647028aee9f862533c5e14a9b8627f494b205962798715ed27010e8fda3074f0da005d8c89c560a86b7510a425bf886824cf2de3f2bf129e5d95eb7d1f
-Size (sqlite-autoconf-3350200.tar.gz) = 2955661 bytes
+SHA1 (sqlite-autoconf-3350300.tar.gz) = d592a0c3ecc28bdb4169b3f108b7ee4b9c675f3b
+RMD160 (sqlite-autoconf-3350300.tar.gz) = 8b3decbed3140ea0a8519694b30ffc3fd658d4cb
+SHA512 (sqlite-autoconf-3350300.tar.gz) = b683d359fab5fe90bf58f059d640831b879dff4c9239f983b06bdf5d710c03adec563e5b143d68e7448f036794185b49d4cc602d3b71ff2629c0eaeb1b3ad79e
+Size (sqlite-autoconf-3350300.tar.gz) = 2956098 bytes
 SHA1 (patch-configure) = c0aa83bddc20d090b3cd2fd840ac69031f4396e4
diff -r c7c1262993dd -r cf8ed3938db4 devel/lemon/distinfo
--- a/devel/lemon/distinfo      Tue Mar 30 06:59:59 2021 +0000
+++ b/devel/lemon/distinfo      Tue Mar 30 07:51:16 2021 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.42 2021/03/19 06:29:04 adam Exp $
+$NetBSD: distinfo,v 1.43 2021/03/30 07:51:16 adam Exp $
 
-SHA1 (sqlite-src-3350200.zip) = 4b1f70ce7a35f7f4e1c0962f90139f6b1edacf88
-RMD160 (sqlite-src-3350200.zip) = e8601f0a35bc9052b3c56a240b1466eb0327ab29
-SHA512 (sqlite-src-3350200.zip) = d5382bf31d812bc51533d28a583c78d3f389b1ecbe1f9f30cc755059f2867f832c0529e9f97b090be5c5bc855c45611b220b8c29b5648c451490566a70cc5122
-Size (sqlite-src-3350200.zip) = 12815298 bytes
+SHA1 (sqlite-src-3350300.zip) = 0c1421ab234453a9746af6fbbcd2f1d303b8dd9d
+RMD160 (sqlite-src-3350300.zip) = c9404605c888a1b74d3e2d79952ce89520bd4a3b
+SHA512 (sqlite-src-3350300.zip) = 5b994833e37e5f7579f4e3eefbbadd5b2a3d691b5f662b7d3dc2bbf80ff1cdaf89262ce5612513fcb2daa0a7d1db3de871dfc462f9d162c954593ff7f4ad90fd
+Size (sqlite-src-3350300.zip) = 12817388 bytes