diff options
author | adam <adam> | 2017-03-30 15:55:12 +0000 |
---|---|---|
committer | adam <adam> | 2017-03-30 15:55:12 +0000 |
commit | b313f97058ecda2ee106d17ec2c14f4738d530d6 (patch) | |
tree | cd2a2d298cdc785ceae03f6e30c16838008957f9 /databases/sqlite3 | |
parent | 6245d7ccce65385a3c9df5951f04ee4be2d4f24b (diff) | |
download | pkgsrc-b313f97058ecda2ee106d17ec2c14f4738d530d6.tar.gz |
Release 3.18.0:
Added the PRAGMA optimize command
The SQLite version identifier returned by the sqlite_source_id() SQL function and the sqlite3_sourceid() C API and found in the SQLITE_SOURCE_ID macro is now a 64-digit SHA3-256 hash instead of a 40-digit SHA1 hash.
Added the json_patch() SQL function to the JSON1 extension.
Enhance the LIKE optimization so that it works for arbitrary expressions on the left-hand side as long as the LIKE pattern on the right-hand side does not begin with a digit or minus sign.
Added the sqlite3_set_last_insert_rowid() interface and use the new interface in the FTS3, FTS4, and FTS5 extensions to ensure that the sqlite3_last_insert_rowid() interface always returns reasonable values.
Enhance PRAGMA integrity_check and PRAGMA quick_check so that they verify CHECK constraints.
Enhance the query plans for joins to detect empty tables early and halt without doing unnecessary work.
Enhance the sqlite3_mprintf() family of interfaces and the printf SQL function to put comma separators at the thousands marks for integers, if the "," format modifier is used in between the "%" and the "d" (example: "%,d").
Added the -DSQLITE_MAX_MEMORY=N compile-time option.
Added the .sha3sum dot-command and the .selftest dot-command to the command-line shell
Begin enforcing SQLITE_LIMIT_VDBE_OP. This can be used, for example, to prevent excessively large prepared statements in systems that accept SQL queries from untrusted users.
Various performance improvements.
Bug Fixes:
----------
Ensure that indexed expressions with collating sequences are handled correctly. Fix for ticket eb703ba7b50c1a5.
Fix a bug in the 'start of ...' modifiers for the date and time functions. Ticket 6097cb92745327a1
Fix a potential segfault in complex recursive triggers, resulting from a bug in the OP_Once opcode introduced as part of a performance optimization in version 3.15.0. Ticket 06796225f59c057c
In the RBU extension, add extra sync operations to avoid the possibility of corruption following a power failure.
The sqlite3_trace_v2() output for nested SQL statements should always begin with a "--" comment marker.
Diffstat (limited to 'databases/sqlite3')
-rw-r--r-- | databases/sqlite3/Makefile.version | 6 | ||||
-rw-r--r-- | databases/sqlite3/distinfo | 10 |
2 files changed, 8 insertions, 8 deletions
diff --git a/databases/sqlite3/Makefile.version b/databases/sqlite3/Makefile.version index 25addc2d027..bd3471f19b5 100644 --- a/databases/sqlite3/Makefile.version +++ b/databases/sqlite3/Makefile.version @@ -1,12 +1,12 @@ -# $NetBSD: Makefile.version,v 1.30 2017/02/13 17:44:01 adam Exp $ +# $NetBSD: Makefile.version,v 1.31 2017/03/30 15:55:12 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= 3170000 -SQLITE3_VERSION= 3.17.0 +SQLITE3_DISTVERSION= 3180000 +SQLITE3_VERSION= 3.18.0 MASTER_SITES= http://www.hwaci.com/sw/sqlite/2017/ MASTER_SITES+= http://www.sqlite.org/2017/ diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo index 5b712a03130..ef65325a017 100644 --- a/databases/sqlite3/distinfo +++ b/databases/sqlite3/distinfo @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.132 2017/02/13 17:44:01 adam Exp $ +$NetBSD: distinfo,v 1.133 2017/03/30 15:55:12 adam Exp $ -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 (sqlite-autoconf-3180000.tar.gz) = 74559194e1dd9b9d577cac001c0e9d370856671b +RMD160 (sqlite-autoconf-3180000.tar.gz) = dca1a652fa28133f505daba50a021d90891f0ea2 +SHA512 (sqlite-autoconf-3180000.tar.gz) = 4c2efda1d63d1849f7a351cc57c02cc1820efe3c19f88460a131a1d6ae4f7411e4b7672a5581055e581093df29f65cebd9ff5b24125c18802523b17477dce1ef +Size (sqlite-autoconf-3180000.tar.gz) = 2533004 bytes |