CVS commit: pkgsrc

To: pkgsrc-changes%NetBSD.org@localhost
Subject: CVS commit: pkgsrc
From: "Adam Ciarcinski" <adam%netbsd.org@localhost>
Date: Mon, 13 Feb 2017 17:44:02 +0000

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Feb 13 17:44:01 UTC 2017

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

Log Message:
SQLite Release 3.17.0 On 2017-02-13
* Approximately 25% better performance from the R-Tree extension.
* Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong()) for byteswapping when available.
* Uses the sqlite3_blob key/value access object instead of SQL for pulling content out of R-Tree nodes
* Other miscellaneous enhancements such as loop unrolling.
* Add the SQLITE_DEFAULT_LOOKASIDE compile-time option.
* Increase the default lookaside size from 512,125 to 1200,100 as this provides better performance while only adding 56KB of extra memory per connection. Memory-sensitive applications can restore the 
old default at compile-time, start-time, or run-time.
* Use compiler built-ins __builtin_sub_overflow(), __builtin_add_overflow(), and __builtin_mul_overflow() when available. (All compiler built-ins can be omitted with the SQLITE_DISABLE_INTRINSIC 
compile-time option.)
* Added the SQLITE_ENABLE_NULL_TRIM compile-time option, which can result in significantly smaller database files for some applications, at the risk of being incompatible with older versions of 
SQLite.
* Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, for improved performance.
* Added the SQLITE_UINT64_TYPE compile-time option as an analog to SQLITE_INT64_TYPE.
* Perform some UPDATE operations in a single pass instead of in two passes.
* Enhance the session extension to support WITHOUT ROWID tables.
* Fixed performance problems and potential stack overflows when creating views from multi-row VALUES clauses with hundreds of thousands of rows.
* Added the sha1.c extension.
* In the command-line shell, enhance the ".mode" command so that it restores the default column and row separators for modes "line", "list", "column", and "tcl".
* Enhance the SQLITE_DIRECT_OVERFLOW_READ option so that it works in WAL mode as long as the pages being read are not in the WAL file.
* Enhance the LEMON parser generator so that it can store the parser object as a stack variable rather than allocating space from the heap and make use of that enhancement in the amalgamation.
* Other performance improvements. Uses about 6.5% fewer CPU cycles.

Bug Fixes:
* Throw an error if the ON clause of a LEFT JOIN references tables to the right of the ON clause. This is the same behavior as PostgreSQL. Formerly, SQLite silently converted the LEFT JOIN into an 
INNER JOIN.
* Use the correct affinity for columns of automatic indexes.
* Ensure that the sqlite3_blob_reopen() interface can correctly handle short rows.


To generate a diff of this commit:
cvs rdiff -u -r1.113 -r1.114 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.50 -r1.51 pkgsrc/databases/sqlite3/Makefile.common
cvs rdiff -u -r1.29 -r1.30 pkgsrc/databases/sqlite3/Makefile.version
cvs rdiff -u -r1.131 -r1.132 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.65 -r1.66 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.66 -r1.67 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.79 -r1.80 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.7 -r1.8 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.113 pkgsrc/databases/sqlite3/Makefile:1.114
--- pkgsrc/databases/sqlite3/Makefile:1.113     Mon Jan  2 17:52:23 2017
+++ pkgsrc/databases/sqlite3/Makefile   Mon Feb 13 17:44:01 2017
@@ -1,6 +1,4 @@
-# $NetBSD: Makefile,v 1.113 2017/01/02 17:52:23 adam Exp $
-#
-# used by databases/sqlite3-tcl/Makefile
+# $NetBSD: Makefile,v 1.114 2017/02/13 17:44:01 adam Exp $
 
 .include "Makefile.common"
 

Index: pkgsrc/databases/sqlite3/Makefile.common
diff -u pkgsrc/databases/sqlite3/Makefile.common:1.50 pkgsrc/databases/sqlite3/Makefile.common:1.51
--- pkgsrc/databases/sqlite3/Makefile.common:1.50       Sat Oct 22 00:18:39 2016
+++ pkgsrc/databases/sqlite3/Makefile.common    Mon Feb 13 17:44:01 2017
@@ -1,4 +1,6 @@
-# $NetBSD: Makefile.common,v 1.50 2016/10/22 00:18:39 kamil Exp $
+# $NetBSD: Makefile.common,v 1.51 2017/02/13 17:44:01 adam Exp $
+#
+# used by databases/sqlite3-tcl/Makefile
 
 DISTNAME=      sqlite-autoconf-${SQLITE3_DISTVERSION}
 

Index: pkgsrc/databases/sqlite3/Makefile.version
diff -u pkgsrc/databases/sqlite3/Makefile.version:1.29 pkgsrc/databases/sqlite3/Makefile.version:1.30
--- pkgsrc/databases/sqlite3/Makefile.version:1.29      Thu Jan 19 18:52:05 2017
+++ pkgsrc/databases/sqlite3/Makefile.version   Mon Feb 13 17:44:01 2017
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.version,v 1.29 2017/01/19 18:52:05 agc Exp $
+# $NetBSD: Makefile.version,v 1.30 2017/02/13 17:44:01 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=   3160200
-SQLITE3_VERSION=       3.16.2
+SQLITE3_DISTVERSION=   3170000
+SQLITE3_VERSION=       3.17.0
 
 MASTER_SITES=  http://www.hwaci.com/sw/sqlite/2017/
 MASTER_SITES+= http://www.sqlite.org/2017/

Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.131 pkgsrc/databases/sqlite3/distinfo:1.132
--- pkgsrc/databases/sqlite3/distinfo:1.131     Sat Jan  7 10:23:00 2017
+++ pkgsrc/databases/sqlite3/distinfo   Mon Feb 13 17:44:01 2017
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.131 2017/01/07 10:23:00 adam Exp $
+$NetBSD: distinfo,v 1.132 2017/02/13 17:44:01 adam Exp $
 
-SHA1 (sqlite-autoconf-3160200.tar.gz) = 64ca578ad44a94115b1db0406740e14288f74bb8
-RMD160 (sqlite-autoconf-3160200.tar.gz) = 86b351cfa4321a857fe6987694e188655226951f
-SHA512 (sqlite-autoconf-3160200.tar.gz) = 83bdd588504f265bbe93fb98a33a292aff5618c14f94d521c8557efbb5f777e82dfbb2d186cbfd4c628ee9522b1fcb73857e24ca2318fa34af3a3f9540e72b9a
-Size (sqlite-autoconf-3160200.tar.gz) = 2508179 bytes
+SHA1 (sqlite-autoconf-3170000.tar.gz) = 7bcff1c158ed9e2c0e159c1b4b6c36d4d65dff8c
+RMD160 (sqlite-autoconf-3170000.tar.gz) = c198f8c3f91894ba017b7e71a9d6e5c31a9ef12c
+SHA512 (sqlite-autoconf-3170000.tar.gz) = bebf2693ade1c99b6a178bbe663f64911bf7751932a2524506994cbbb19ab254e7febe3693a76084e55853c1ea85db9e4ece87192422583555fbe569915a2ca8
+Size (sqlite-autoconf-3170000.tar.gz) = 2515143 bytes

Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.65 pkgsrc/databases/sqlite3-docs/PLIST:1.66
--- pkgsrc/databases/sqlite3-docs/PLIST:1.65    Sat Jan  7 10:23:00 2017
+++ pkgsrc/databases/sqlite3-docs/PLIST Mon Feb 13 17:44:01 2017
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.65 2017/01/07 10:23:00 adam Exp $
+@comment $NetBSD: PLIST,v 1.66 2017/02/13 17:44:01 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -576,6 +576,7 @@ share/doc/sqlite3/releaselog/3_15_2.html
 share/doc/sqlite3/releaselog/3_16_0.html
 share/doc/sqlite3/releaselog/3_16_1.html
 share/doc/sqlite3/releaselog/3_16_2.html
+share/doc/sqlite3/releaselog/3_17_0.html
 share/doc/sqlite3/releaselog/3_1_0.html
 share/doc/sqlite3/releaselog/3_1_1.html
 share/doc/sqlite3/releaselog/3_1_2.html

Index: pkgsrc/databases/sqlite3-docs/distinfo
diff -u pkgsrc/databases/sqlite3-docs/distinfo:1.66 pkgsrc/databases/sqlite3-docs/distinfo:1.67
--- pkgsrc/databases/sqlite3-docs/distinfo:1.66 Sat Jan  7 10:23:00 2017
+++ pkgsrc/databases/sqlite3-docs/distinfo      Mon Feb 13 17:44:01 2017
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.66 2017/01/07 10:23:00 adam Exp $
+$NetBSD: distinfo,v 1.67 2017/02/13 17:44:01 adam Exp $
 
-SHA1 (sqlite-doc-3160200.zip) = c3424040e2368dd78cf9aac801de8d8988549439
-RMD160 (sqlite-doc-3160200.zip) = 2d3c201abfdcd7ec4902ee5a299d99f9946e4cb5
-SHA512 (sqlite-doc-3160200.zip) = b79d21074d1ab154e3b324fb2943f24321ad5cdbc6e2030f1d21940ae46538462af049e0e0cd7c6cf96dec2c59708eaf70aa4cb3c84ba1a0e87238ffcf31fca2
-Size (sqlite-doc-3160200.zip) = 5521023 bytes
+SHA1 (sqlite-doc-3170000.zip) = bf3b479067d6eb36c8230b668a45994c9212d6cc
+RMD160 (sqlite-doc-3170000.zip) = eb92ad2b22af2bbaa3e76c8e04f475f763057902
+SHA512 (sqlite-doc-3170000.zip) = 6a7813be301416dc59401b7732733f44efad60b458ded0f4ed8d845aab0843a1123dd20d1e6f209dd32184a87bcd7e68e213e3676c43d1d05d2df5acc2c64b74
+Size (sqlite-doc-3170000.zip) = 5533032 bytes

Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.79 pkgsrc/databases/sqlite3-tcl/distinfo:1.80
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.79  Sat Jan  7 10:23:00 2017
+++ pkgsrc/databases/sqlite3-tcl/distinfo       Mon Feb 13 17:44:01 2017
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.79 2017/01/07 10:23:00 adam Exp $
+$NetBSD: distinfo,v 1.80 2017/02/13 17:44:01 adam Exp $
 
-SHA1 (sqlite-autoconf-3160200.tar.gz) = 64ca578ad44a94115b1db0406740e14288f74bb8
-RMD160 (sqlite-autoconf-3160200.tar.gz) = 86b351cfa4321a857fe6987694e188655226951f
-SHA512 (sqlite-autoconf-3160200.tar.gz) = 83bdd588504f265bbe93fb98a33a292aff5618c14f94d521c8557efbb5f777e82dfbb2d186cbfd4c628ee9522b1fcb73857e24ca2318fa34af3a3f9540e72b9a
-Size (sqlite-autoconf-3160200.tar.gz) = 2508179 bytes
+SHA1 (sqlite-autoconf-3170000.tar.gz) = 7bcff1c158ed9e2c0e159c1b4b6c36d4d65dff8c
+RMD160 (sqlite-autoconf-3170000.tar.gz) = c198f8c3f91894ba017b7e71a9d6e5c31a9ef12c
+SHA512 (sqlite-autoconf-3170000.tar.gz) = bebf2693ade1c99b6a178bbe663f64911bf7751932a2524506994cbbb19ab254e7febe3693a76084e55853c1ea85db9e4ece87192422583555fbe569915a2ca8
+Size (sqlite-autoconf-3170000.tar.gz) = 2515143 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d

Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.7 pkgsrc/devel/lemon/distinfo:1.8
--- pkgsrc/devel/lemon/distinfo:1.7     Sat Jan  7 10:23:00 2017
+++ pkgsrc/devel/lemon/distinfo Mon Feb 13 17:44:01 2017
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.7 2017/01/07 10:23:00 adam Exp $
+$NetBSD: distinfo,v 1.8 2017/02/13 17:44:01 adam Exp $
 
-SHA1 (sqlite-src-3160200.zip) = fc216077093044e9161d9d27c68d0fba8ff19d3f
-RMD160 (sqlite-src-3160200.zip) = 0b704dbe2e26c3b6153ef2a8108d1b668fd419c0
-SHA512 (sqlite-src-3160200.zip) = db49551c09830cf4d8997f0a623deeed9f85db5f27e6ca9d8aa5812a23c1466bbcdf8bb56cf009511f72cafec8f09a305127123f54d90437b28770dac34a0897
-Size (sqlite-src-3160200.zip) = 10081950 bytes
+SHA1 (sqlite-src-3170000.zip) = 67368dfa74dac296cebfc4a8fe9bb92ef47e8b47
+RMD160 (sqlite-src-3170000.zip) = 1c0930021811f401c33b42ad93bbf3dd6174a6c4
+SHA512 (sqlite-src-3170000.zip) = e60381de33fbf566507454e4f1dfb7d3ada554e5c919f05f0dd2f96a6f266adaa62681437f21fdea1c24de57fb6141b798f97854918faa189b507f12f11e0d36
+Size (sqlite-src-3170000.zip) = 10120844 bytes

Prev by Date: CVS commit: pkgsrc/doc
Next by Date: CVS commit: pkgsrc/doc
Previous by Thread: CVS commit: pkgsrc/doc
Next by Thread: CVS commit: pkgsrc/doc
Indexes:

Home | Main Index | Thread Index | Old Index