pkgsrc-Changes-HG archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
[pkgsrc/trunk]: pkgsrc sqlite3: updated to 3.23.0
details: https://anonhg.NetBSD.org/pkgsrc/rev/2c1ee9a920ae
branches: trunk
changeset: 378219:2c1ee9a920ae
user: adam <adam%pkgsrc.org@localhost>
date: Tue Apr 03 19:58:19 2018 +0000
description:
sqlite3: updated to 3.23.0
SQLite Release 3.23.0:
Add the sqlite3_serialize() and sqlite3_deserialize() interfaces when the SQLITE_ENABLE_DESERIALIZE compile-time option is used.
Recognize TRUE and FALSE as constants. (For compatibility, if there exist columns named "true" or "false", then the identifiers refer to the columns rather than Boolean constants.)
Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE.
Added the SQLITE_DBSTATUS_CACHE_SPILL option to sqlite3_db_status() for reporting the number of cache spills that have occurred.
The "alternate-form-2" flag ("!") on the built-in printf implementation now causes string substitutions to measure the width and precision in characters instead of bytes.
If the xColumn method in a virtual table implementation returns an error message using sqlite3_result_error() then give that error message preference over internally-generated messages.
Added the -A command-line option to the CLI to make it easier to manage SQLite Archive files.
Add support for INSERT OR REPLACE, INSERT OR IGNORE, and UPDATE OR REPLACE in the Zipfile virtual table.
Enhance the sqlite3changeset_apply() interface so that it is hardened against attacks from deliberately corrupted changeset objects.
Added the sqlite3_normalize() extension function.
Query optimizer enhancements:
Improve the omit-left-join optimization so that it works in cases where the right-hand table is UNIQUE but not necessarily NOT NULL.
Improve the push-down optimization so that it works for many LEFT JOINs.
Add the LEFT JOIN strength reduction optimization that converts a LEFT JOIN into an ordinary JOIN if there exist terms in the WHERE clause that would prevent the extra all-NULL row of the LEFT JOIN
from appearing in the output set.
Avoid unnecessary writes to the sqlite_sequence table when an AUTOINCREMENT table is updated with an rowid that is less than the maximum.
Bug fixes:
Fix the parser to accept valid row value syntax.
Fix the query planner so that it takes into account dependencies in the arguments to table-valued functions in subexpressions in the WHERE clause.
Fix incorrect result with complex OR-connected WHERE and STAT4.
Fix potential corruption in indexes on expressions due to automatic datatype conversions.
Assertion fault in FTS4.
Incorrect result on the less-than operator in row values.
Always interpret non-zero floating-point values as TRUE, even if the integer part is zero.
Fix an issue in the fsdir(PATH) table-valued function to the fileio.c extension, that caused a segfault if the fsdir() table was used as the inner table of a join.
Issue an error rather instead of an assertion-fault or null-pointer dereference when the sqlite_master table is corrupted so that the sqlite_sequence table root page is really a btree-index page.
Fix the ANALYZE command so that it computes statistics on tables whose names begin with "sqlite".
Additional fixes for issues detected by OSSFuzz:
Fix a possible infinite loop on VACUUM for corrupt database files.
Disallow parameters in the WITH clause of triggers and views.
Fix a potential memory leak in row value processing.
Improve the performance of the replace() SQL function for cases where there are many substitutions on megabyte-sized strings, in an attempt to avoid OSSFuzz timeouts during testing.
Provide an appropriate error message when the sqlite_master table contains a CREATE TABLE AS statement. Formerly this caused either an assertion fault or null pointer dereference. Problem found by
OSSFuzz on the GDAL project.
Incorrect assert() statement removed.
Fix a problem with using the LIKE optimization on an INTEGER PRIMARY KEY.
diffstat:
databases/sqlite3-docs/Makefile | 6 ++----
databases/sqlite3-docs/PLIST | 20 +++++++++++++++++++-
databases/sqlite3-docs/distinfo | 10 +++++-----
databases/sqlite3-tcl/Makefile | 3 ++-
databases/sqlite3-tcl/distinfo | 10 +++++-----
databases/sqlite3/Makefile | 3 ++-
databases/sqlite3/Makefile.common | 15 ++++++++++-----
databases/sqlite3/Makefile.version | 12 ------------
databases/sqlite3/distinfo | 10 +++++-----
devel/lemon/Makefile | 5 ++---
devel/lemon/distinfo | 10 +++++-----
11 files changed, 57 insertions(+), 47 deletions(-)
diffs (288 lines):
diff -r 22da2b6cc992 -r 2c1ee9a920ae databases/sqlite3-docs/Makefile
--- a/databases/sqlite3-docs/Makefile Tue Apr 03 18:46:26 2018 +0000
+++ b/databases/sqlite3-docs/Makefile Tue Apr 03 19:58:19 2018 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.43 2016/01/08 14:43:10 adam Exp $
+# $NetBSD: Makefile,v 1.44 2018/04/03 19:58:19 adam Exp $
DISTNAME= sqlite-doc-${SQLITE3_DISTVERSION}
PKGNAME= sqlite3-docs-${SQLITE3_VERSION}
@@ -6,16 +6,14 @@
EXTRACT_SUFX= .zip
MAINTAINER= pkgsrc-users%NetBSD.org@localhost
-HOMEPAGE= http://sqlite.org/
COMMENT= SQL Database Engine in a C Library (docs package)
# "Portions of the documentation and some code used as part of the
# build process might fall under other licenses. We do not worry
# about the licensing of the documentation and build code so much
# because none of these things are part of the core deliverable SQLite
# library."
-LICENSE= public-domain
-.include "../../databases/sqlite3/Makefile.version"
+.include "../../databases/sqlite3/Makefile.common"
USE_LANGUAGES= # none
USE_TOOLS+= find xargs pax
diff -r 22da2b6cc992 -r 2c1ee9a920ae databases/sqlite3-docs/PLIST
--- a/databases/sqlite3-docs/PLIST Tue Apr 03 18:46:26 2018 +0000
+++ b/databases/sqlite3-docs/PLIST Tue Apr 03 19:58:19 2018 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.74 2018/01/24 13:44:14 adam Exp $
+@comment $NetBSD: PLIST,v 1.75 2018/04/03 19:58:19 adam Exp $
share/doc/sqlite3/34to35.html
share/doc/sqlite3/35to36.html
share/doc/sqlite3/about.html
@@ -7,6 +7,7 @@
share/doc/sqlite3/amalgamation.html
share/doc/sqlite3/appfileformat.html
share/doc/sqlite3/arch.html
+share/doc/sqlite3/assert.html
share/doc/sqlite3/asyncvfs.html
share/doc/sqlite3/atomiccommit.html
share/doc/sqlite3/autoinc.html
@@ -43,6 +44,7 @@
share/doc/sqlite3/c3ref/c_dbconfig_enable_fkey.html
share/doc/sqlite3/c3ref/c_dbstatus_options.html
share/doc/sqlite3/c3ref/c_deny.html
+share/doc/sqlite3/c3ref/c_deserialize_freeonclose.html
share/doc/sqlite3/c3ref/c_deterministic.html
share/doc/sqlite3/c3ref/c_fail.html
share/doc/sqlite3/c3ref/c_fcntl_begin_atomic_write.html
@@ -55,6 +57,7 @@
share/doc/sqlite3/c3ref/c_open_autoproxy.html
share/doc/sqlite3/c3ref/c_prepare_persistent.html
share/doc/sqlite3/c3ref/c_scanstat_est.html
+share/doc/sqlite3/c3ref/c_serialize_nocopy.html
share/doc/sqlite3/c3ref/c_shm_exclusive.html
share/doc/sqlite3/c3ref/c_shm_nlock.html
share/doc/sqlite3/c3ref/c_source_id.html
@@ -96,6 +99,7 @@
share/doc/sqlite3/c3ref/db_release_memory.html
share/doc/sqlite3/c3ref/db_status.html
share/doc/sqlite3/c3ref/declare_vtab.html
+share/doc/sqlite3/c3ref/deserialize.html
share/doc/sqlite3/c3ref/enable_load_extension.html
share/doc/sqlite3/c3ref/enable_shared_cache.html
share/doc/sqlite3/c3ref/errcode.html
@@ -147,6 +151,7 @@
share/doc/sqlite3/c3ref/reset_auto_extension.html
share/doc/sqlite3/c3ref/result_blob.html
share/doc/sqlite3/c3ref/result_subtype.html
+share/doc/sqlite3/c3ref/serialize.html
share/doc/sqlite3/c3ref/set_authorizer.html
share/doc/sqlite3/c3ref/set_last_insert_rowid.html
share/doc/sqlite3/c3ref/sleep.html
@@ -205,6 +210,7 @@
share/doc/sqlite3/chronology.html
share/doc/sqlite3/cintro.html
share/doc/sqlite3/cli.html
+share/doc/sqlite3/codeofconduct.html
share/doc/sqlite3/compile.html
share/doc/sqlite3/completion.html
share/doc/sqlite3/conflict.html
@@ -556,9 +562,11 @@
share/doc/sqlite3/pgszchng2016.html
share/doc/sqlite3/pragma.html
share/doc/sqlite3/pressrelease-20071212.html
+share/doc/sqlite3/printf.html
share/doc/sqlite3/privatebranch.html
share/doc/sqlite3/prosupport.html
share/doc/sqlite3/psow.html
+share/doc/sqlite3/qmplan.html
share/doc/sqlite3/queryplanner-ng.html
share/doc/sqlite3/queryplanner.html
share/doc/sqlite3/quickstart.html
@@ -609,6 +617,7 @@
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_23_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
@@ -747,6 +756,9 @@
share/doc/sqlite3/rowidtable.html
share/doc/sqlite3/rowvalue.html
share/doc/sqlite3/rtree.html
+share/doc/sqlite3/search
+share/doc/sqlite3/search.d/admin
+share/doc/sqlite3/search.d/search.db
share/doc/sqlite3/selfcontained.html
share/doc/sqlite3/series.html
share/doc/sqlite3/serverless.html
@@ -759,6 +771,7 @@
share/doc/sqlite3/session/funclist.html
share/doc/sqlite3/session/intro.html
share/doc/sqlite3/session/objlist.html
+share/doc/sqlite3/session/rebaser.html
share/doc/sqlite3/session/session.html
share/doc/sqlite3/session/sqlite3changegroup_add.html
share/doc/sqlite3/session/sqlite3changegroup_add_strm.html
@@ -777,6 +790,10 @@
share/doc/sqlite3/session/sqlite3changeset_op.html
share/doc/sqlite3/session/sqlite3changeset_pk.html
share/doc/sqlite3/session/sqlite3changeset_start.html
+share/doc/sqlite3/session/sqlite3rebaser_configure.html
+share/doc/sqlite3/session/sqlite3rebaser_create.html
+share/doc/sqlite3/session/sqlite3rebaser_delete.html
+share/doc/sqlite3/session/sqlite3rebaser_rebase.html
share/doc/sqlite3/session/sqlite3session_attach.html
share/doc/sqlite3/session/sqlite3session_changeset.html
share/doc/sqlite3/session/sqlite3session_create.html
@@ -794,6 +811,7 @@
share/doc/sqlite3/speed.html
share/doc/sqlite3/spellfix1.html
share/doc/sqlite3/sqlanalyze.html
+share/doc/sqlite3/sqlar.html
share/doc/sqlite3/sqldiff.html
share/doc/sqlite3/sqlite.css
share/doc/sqlite3/sqlite.css~
diff -r 22da2b6cc992 -r 2c1ee9a920ae databases/sqlite3-docs/distinfo
--- a/databases/sqlite3-docs/distinfo Tue Apr 03 18:46:26 2018 +0000
+++ b/databases/sqlite3-docs/distinfo Tue Apr 03 19:58:19 2018 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.75 2018/01/24 13:44:14 adam Exp $
+$NetBSD: distinfo,v 1.76 2018/04/03 19:58:19 adam Exp $
-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
+SHA1 (sqlite-doc-3230000.zip) = 766e55e8ab3184e09f99898baed4a3cf493dfafd
+RMD160 (sqlite-doc-3230000.zip) = c4fbc3e88d2384178458ae4ebf505eb294c790fe
+SHA512 (sqlite-doc-3230000.zip) = f78bc152185ad96c05f42f8396a5d0be20923d2603f27ef6ec32c104efb63eefda4e6021392304062a85795d6db9a5305271652edac08fb913894815117e4ea0
+Size (sqlite-doc-3230000.zip) = 8832536 bytes
diff -r 22da2b6cc992 -r 2c1ee9a920ae databases/sqlite3-tcl/Makefile
--- a/databases/sqlite3-tcl/Makefile Tue Apr 03 18:46:26 2018 +0000
+++ b/databases/sqlite3-tcl/Makefile Tue Apr 03 19:58:19 2018 +0000
@@ -1,7 +1,8 @@
-# $NetBSD: Makefile,v 1.90 2018/01/24 13:44:14 adam Exp $
+# $NetBSD: Makefile,v 1.91 2018/04/03 19:58:19 adam Exp $
.include "../../databases/sqlite3/Makefile.common"
+DISTNAME= sqlite-autoconf-${SQLITE3_DISTVERSION}
PKGNAME= sqlite3-tcl-${SQLITE3_VERSION}
CATEGORIES= databases
diff -r 22da2b6cc992 -r 2c1ee9a920ae databases/sqlite3-tcl/distinfo
--- a/databases/sqlite3-tcl/distinfo Tue Apr 03 18:46:26 2018 +0000
+++ b/databases/sqlite3-tcl/distinfo Tue Apr 03 19:58:19 2018 +0000
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.87 2018/01/24 13:44:14 adam Exp $
+$NetBSD: distinfo,v 1.88 2018/04/03 19:58:19 adam Exp $
-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 (sqlite-autoconf-3230000.tar.gz) = ef55baa06f46808b9798f8447ba6a0115b23c5d2
+RMD160 (sqlite-autoconf-3230000.tar.gz) = 2aa10c0ac08113853d2c15e389fdf4419cc821b4
+SHA512 (sqlite-autoconf-3230000.tar.gz) = dd6a1d8659b8ebe0f0293eb5f1099937f0867bf3f46c5767fc823847f649691ae9b52a632020b7fdfcdae3dad84fc64484de594c1948d20f4198e7b386978594
+Size (sqlite-autoconf-3230000.tar.gz) = 2674030 bytes
SHA1 (patch-Makefile.in) = 6cbbc33a5bc9c98b5aa128279f8e21e47406f537
diff -r 22da2b6cc992 -r 2c1ee9a920ae databases/sqlite3/Makefile
--- a/databases/sqlite3/Makefile Tue Apr 03 18:46:26 2018 +0000
+++ b/databases/sqlite3/Makefile Tue Apr 03 19:58:19 2018 +0000
@@ -1,7 +1,8 @@
-# $NetBSD: Makefile,v 1.121 2018/01/24 13:44:14 adam Exp $
+# $NetBSD: Makefile,v 1.122 2018/04/03 19:58:19 adam Exp $
.include "Makefile.common"
+DISTNAME= sqlite-autoconf-${SQLITE3_DISTVERSION}
PKGNAME= sqlite3-${SQLITE3_VERSION}
CATEGORIES= databases
diff -r 22da2b6cc992 -r 2c1ee9a920ae databases/sqlite3/Makefile.common
--- a/databases/sqlite3/Makefile.common Tue Apr 03 18:46:26 2018 +0000
+++ b/databases/sqlite3/Makefile.common Tue Apr 03 19:58:19 2018 +0000
@@ -1,10 +1,15 @@
-# $NetBSD: Makefile.common,v 1.51 2017/02/13 17:44:01 adam Exp $
+# $NetBSD: Makefile.common,v 1.52 2018/04/03 19:58:19 adam Exp $
#
+# used by databases/sqlite3/Makefile
+# used by databases/sqlite3-docs/Makefile
# used by databases/sqlite3-tcl/Makefile
+# used by devel/lemon/Makefile
-DISTNAME= sqlite-autoconf-${SQLITE3_DISTVERSION}
+SQLITE3_DISTVERSION= 3230000
+SQLITE3_VERSION= 3.23.0
-HOMEPAGE= http://www.sqlite.org/
+MASTER_SITES= http://www.sqlite.org/2018/
+MASTER_SITES+= http://www.hwaci.com/sw/sqlite/2018/
+
+HOMEPAGE?= http://www.sqlite.org/
LICENSE= public-domain
-
-.include "../../databases/sqlite3/Makefile.version"
diff -r 22da2b6cc992 -r 2c1ee9a920ae databases/sqlite3/Makefile.version
--- a/databases/sqlite3/Makefile.version Tue Apr 03 18:46:26 2018 +0000
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,12 +0,0 @@
-# $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= 3220000
-SQLITE3_VERSION= 3.22.0
-
-MASTER_SITES= http://www.hwaci.com/sw/sqlite/2018/
-MASTER_SITES+= http://www.sqlite.org/2018/
diff -r 22da2b6cc992 -r 2c1ee9a920ae databases/sqlite3/distinfo
--- a/databases/sqlite3/distinfo Tue Apr 03 18:46:26 2018 +0000
+++ b/databases/sqlite3/distinfo Tue Apr 03 19:58:19 2018 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.140 2018/01/24 13:44:14 adam Exp $
+$NetBSD: distinfo,v 1.141 2018/04/03 19:58:19 adam Exp $
-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 (sqlite-autoconf-3230000.tar.gz) = ef55baa06f46808b9798f8447ba6a0115b23c5d2
+RMD160 (sqlite-autoconf-3230000.tar.gz) = 2aa10c0ac08113853d2c15e389fdf4419cc821b4
+SHA512 (sqlite-autoconf-3230000.tar.gz) = dd6a1d8659b8ebe0f0293eb5f1099937f0867bf3f46c5767fc823847f649691ae9b52a632020b7fdfcdae3dad84fc64484de594c1948d20f4198e7b386978594
+Size (sqlite-autoconf-3230000.tar.gz) = 2674030 bytes
diff -r 22da2b6cc992 -r 2c1ee9a920ae devel/lemon/Makefile
--- a/devel/lemon/Makefile Tue Apr 03 18:46:26 2018 +0000
+++ b/devel/lemon/Makefile Tue Apr 03 19:58:19 2018 +0000
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.3 2016/10/22 00:18:39 kamil Exp $
+# $NetBSD: Makefile,v 1.4 2018/04/03 19:58:19 adam Exp $
-.include "../../databases/sqlite3/Makefile.version"
+.include "../../databases/sqlite3/Makefile.common"
LEMON_VERSION= 1.0
@@ -19,7 +19,6 @@
MAINTAINER= airhead%users.sf.net@localhost
HOMEPAGE= http://www.hwaci.com/sw/lemon/
COMMENT= Simple LALR(1) parser generator
-LICENSE= public-domain
INSTALLATION_DIRS= bin share/lemon share/doc/lemon
diff -r 22da2b6cc992 -r 2c1ee9a920ae devel/lemon/distinfo
--- a/devel/lemon/distinfo Tue Apr 03 18:46:26 2018 +0000
+++ b/devel/lemon/distinfo Tue Apr 03 19:58:19 2018 +0000
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.16 2018/01/24 13:44:14 adam Exp $
+$NetBSD: distinfo,v 1.17 2018/04/03 19:58:19 adam Exp $
-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
+SHA1 (sqlite-src-3230000.zip) = 7943537c085d4bbb778090c2660c9e3e8f60b35e
+RMD160 (sqlite-src-3230000.zip) = 6f0d140402e144e745df978257e8ebfd1c9769e1
+SHA512 (sqlite-src-3230000.zip) = 426292cac308c4865aff1a457ed61ccc15bbc04ff8caf017e19d090b4136f2ac126dd36194058772782ec173737fd47949e8d40dfd7c0565f2ce7db6fa47cc0f
+Size (sqlite-src-3230000.zip) = 10845952 bytes
Home |
Main Index |
Thread Index |
Old Index