pkgsrc-Changes archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
CVS commit: pkgsrc
Module Name: pkgsrc
Committed By: adam
Date: Wed Jan 24 13:44:14 UTC 2018
Modified Files:
pkgsrc/databases/sqlite3: Makefile Makefile.version distinfo
pkgsrc/databases/sqlite3-docs: PLIST distinfo
pkgsrc/databases/sqlite3-tcl: Makefile distinfo
pkgsrc/devel/lemon: distinfo
Log Message:
sqlite3: updated to 3.22.0
Release 3.22.0:
The output of sqlite3_trace_v2() now shows each individual SQL statement run within a trigger.
Add the ability to read from WAL mode databases even if the application lacks write permission on the database and its containing directory, as long as the -shm and -wal files exist in that directory.
Added the rtreecheck() scalar SQL function to the R-Tree extension.
Added the sqlite3_vtab_nochange() and sqlite3_value_nochange() interfaces to help virtual table implementations optimize UPDATE operations.
Added the sqlite3_vtab_collation() interface.
Added support for the "^" initial token syntax in FTS5.
New extensions:
The Zipfile virtual table can read and write a ZIP Archive.
Added the fsdir(PATH) table-valued function to the fileio.c extension, for listing the files in a directory.
The sqlite_btreeinfo eponymous virtual table for introspecting and estimating the sizes of the btrees in a database.
The Append VFS is a VFS shim that allows an SQLite database to be appended to some other file. This allows (for example) a database to be appended to an executable that then opens and reads the
database.
Query planner enhancements:
The optimization that uses an index to quickly compute an aggregate min() or max() is extended to work with indexes on expressions.
The decision of whether to implement a FROM-clause subquery as a co-routine or using query flattening now considers whether the result set of the outer query is "complex" (if it contains functions or
expression subqueries). A complex result set biases the decision toward the use of co-routines.
The planner avoids query plans that use indexes with unknown collating functions.
The planner omits unused LEFT JOINs even if they are not the right-most joins of a query.
Other performance optimizations:
A smaller and faster implementation of text to floating-point conversion subroutine: sqlite3AtoF().
The Lemon parser generator creates a faster parser.
Use the strcspn() C-library routine to speed up the LIKE and GLOB operators.
Improvements to the command-line shell:
The ".schema" command shows the structure of virtual tables.
Added support for reading and writing SQL Archive files using the .archive command.
Added the experimental .expert command
Added the ".eqp trigger" variant of the ".eqp" command
Enhance the ".lint fkey-indexes" command so that it works with WITHOUT ROWID tables.
If the filename argument to the shell is a ZIP archive rather than an SQLite database, then the shell automatically opens that ZIP archive using the Zipfile virtual table.
Added the edit() SQL function.
Added the .excel command to simplify exporting database content to a spreadsheet.
Databases are opened using Append VFS when the --append flag is used on the command line or with the .open command.
Enhance the SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option so that it works for WITHOUT ROWID tables.
Provide the sqlite_offset(X) SQL function that returns the byte offset into the database file to the beginning of the record holding value X, when compiling with -DSQLITE_ENABLE_OFFSET_SQL_FUNC.
Bug fixes
To generate a diff of this commit:
cvs rdiff -u -r1.120 -r1.121 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.37 -r1.38 pkgsrc/databases/sqlite3/Makefile.version
cvs rdiff -u -r1.139 -r1.140 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.73 -r1.74 pkgsrc/databases/sqlite3-docs/PLIST
cvs rdiff -u -r1.74 -r1.75 pkgsrc/databases/sqlite3-docs/distinfo
cvs rdiff -u -r1.89 -r1.90 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.86 -r1.87 pkgsrc/databases/sqlite3-tcl/distinfo
cvs rdiff -u -r1.15 -r1.16 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.120 pkgsrc/databases/sqlite3/Makefile:1.121
--- pkgsrc/databases/sqlite3/Makefile:1.120 Thu Nov 30 16:45:01 2017
+++ pkgsrc/databases/sqlite3/Makefile Wed Jan 24 13:44:14 2018
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.120 2017/11/30 16:45:01 adam Exp $
+# $NetBSD: Makefile,v 1.121 2018/01/24 13:44:14 adam Exp $
-PKGREVISION= 1
.include "Makefile.common"
PKGNAME= sqlite3-${SQLITE3_VERSION}
Index: pkgsrc/databases/sqlite3/Makefile.version
diff -u pkgsrc/databases/sqlite3/Makefile.version:1.37 pkgsrc/databases/sqlite3/Makefile.version:1.38
--- pkgsrc/databases/sqlite3/Makefile.version:1.37 Mon Oct 30 18:36:13 2017
+++ pkgsrc/databases/sqlite3/Makefile.version Wed Jan 24 13:44:14 2018
@@ -1,12 +1,12 @@
-# $NetBSD: Makefile.version,v 1.37 2017/10/30 18:36:13 adam Exp $
+# $NetBSD: Makefile.version,v 1.38 2018/01/24 13:44:14 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= 3210000
-SQLITE3_VERSION= 3.21.0
+SQLITE3_DISTVERSION= 3220000
+SQLITE3_VERSION= 3.22.0
-MASTER_SITES= http://www.hwaci.com/sw/sqlite/2017/
-MASTER_SITES+= http://www.sqlite.org/2017/
+MASTER_SITES= http://www.hwaci.com/sw/sqlite/2018/
+MASTER_SITES+= http://www.sqlite.org/2018/
Index: pkgsrc/databases/sqlite3/distinfo
diff -u pkgsrc/databases/sqlite3/distinfo:1.139 pkgsrc/databases/sqlite3/distinfo:1.140
--- pkgsrc/databases/sqlite3/distinfo:1.139 Mon Oct 30 18:36:13 2017
+++ pkgsrc/databases/sqlite3/distinfo Wed Jan 24 13:44:14 2018
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.139 2017/10/30 18:36:13 adam Exp $
+$NetBSD: distinfo,v 1.140 2018/01/24 13:44:14 adam Exp $
-SHA1 (sqlite-autoconf-3210000.tar.gz) = f56fe3407d8297fc0a68a058f4c9e6b77e83575c
-RMD160 (sqlite-autoconf-3210000.tar.gz) = eff831c68562a4da921f38da2b29e16bc8904d1a
-SHA512 (sqlite-autoconf-3210000.tar.gz) = 8f00708965eacef171620c49538f75768d350ec3f2bfef412a5c70af865ab03b6a64ce1e65d9fdb3d66f4d00262a30fc162b01fd69f63c05c14d5243374b6298
-Size (sqlite-autoconf-3210000.tar.gz) = 2568942 bytes
+SHA1 (sqlite-autoconf-3220000.tar.gz) = 2fb24ec12001926d5209d2da90d252b9825366ac
+RMD160 (sqlite-autoconf-3220000.tar.gz) = c7d898b35c9b2eaa3d4b9dbdd57582d7836979bb
+SHA512 (sqlite-autoconf-3220000.tar.gz) = 13e791bb1d7ba7edb5d84f4945f36ce2e03898a5bb1612d28799ef35a100f32e85cbb38f4ef65a7b43d020e5d48bf09b2e79cbb2003cc8aca2b09458b8c5d5bc
+Size (sqlite-autoconf-3220000.tar.gz) = 2644649 bytes
Index: pkgsrc/databases/sqlite3-docs/PLIST
diff -u pkgsrc/databases/sqlite3-docs/PLIST:1.73 pkgsrc/databases/sqlite3-docs/PLIST:1.74
--- pkgsrc/databases/sqlite3-docs/PLIST:1.73 Mon Oct 30 18:36:13 2017
+++ pkgsrc/databases/sqlite3-docs/PLIST Wed Jan 24 13:44:14 2018
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.73 2017/10/30 18:36:13 adam Exp $
+@comment $NetBSD: PLIST,v 1.74 2018/01/24 13:44:14 adam Exp $
share/doc/sqlite3/34to35.html
share/doc/sqlite3/35to36.html
share/doc/sqlite3/about.html
@@ -188,8 +188,10 @@ share/doc/sqlite3/c3ref/value_subtype.ht
share/doc/sqlite3/c3ref/vfs.html
share/doc/sqlite3/c3ref/vfs_find.html
share/doc/sqlite3/c3ref/vtab.html
+share/doc/sqlite3/c3ref/vtab_collation.html
share/doc/sqlite3/c3ref/vtab_config.html
share/doc/sqlite3/c3ref/vtab_cursor.html
+share/doc/sqlite3/c3ref/vtab_nochange.html
share/doc/sqlite3/c3ref/vtab_on_conflict.html
share/doc/sqlite3/c3ref/wal_autocheckpoint.html
share/doc/sqlite3/c3ref/wal_checkpoint.html
@@ -533,6 +535,7 @@ share/doc/sqlite3/lang_transaction.html
share/doc/sqlite3/lang_update.html
share/doc/sqlite3/lang_vacuum.html
share/doc/sqlite3/lang_with.html
+share/doc/sqlite3/lemon.html
share/doc/sqlite3/limits.html
share/doc/sqlite3/loadext.html
share/doc/sqlite3/lockingv3.html
@@ -605,6 +608,7 @@ share/doc/sqlite3/releaselog/3_1_6.html
share/doc/sqlite3/releaselog/3_20_0.html
share/doc/sqlite3/releaselog/3_20_1.html
share/doc/sqlite3/releaselog/3_21_0.html
+share/doc/sqlite3/releaselog/3_22_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
@@ -796,6 +800,7 @@ share/doc/sqlite3/sqlite.css~
share/doc/sqlite3/sqlite.html
share/doc/sqlite3/stmt.html
share/doc/sqlite3/support.html
+share/doc/sqlite3/swarmvtab.html
share/doc/sqlite3/syntax.html
share/doc/sqlite3/syntax/alter-table-stmt.html
share/doc/sqlite3/syntax/analyze-stmt.html
@@ -875,7 +880,9 @@ share/doc/sqlite3/versionnumbers.html
share/doc/sqlite3/vfs.html
share/doc/sqlite3/vtab.html
share/doc/sqlite3/wal.html
+share/doc/sqlite3/walformat.html
share/doc/sqlite3/whentouse.html
share/doc/sqlite3/whyc.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.74 pkgsrc/databases/sqlite3-docs/distinfo:1.75
--- pkgsrc/databases/sqlite3-docs/distinfo:1.74 Mon Oct 30 18:36:13 2017
+++ pkgsrc/databases/sqlite3-docs/distinfo Wed Jan 24 13:44:14 2018
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.74 2017/10/30 18:36:13 adam Exp $
+$NetBSD: distinfo,v 1.75 2018/01/24 13:44:14 adam Exp $
-SHA1 (sqlite-doc-3210000.zip) = d919b648e128028d17c5435dc88f2f190f7d6a2e
-RMD160 (sqlite-doc-3210000.zip) = 5993694cefcc94724300ba99c776b603894908f5
-SHA512 (sqlite-doc-3210000.zip) = 799c7279166b489d1a5acc9410808c2d4b78e64037fc15b60764180fe1c698f35e27e86793140302f560cfa583baa2c33e416d5c9e1842ec58c6cb6093729334
-Size (sqlite-doc-3210000.zip) = 5800635 bytes
+SHA1 (sqlite-doc-3220000.zip) = 4cbcc5c5029b8e355fa1e5c563a15b91f7ea7ced
+RMD160 (sqlite-doc-3220000.zip) = 3dc059d184272dffcff17124e58916a39d60cb91
+SHA512 (sqlite-doc-3220000.zip) = f9141d3907e5c1a3008d3b7e111e46e7ff1f010358eb682d3e1187a67deb7cca7ba1d5fbc5b19da26ee8df3a0c71a098fd0e8d8ca89c25e5ad2b3e12ba7dc312
+Size (sqlite-doc-3220000.zip) = 5856836 bytes
Index: pkgsrc/databases/sqlite3-tcl/Makefile
diff -u pkgsrc/databases/sqlite3-tcl/Makefile:1.89 pkgsrc/databases/sqlite3-tcl/Makefile:1.90
--- pkgsrc/databases/sqlite3-tcl/Makefile:1.89 Thu Nov 30 16:45:19 2017
+++ pkgsrc/databases/sqlite3-tcl/Makefile Wed Jan 24 13:44:14 2018
@@ -1,6 +1,5 @@
-# $NetBSD: Makefile,v 1.89 2017/11/30 16:45:19 adam Exp $
+# $NetBSD: Makefile,v 1.90 2018/01/24 13:44:14 adam Exp $
-PKGREVISION= 1
.include "../../databases/sqlite3/Makefile.common"
PKGNAME= sqlite3-tcl-${SQLITE3_VERSION}
Index: pkgsrc/databases/sqlite3-tcl/distinfo
diff -u pkgsrc/databases/sqlite3-tcl/distinfo:1.86 pkgsrc/databases/sqlite3-tcl/distinfo:1.87
--- pkgsrc/databases/sqlite3-tcl/distinfo:1.86 Mon Oct 30 18:36:13 2017
+++ pkgsrc/databases/sqlite3-tcl/distinfo Wed Jan 24 13:44:14 2018
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.86 2017/10/30 18:36:13 adam Exp $
+$NetBSD: distinfo,v 1.87 2018/01/24 13:44:14 adam Exp $
-SHA1 (sqlite-autoconf-3210000.tar.gz) = f56fe3407d8297fc0a68a058f4c9e6b77e83575c
-RMD160 (sqlite-autoconf-3210000.tar.gz) = eff831c68562a4da921f38da2b29e16bc8904d1a
-SHA512 (sqlite-autoconf-3210000.tar.gz) = 8f00708965eacef171620c49538f75768d350ec3f2bfef412a5c70af865ab03b6a64ce1e65d9fdb3d66f4d00262a30fc162b01fd69f63c05c14d5243374b6298
-Size (sqlite-autoconf-3210000.tar.gz) = 2568942 bytes
+SHA1 (sqlite-autoconf-3220000.tar.gz) = 2fb24ec12001926d5209d2da90d252b9825366ac
+RMD160 (sqlite-autoconf-3220000.tar.gz) = c7d898b35c9b2eaa3d4b9dbdd57582d7836979bb
+SHA512 (sqlite-autoconf-3220000.tar.gz) = 13e791bb1d7ba7edb5d84f4945f36ce2e03898a5bb1612d28799ef35a100f32e85cbb38f4ef65a7b43d020e5d48bf09b2e79cbb2003cc8aca2b09458b8c5d5bc
+Size (sqlite-autoconf-3220000.tar.gz) = 2644649 bytes
SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
Index: pkgsrc/devel/lemon/distinfo
diff -u pkgsrc/devel/lemon/distinfo:1.15 pkgsrc/devel/lemon/distinfo:1.16
--- pkgsrc/devel/lemon/distinfo:1.15 Mon Oct 30 18:36:13 2017
+++ pkgsrc/devel/lemon/distinfo Wed Jan 24 13:44:14 2018
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.15 2017/10/30 18:36:13 adam Exp $
+$NetBSD: distinfo,v 1.16 2018/01/24 13:44:14 adam Exp $
-SHA1 (sqlite-src-3210000.zip) = 1892ebbac215095351a0ecc0c60a36e4d03104bc
-RMD160 (sqlite-src-3210000.zip) = e6dacc512d897e2b35579e4258cccd3548c57bbc
-SHA512 (sqlite-src-3210000.zip) = 3a054422da80d750fd5ab297f9d2728f4e7b55fa790a72d55da8c381835571992d56b349e50d4680b04c9e2e44d6fa83009c2df3ffa045f43ff9059bb8736894
-Size (sqlite-src-3210000.zip) = 10577695 bytes
+SHA1 (sqlite-src-3220000.zip) = 2bc86f2c63868cebd0db913843b919d62d284094
+RMD160 (sqlite-src-3220000.zip) = 3a00b59a135df70e01b26817a8aac10884dbba0c
+SHA512 (sqlite-src-3220000.zip) = e35defb0ffcc10100399051bc734746de40fa3dc5cd673eac470fb58cd8bd6d911b6dacb5e8489e2dd79c6ae75faaeb8c02384f64c4595963e62bd3faeb9446c
+Size (sqlite-src-3220000.zip) = 10721627 bytes
Home |
Main Index |
Thread Index |
Old Index