CVS commit: pkgsrc

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Sep 17 16:14:07 UTC 2018

Modified Files:
        pkgsrc/databases/sqlite3: Makefile Makefile.common distinfo
        pkgsrc/databases/sqlite3-docs: PLIST distinfo
        pkgsrc/databases/sqlite3-tcl: Makefile distinfo
        pkgsrc/devel/lemon: Makefile distinfo

Log Message:
sqlite3: updated to 3.25.0

SQLite Release 3.25.0:

Add support for window functions
Enhancements the ALTER TABLE command:
- Add support for renaming columns within a table using ALTER TABLE table RENAME COLUMN oldname TO newname.
- Fix table rename feature so that it also updates references to the renamed table in triggers and views.
Query optimizer improvements:
- Avoid unnecessary loads of columns in an aggregate query that are not within an aggregate function and that are not part of the GROUP BY clause.
- The IN-early-out optimization: When doing a look-up on a multi-column index and an IN operator is used on a column other than the left-most column, then if no rows match against the first IN value, 
check to make sure there exist rows that match the columns to the right before continuing with the next IN value.
- Use the transitive property to try to propagate constant values within the WHERE clause. For example, convert "a=99 AND b=a" into "a=99 AND b=99".
Use a separate mutex on every inode in the unix VFS, rather than a single mutex shared among them all, for slightly better concurrency in multi-threaded environments.
Enhance the PRAGMA integrity_check command for improved detection of problems on the page freelist.
Output infinity as 1e999 in the ".dump" command of the command-line shell.
Added the SQLITE_FCNTL_DATA_VERSION file-control.
Added the Geopoly module

Bug fixes:
The ORDER BY LIMIT optimization might have caused an infinite loop in the byte code of the prepared statement under very obscure circumstances, due to a confluence of minor defects in the query 
optimizer.
On an UPSERT when the order of constraint checks is rearranged, ensure that the affinity transformations on the inserted content occur before any of the constraint checks.
Avoid using a prepared statement for ".stats on" command of the CLI after it has been closed by the ".eqp full" logicc.
The LIKE optimization was generating incorrect byte-code and hence getting the wrong answer if the left-hand operand has numeric affinity and the right-hand-side pattern is '/%' or if the pattern 
begins with the ESCAPE character.


To generate a diff of this commit:
cvs rdiff -u -r1.125 -r1.126 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.54 -r1.55 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.143 -r1.144 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.77 -r1.78 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.78 -r1.79 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.94 -r1.95 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.90 -r1.91 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.5 -r1.6 pkgsrc/devel/lemon/Makefile
cvs rdiff -u -r1.19 -r1.20 pkgsrc/devel/lemon/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/sqlite3/Makefile
diff -u pkgsrc/databases/sqlite3/Makefile:1.125 pkgsrc/databases/sqlite3/Makefile:1.126
--- pkgsrc/databases/sqlite3/Makefile:1.125     Fri Jul 20 03:33:48 2018
+++ pkgsrc/databases/sqlite3/Makefile   Mon Sep 17 16:14:07 2018
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.125 2018/07/20 03:33:48 ryoon Exp $
+# $NetBSD: Makefile,v 1.126 2018/09/17 16:14:07 adam Exp $
 
-PKGREVISION= 1
 .include "Makefile.common"
 
 DISTNAME=      sqlite-autoconf-${SQLITE3_DISTVERSION}

Index: pkgsrc/databases/sqlite3/Makefile.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.54 pkgsrc/databases/sqlite3/Makefile.common:1.55
--- pkgsrc/databases/sqlite3/Makefile.common:1.54       Thu Jun  7 07:36:49 2018
+++ pkgsrc/databases/sqlite3/Makefile.common    Mon Sep 17 16:14:07 2018
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.common,v 1.54 2018/06/07 07:36:49 adam Exp $
+# $NetBSD: Makefile.common,v 1.55 2018/09/17 16:14:07 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=   3240000
-SQLITE3_VERSION=       3.24.0
+SQLITE3_DISTVERSION=   3250000
+SQLITE3_VERSION=       3.25.0
 
 MASTER_SITES=  http://www.sqlite.org/2018/
 MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2018/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.143 pkgsrc/databases/sqlite3/distinfo:1.144
--- pkgsrc/databases/sqlite3/distinfo:1.143     Thu Jun  7 07:36:49 2018
+++ pkgsrc/databases/sqlite3/distinfo   Mon Sep 17 16:14:07 2018
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.143 2018/06/07 07:36:49 adam Exp $
+$NetBSD: distinfo,v 1.144 2018/09/17 16:14:07 adam Exp $
 
-SHA1 (sqlite-autoconf-3240000.tar.gz) = da68915e3563b5244cbcdb6c7e20fb35559bcfc6
-RMD160 (sqlite-autoconf-3240000.tar.gz) = e1d3566adf3c61065420bc02956e37fe8b3e546e
-SHA512 (sqlite-autoconf-3240000.tar.gz) = eaec866de26003ec36559aab15dd18dc0e6029453002a4eec5e176bb35a712b8b06c235436e6c1a226b67c7eb90d7a26c2b3b3d9a5e6e92a5af485236b77c878
-Size (sqlite-autoconf-3240000.tar.gz) = 2699252 bytes
+SHA1 (sqlite-autoconf-3250000.tar.gz) = 9188a22f358823aaec649921fb3e21c07f8b6076
+RMD160 (sqlite-autoconf-3250000.tar.gz) = b761a7be1658d1bfa2a589d702bae2d665d404d2
+SHA512 (sqlite-autoconf-3250000.tar.gz) = 26367ed2ab1ce6b8a4c1b4bcce129c4d2019f7ef47ed8e6b5845732a23112d85abe1bb192a26f3f9032bb460064f031c5ceebd26c2e5df3f109c2c100a0c21c4
+Size (sqlite-autoconf-3250000.tar.gz) = 2763727 bytes

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.77 pkgsrc/databases/sqlite3-docs/PLIST:1.78
--- pkgsrc/databases/sqlite3-docs/PLIST:1.77    Thu Jun  7 07:36:49 2018
+++ pkgsrc/databases/sqlite3-docs/PLIST Mon Sep 17 16:14:07 2018
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.77 2018/06/07 07:36:49 adam Exp $
+@comment $NetBSD: PLIST,v 1.78 2018/09/17 16:14:07 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -264,6 +264,7 @@ share/doc/sqlite3/formatchng.html
 share/doc/sqlite3/fts3.html
 share/doc/sqlite3/fts5.html
 share/doc/sqlite3/fullsql.html
+share/doc/sqlite3/geopoly.html
 share/doc/sqlite3/getthecode.html
 share/doc/sqlite3/hirely.html
 share/doc/sqlite3/howtocompile.html
@@ -478,7 +479,10 @@ share/doc/sqlite3/images/syntax/drop-tri
 share/doc/sqlite3/images/syntax/drop-view-stmt.gif
 share/doc/sqlite3/images/syntax/expr.gif
 share/doc/sqlite3/images/syntax/factored-select-stmt.gif
+share/doc/sqlite3/images/syntax/filter.gif
 share/doc/sqlite3/images/syntax/foreign-key-clause.gif
+share/doc/sqlite3/images/syntax/frame-spec.gif
+share/doc/sqlite3/images/syntax/function-invocation.gif
 share/doc/sqlite3/images/syntax/indexed-column.gif
 share/doc/sqlite3/images/syntax/insert-stmt.gif
 share/doc/sqlite3/images/syntax/join-clause.gif
@@ -510,6 +514,9 @@ share/doc/sqlite3/images/syntax/update-s
 share/doc/sqlite3/images/syntax/update-stmt.gif
 share/doc/sqlite3/images/syntax/upsert-clause.gif
 share/doc/sqlite3/images/syntax/vacuum-stmt.gif
+share/doc/sqlite3/images/syntax/window-definition.gif
+share/doc/sqlite3/images/syntax/window-defn.gif
+share/doc/sqlite3/images/syntax/window-function-invocation.gif
 share/doc/sqlite3/images/syntax/with-clause.gif
 share/doc/sqlite3/images/table-ex1b2.gif
 share/doc/sqlite3/images/vfs1.gif
@@ -636,6 +643,7 @@ share/doc/sqlite3/releaselog/3_22_0.html
 share/doc/sqlite3/releaselog/3_23_0.html
 share/doc/sqlite3/releaselog/3_23_1.html
 share/doc/sqlite3/releaselog/3_24_0.html
+share/doc/sqlite3/releaselog/3_25_0.html
 share/doc/sqlite3/releaselog/3_2_0.html
 share/doc/sqlite3/releaselog/3_2_1.html
 share/doc/sqlite3/releaselog/3_2_2.html
@@ -867,7 +875,10 @@ share/doc/sqlite3/syntax/drop-trigger-st
 share/doc/sqlite3/syntax/drop-view-stmt.html
 share/doc/sqlite3/syntax/expr.html
 share/doc/sqlite3/syntax/factored-select-stmt.html
+share/doc/sqlite3/syntax/filter.html
 share/doc/sqlite3/syntax/foreign-key-clause.html
+share/doc/sqlite3/syntax/frame-spec.html
+share/doc/sqlite3/syntax/function-invocation.html
 share/doc/sqlite3/syntax/indexed-column.html
 share/doc/sqlite3/syntax/insert-stmt.html
 share/doc/sqlite3/syntax/join-clause.html
@@ -899,6 +910,8 @@ share/doc/sqlite3/syntax/update-stmt-lim
 share/doc/sqlite3/syntax/update-stmt.html
 share/doc/sqlite3/syntax/upsert-clause.html
 share/doc/sqlite3/syntax/vacuum-stmt.html
+share/doc/sqlite3/syntax/window-defn.html
+share/doc/sqlite3/syntax/window-function-invocation.html
 share/doc/sqlite3/syntax/with-clause.html
 share/doc/sqlite3/syntaxdiagrams.html
 share/doc/sqlite3/tclsqlite.html
@@ -923,6 +936,7 @@ share/doc/sqlite3/walformat.html
 share/doc/sqlite3/whentouse.html
 share/doc/sqlite3/whyc.html
 share/doc/sqlite3/whynotgit.html
+share/doc/sqlite3/windowfunctions.html
 share/doc/sqlite3/withoutrowid.html
 share/doc/sqlite3/zeroconf.html
 share/doc/sqlite3/zipfile.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.78 pkgsrc/databases/sqlite3-docs/distinfo:1.79
--- pkgsrc/databases/sqlite3-docs/distinfo:1.78 Thu Jun  7 07:36:49 2018
+++ pkgsrc/databases/sqlite3-docs/distinfo      Mon Sep 17 16:14:07 2018
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.78 2018/06/07 07:36:49 adam Exp $
+$NetBSD: distinfo,v 1.79 2018/09/17 16:14:07 adam Exp $
 
-SHA1 (sqlite-doc-3240000.zip) = 9684d06b7e6ec1868b1ef075993dc29d952dac97
-RMD160 (sqlite-doc-3240000.zip) = 66f10080117b2b8cc4034db6fb6377355db68c08
-SHA512 (sqlite-doc-3240000.zip) = 31e9046cea569d7ad1b3af176e1bb18cd59474afb6849871ead6e7c9c096f046162fb313a38684a8c944fad9f689c4c3c692be1d7dc6a8ef5a6685bbc7dfdab6
-Size (sqlite-doc-3240000.zip) = 9030826 bytes
+SHA1 (sqlite-doc-3250000.zip) = a1c2ff75ceab0b56ea94a6bb290d7cd6690421f2
+RMD160 (sqlite-doc-3250000.zip) = 4e909fb3e9ecbe6e19fec4e704dd625d04c03825
+SHA512 (sqlite-doc-3250000.zip) = 5580d5ec6286b91cee12bfabf2e3af5d6e0ed1daaabcfc8f353e1e960bde281b44c58de7e201bba107d68c1b8a5ee599ca734d5c87d21bc7b3b2e0e7f502e415
+Size (sqlite-doc-3250000.zip) = 9209742 bytes

Index: pkgsrc/databases/sqlite3-tcl/Makefile
diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.94 pkgsrc/databases/sqlite3-tcl/Makefile:1.95
--- pkgsrc/databases/sqlite3-tcl/Makefile:1.94  Fri Jul 20 03:34:07 2018
+++ pkgsrc/databases/sqlite3-tcl/Makefile       Mon Sep 17 16:14:07 2018
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.94 2018/07/20 03:34:07 ryoon Exp $
+# $NetBSD: Makefile,v 1.95 2018/09/17 16:14:07 adam Exp $
 
-PKGREVISION= 1
 .include "../../databases/sqlite3/Makefile.common"
 
 DISTNAME=      sqlite-autoconf-${SQLITE3_DISTVERSION}

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.90 pkgsrc/databases/sqlite3-tcl/distinfo:1.91
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.90  Thu Jun  7 07:36:49 2018
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Mon Sep 17 16:14:07 2018
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.90 2018/06/07 07:36:49 adam Exp $
+$NetBSD: distinfo,v 1.91 2018/09/17 16:14:07 adam Exp $
 
-SHA1 (sqlite-autoconf-3240000.tar.gz) = da68915e3563b5244cbcdb6c7e20fb35559bcfc6
-RMD160 (sqlite-autoconf-3240000.tar.gz) = e1d3566adf3c61065420bc02956e37fe8b3e546e
-SHA512 (sqlite-autoconf-3240000.tar.gz) = eaec866de26003ec36559aab15dd18dc0e6029453002a4eec5e176bb35a712b8b06c235436e6c1a226b67c7eb90d7a26c2b3b3d9a5e6e92a5af485236b77c878
-Size (sqlite-autoconf-3240000.tar.gz) = 2699252 bytes
+SHA1 (sqlite-autoconf-3250000.tar.gz) = 9188a22f358823aaec649921fb3e21c07f8b6076
+RMD160 (sqlite-autoconf-3250000.tar.gz) = b761a7be1658d1bfa2a589d702bae2d665d404d2
+SHA512 (sqlite-autoconf-3250000.tar.gz) = 26367ed2ab1ce6b8a4c1b4bcce129c4d2019f7ef47ed8e6b5845732a23112d85abe1bb192a26f3f9032bb460064f031c5ceebd26c2e5df3f109c2c100a0c21c4
+Size (sqlite-autoconf-3250000.tar.gz) = 2763727 bytes
 SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537

Index: pkgsrc/devel/lemon/Makefile
diff -u pkgsrc/devel/lemon/Makefile:1.5 pkgsrc/devel/lemon/Makefile:1.6
--- pkgsrc/devel/lemon/Makefile:1.5     Wed Jul  4 13:40:14 2018
+++ pkgsrc/devel/lemon/Makefile Mon Sep 17 16:14:07 2018
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.5 2018/07/04 13:40:14 jperkin Exp $
+# $NetBSD: Makefile,v 1.6 2018/09/17 16:14:07 adam Exp $
 
 .include "../../databases/sqlite3/Makefile.common"
 
@@ -20,6 +20,7 @@ MAINTAINER=   airhead%users.sf.net@localhost
 HOMEPAGE=      http://www.hwaci.com/sw/lemon/
 COMMENT=       Simple LALR(1) parser generator
 
+CHECK_PORTABILITY_SKIP=        configure
 INSTALLATION_DIRS=     bin share/lemon share/doc/lemon
 
 SUBST_CLASSES+=                paths

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.19 pkgsrc/devel/lemon/distinfo:1.20
--- pkgsrc/devel/lemon/distinfo:1.19    Thu Jun  7 07:36:49 2018
+++ pkgsrc/devel/lemon/distinfo Mon Sep 17 16:14:07 2018
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.19 2018/06/07 07:36:49 adam Exp $
+$NetBSD: distinfo,v 1.20 2018/09/17 16:14:07 adam Exp $
 
-SHA1 (sqlite-src-3240000.zip) = fb558c49ee21a837713c4f1e7e413309aabdd9c7
-RMD160 (sqlite-src-3240000.zip) = be4281044f05b6ebfe87cc7304d47fd854ad29c4
-SHA512 (sqlite-src-3240000.zip) = 812c2df7179abb1e445b5b3e161c940b120c53366a7b2c1f0bfc3599cd9921e5543ba39ca3f297eeaefec318f10c15f630f00f9cf04133c7cd419a04f3bbdd0e
-Size (sqlite-src-3240000.zip) = 10980065 bytes
+SHA1 (sqlite-src-3250000.zip) = ed456f1809be70a518eb0c13d852aff0464e8c47
+RMD160 (sqlite-src-3250000.zip) = 97daffa5b51486c98b66c853021eb07692f86d75
+SHA512 (sqlite-src-3250000.zip) = 708ebe49d67399b093120ad1c86322b909de945cd83a4af613361370a40e9db741576f852c176cef0043100a3bdc909e39519d4468723ca6d15572a848342689
+Size (sqlite-src-3250000.zip) = 11376208 bytes