diff options
| author | adam <adam@pkgsrc.org> | 2017-03-30 15:55:12 +0000 |
|---|---|---|
| committer | adam <adam@pkgsrc.org> | 2017-03-30 15:55:12 +0000 |
| commit | 1df333c58493226a0302f4c5ad11a7eb4f48f588 (patch) | |
| tree | 04f43e8b173b4d6d83c67040da25baa5f8dca5c0 /databases/sqlite3-docs | |
| parent | f64178cd7fea98e2afd64460c8f0f082a25a810e (diff) | |
| download | pkgsrc-1df333c58493226a0302f4c5ad11a7eb4f48f588.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-docs')
| -rw-r--r-- | databases/sqlite3-docs/distinfo | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo index 3e1c1dbbd77..5707ed474bc 100644 --- a/databases/sqlite3-docs/distinfo +++ b/databases/sqlite3-docs/distinfo @@ -1,6 +1,6 @@ -$NetBSD: distinfo,v 1.67 2017/02/13 17:44:01 adam Exp $ +$NetBSD: distinfo,v 1.68 2017/03/30 15:55:12 adam Exp $ -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 +SHA1 (sqlite-doc-3180000.zip) = 36fac5aa864683d186410c75d2f6e3176beddc7d +RMD160 (sqlite-doc-3180000.zip) = c45758f9a0d9997eb370599b15e781912a6b1ff9 +SHA512 (sqlite-doc-3180000.zip) = 7b65130cb2174d823842cddc912432d206044a8b276fdc2eef437854de7d0b05b8eb5d7aec0ead5c3f88bb7788ae5f1c42ffb1e43ab00774a68f6f7fea72d517 +Size (sqlite-doc-3180000.zip) = 5552381 bytes |