diff options
| author | adam <adam@pkgsrc.org> | 2015-01-16 21:01:19 +0000 |
|---|---|---|
| committer | adam <adam@pkgsrc.org> | 2015-01-16 21:01:19 +0000 |
| commit | 8329f54416d6a929977f51510fb0ce4da021b845 (patch) | |
| tree | 27dc48f72f616c78bf6dcf95805aed6640c44a80 /databases/sqlite3 | |
| parent | 8013db18f6f4b26946a3f9d49d8d3117b80a56d7 (diff) | |
| download | pkgsrc-8329f54416d6a929977f51510fb0ce4da021b845.tar.gz | |
Changes 3.8.8:
New Features:
* Added the PRAGMA data_version command that can be used to determine if a database file has been modified by another process.
* Added the SQLITE_CHECKPOINT_TRUNCATE option to the sqlite3_wal_checkpoint_v2() interface, with corresponding enhancements to PRAGMA wal_checkpoint.
* Added the sqlite3_stmt_scanstatus() interface, available only when compiled with SQLITE_ENABLE_STMT_SCANSTATUS.
* The sqlite3_table_column_metadata() is enhanced to work correctly on WITHOUT ROWID tables and to check for the existence of a a table if the column name parameter is NULL. The interface is now also included in the build by default, without requiring the SQLITE_ENABLE_COLUMN_METADATA compile-time option.
* Added the SQLITE_ENABLE_API_ARMOR compile-time option.
* Added the SQLITE_REVERSE_UNORDERED_SELECTS compile-time option.
* Added the SQLITE_SORTER_PMASZ compile-time option and SQLITE_CONFIG_PMASZ start-time option.
* Added the SQLITE_CONFIG_PCACHE_HDRSZ option to sqlite3_config() which makes it easier for applications to determine the appropriate amount of memory for use with SQLITE_CONFIG_PAGECACHE.
* The number of rows in a VALUES clause is no longer limited by SQLITE_LIMIT_COMPOUND_SELECT.
* Added the eval.c loadable extension that implements an eval() SQL function that will recursively evaluate SQL.
Performance Enhancements:
* Reduce the number of memcpy() operations involved in balancing a b-tree, for 3.2% overall performance boost.
* Improvements to cost estimates for the skip-scan optimization.
* The automatic indexing optimization is now capable of generating a partial index if that is appropriate.
Bug fixes:
* Ensure durability following a power loss with "PRAGMA journal_mode=TRUNCATE" by calling fsync() right after truncating the journal file.
* The query planner now recognizes that any column in the right-hand table of a LEFT JOIN can be NULL, even if that column has a NOT NULL constraint. Avoid trying to optimize out NULL tests in those cases.
* Make sure ORDER BY puts rows in ascending order even if the DISTINCT operator is implemented using a descending index.
* Fix data races that might occur under stress when running with many threads in shared cache mode where some of the threads are opening and closing connections.
* Fix obscure crash bugs found by american fuzzy lop.
* Work around a GCC optimizer bug (for gcc 4.2.1 on MacOS 10.7) that caused the R-Tree extension to compute incorrect results when compiled with -O3.
Other changes:
* Disable the use of the strchrnul() C-library routine unless it is specifically enabled using the -DHAVE_STRCHRNULL compile-time option.
* Improvements to the effectiveness and accuracy of the likelihood(), likely(), and unlikely() SQL hint functions.
Diffstat (limited to 'databases/sqlite3')
| -rw-r--r-- | databases/sqlite3/Makefile | 10 | ||||
| -rw-r--r-- | databases/sqlite3/distinfo | 8 |
2 files changed, 9 insertions, 9 deletions
diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile index 2a3fced6f05..fe4dd70b2f5 100644 --- a/databases/sqlite3/Makefile +++ b/databases/sqlite3/Makefile @@ -1,10 +1,10 @@ -# $NetBSD: Makefile,v 1.88 2014/12/10 10:39:08 adam Exp $ +# $NetBSD: Makefile,v 1.89 2015/01/16 21:01:19 adam Exp $ -DISTNAME= sqlite-autoconf-3080704 -PKGNAME= sqlite3-3.8.7.4 +DISTNAME= sqlite-autoconf-3080800 +PKGNAME= sqlite3-3.8.8 CATEGORIES= databases -MASTER_SITES= http://www.hwaci.com/sw/sqlite/2014/ \ - http://www.sqlite.org/2014/ +MASTER_SITES= http://www.hwaci.com/sw/sqlite/2015/ \ + http://www.sqlite.org/2015/ MAINTAINER= pkgsrc-users@NetBSD.org HOMEPAGE= http://www.sqlite.org/ diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo index 293919d9be1..1b28f474966 100644 --- a/databases/sqlite3/distinfo +++ b/databases/sqlite3/distinfo @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.97 2014/12/10 10:39:08 adam Exp $ +$NetBSD: distinfo,v 1.98 2015/01/16 21:01:19 adam Exp $ -SHA1 (sqlite-autoconf-3080704.tar.gz) = 70ca0b8884a6b145b7f777724670566e2b4f3cde -RMD160 (sqlite-autoconf-3080704.tar.gz) = 8a265def35641bc3b3e327c0ec3de352ddb1fb38 -Size (sqlite-autoconf-3080704.tar.gz) = 1999230 bytes +SHA1 (sqlite-autoconf-3080800.tar.gz) = abb7570b7e331ffede7f40f0037be6e0c03b73af +RMD160 (sqlite-autoconf-3080800.tar.gz) = 9787b14624dcb9f413b94a388c7f85bf703b9f8d +Size (sqlite-autoconf-3080800.tar.gz) = 2020708 bytes |