Wed Nov 7 11:51:25 2018 UTC ()
sqlite3: updated to 3.25.3

SQLite Release 3.25.3:
Disallow the use of window functions in the recursive part of a CTE.
Fix the behavior of typeof() and length() on virtual tables.
Strengthen defenses against deliberately corrupted database files.
Fix a problem in the query planner that results when a row-value expression is used with a PRIMARY KEY with redundant columns.
Fix the query planner so that it works correctly for IS NOT NULL operators in the ON clause of a LEFT JOIN with the SQLITE_ENABLE_STAT4 compile-time option.


(adam)
diff -r1.57 -r1.58 pkgsrc/databases/sqlite3/Makefile.common
diff -r1.146 -r1.147 pkgsrc/databases/sqlite3/distinfo
diff -r1.44 -r1.45 pkgsrc/databases/sqlite3-docs/Makefile
diff -r1.93 -r1.94 pkgsrc/databases/sqlite3-tcl/distinfo
diff -r1.22 -r1.23 pkgsrc/devel/lemon/distinfo

cvs diff -r1.57 -r1.58 pkgsrc/databases/sqlite3/Makefile.common (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/Makefile.common 2018/10/01 08:02:37 1.57
+++ pkgsrc/databases/sqlite3/Makefile.common 2018/11/07 11:51:25 1.58
@@ -1,15 +1,15 @@ @@ -1,15 +1,15 @@
1# $NetBSD: Makefile.common,v 1.57 2018/10/01 08:02:37 adam Exp $ 1# $NetBSD: Makefile.common,v 1.58 2018/11/07 11:51:25 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
8SQLITE3_DISTVERSION= 3250200 8SQLITE3_DISTVERSION= 3250300
9SQLITE3_VERSION= 3.25.2 9SQLITE3_VERSION= 3.25.3
10 10
11MASTER_SITES= http://www.sqlite.org/2018/ 11MASTER_SITES= http://www.sqlite.org/2018/
12MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2018/ 12MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2018/
13 13
14HOMEPAGE?= http://www.sqlite.org/ 14HOMEPAGE?= http://www.sqlite.org/
15LICENSE= public-domain 15LICENSE= public-domain

cvs diff -r1.146 -r1.147 pkgsrc/databases/sqlite3/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/distinfo 2018/10/01 08:02:37 1.146
+++ pkgsrc/databases/sqlite3/distinfo 2018/11/07 11:51:25 1.147
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.146 2018/10/01 08:02:37 adam Exp $ 1$NetBSD: distinfo,v 1.147 2018/11/07 11:51:25 adam Exp $
2 2
3SHA1 (sqlite-autoconf-3250200.tar.gz) = aedfbdc14eb700099434d6a743135743cff47393 3SHA1 (sqlite-autoconf-3250300.tar.gz) = 5d6dc7634ec59e7a6fffa8758c1e184b2522c2e5
4RMD160 (sqlite-autoconf-3250200.tar.gz) = a360883c9616a02a8690560aa93b8c9e1a07bc99 4RMD160 (sqlite-autoconf-3250300.tar.gz) = 98578994f8edaac730ff18f0196eb2220b88492d
5SHA512 (sqlite-autoconf-3250200.tar.gz) = 5ef9a6dfbb0822257af1a3a379785a95ab02edecbbb53b57074ddd0b8dc294fc07cbb9a8a7acc4e1640fb1743525ed6331fecebbddce01bc017330b20e127ad9 5SHA512 (sqlite-autoconf-3250300.tar.gz) = 5bc501d15367e097f4070185974b0c3a8246c06b205fb2258ed18870ff3fbf120ac5e0ba031a6744af89f7659206e28e7de2f0367bdb190b8412e453b43de4ba
6Size (sqlite-autoconf-3250200.tar.gz) = 2763876 bytes 6Size (sqlite-autoconf-3250300.tar.gz) = 2764429 bytes

cvs diff -r1.44 -r1.45 pkgsrc/databases/sqlite3-docs/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-docs/Makefile 2018/04/03 19:58:19 1.44
+++ pkgsrc/databases/sqlite3-docs/Makefile 2018/11/07 11:51:25 1.45
@@ -1,17 +1,21 @@ @@ -1,17 +1,21 @@
1# $NetBSD: Makefile,v 1.44 2018/04/03 19:58:19 adam Exp $ 1# $NetBSD: Makefile,v 1.45 2018/11/07 11:51:25 adam Exp $
2 2
3DISTNAME= sqlite-doc-${SQLITE3_DISTVERSION} 3# docs for latest version are not available
4PKGNAME= sqlite3-docs-${SQLITE3_VERSION} 4#DISTNAME= sqlite-doc-${SQLITE3_DISTVERSION}
 5#PKGNAME= sqlite3-docs-${SQLITE3_VERSION}
 6
 7DISTNAME= sqlite-doc-3250200
 8PKGNAME= sqlite3-docs-3.25.2
5CATEGORIES= databases 9CATEGORIES= databases
6EXTRACT_SUFX= .zip 10EXTRACT_SUFX= .zip
7 11
8MAINTAINER= pkgsrc-users@NetBSD.org 12MAINTAINER= pkgsrc-users@NetBSD.org
9COMMENT= SQL Database Engine in a C Library (docs package) 13COMMENT= SQL Database Engine in a C Library (docs package)
10# "Portions of the documentation and some code used as part of the 14# "Portions of the documentation and some code used as part of the
11# build process might fall under other licenses. We do not worry 15# build process might fall under other licenses. We do not worry
12# about the licensing of the documentation and build code so much 16# about the licensing of the documentation and build code so much
13# because none of these things are part of the core deliverable SQLite 17# because none of these things are part of the core deliverable SQLite
14# library." 18# library."
15 19
16.include "../../databases/sqlite3/Makefile.common" 20.include "../../databases/sqlite3/Makefile.common"
17 21

cvs diff -r1.93 -r1.94 pkgsrc/databases/sqlite3-tcl/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-tcl/distinfo 2018/10/01 08:02:37 1.93
+++ pkgsrc/databases/sqlite3-tcl/distinfo 2018/11/07 11:51:25 1.94
@@ -1,7 +1,7 @@ @@ -1,7 +1,7 @@
1$NetBSD: distinfo,v 1.93 2018/10/01 08:02:37 adam Exp $ 1$NetBSD: distinfo,v 1.94 2018/11/07 11:51:25 adam Exp $
2 2
3SHA1 (sqlite-autoconf-3250200.tar.gz) = aedfbdc14eb700099434d6a743135743cff47393 3SHA1 (sqlite-autoconf-3250300.tar.gz) = 5d6dc7634ec59e7a6fffa8758c1e184b2522c2e5
4RMD160 (sqlite-autoconf-3250200.tar.gz) = a360883c9616a02a8690560aa93b8c9e1a07bc99 4RMD160 (sqlite-autoconf-3250300.tar.gz) = 98578994f8edaac730ff18f0196eb2220b88492d
5SHA512 (sqlite-autoconf-3250200.tar.gz) = 5ef9a6dfbb0822257af1a3a379785a95ab02edecbbb53b57074ddd0b8dc294fc07cbb9a8a7acc4e1640fb1743525ed6331fecebbddce01bc017330b20e127ad9 5SHA512 (sqlite-autoconf-3250300.tar.gz) = 5bc501d15367e097f4070185974b0c3a8246c06b205fb2258ed18870ff3fbf120ac5e0ba031a6744af89f7659206e28e7de2f0367bdb190b8412e453b43de4ba
6Size (sqlite-autoconf-3250200.tar.gz) = 2763876 bytes 6Size (sqlite-autoconf-3250300.tar.gz) = 2764429 bytes
7SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537 7SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

cvs diff -r1.22 -r1.23 pkgsrc/devel/lemon/distinfo (expand / switch to unified diff)

--- pkgsrc/devel/lemon/distinfo 2018/10/01 08:02:37 1.22
+++ pkgsrc/devel/lemon/distinfo 2018/11/07 11:51:25 1.23
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.22 2018/10/01 08:02:37 adam Exp $ 1$NetBSD: distinfo,v 1.23 2018/11/07 11:51:25 adam Exp $
2 2
3SHA1 (sqlite-src-3250200.zip) = 43c087e4e8d2abf8ff723ee787bd8984f7057b6d 3SHA1 (sqlite-src-3250300.zip) = d1af2883bb800852946f9bf8ab6055e7698e18ee
4RMD160 (sqlite-src-3250200.zip) = 5ebce7c8c42321226b5efd7006f955b9cf723ef7 4RMD160 (sqlite-src-3250300.zip) = 0ad722c59690ef1e90537ed9a9881734da3e3e35
5SHA512 (sqlite-src-3250200.zip) = 7354af2d45c574ba867fab8aabc6ff903279f028aebed50c71019066df78f61a0b941564c572c87b0f3ed3e5783bf325a690a9957d775228fbbb293dd9a5ad37 5SHA512 (sqlite-src-3250300.zip) = 7d6a38aea5626f7a32960fcdd109c647dd24a22ecf0772f01ffdba389f70fdfe6455f69733b22c220d4114a7d61d3d10097c23859d303e02d126988a1f663b65
6Size (sqlite-src-3250200.zip) = 11381811 bytes 6Size (sqlite-src-3250300.zip) = 11384253 bytes