diff options
| author | adam <adam> | 2012-05-15 08:09:25 +0000 |
|---|---|---|
| committer | adam <adam> | 2012-05-15 08:09:25 +0000 |
| commit | 8660bd7c8615c5a09e652e9c18218531b65891ae (patch) | |
| tree | 7208078d24c8f03315bbd9bd2ac9ebb9ff706d9d /databases/sqlite3-docs/distinfo | |
| parent | c550cb6960474452d2e8bf42f1059734637aaed8 (diff) | |
| download | pkgsrc-8660bd7c8615c5a09e652e9c18218531b65891ae.tar.gz | |
Changes 3.7.12:
* Add the SQLITE_DBSTATUS_CACHE_WRITE option for sqlite3_db_status().
* Optimize the typeof() and length() SQL functions so that they avoid unnecessary reading of database content from disk.
* Add the FTS4 "merge" command, the FTS4 "automerge" command, and the FTS4 "integrity-check" command.
* Report the name of specific CHECK constraints that fail.
* In the command-line shell, use popen() instead of fopen() if the first character of the argument to the ".output" command is "|".
* Make use of OVERLAPPED in the windows VFS to avoid some system calls and thereby obtain a performance improvement.
* More aggressive optimization of the AND operator when one side or the other is always false.
* Improved performance of queries with many OR-connected terms in the WHERE clause that can all be indexed.
* Add the SQLITE_RTREE_INT_ONLY compile-time option to force the R*Tree Extension Module to use integer instead of floating point values for both storage and computation.
* Enhance the PRAGMA integrity_check command to use much less memory when processing multi-gigabyte databases.
* New interfaces added to the test_quota.c add-on module.
* Added the ".trace" dot-command to the command-line shell.
* Allow virtual table constructors to be invoked recursively.
* Improved optimization of ORDER BY clauses on compound queries.
* Improved optimization of aggregate subqueries contained within an aggregate query.
* Bug fix: Fix the RELEASE command so that it does not cancel pending queries. This repairs a problem introduced in 3.7.11.
* Bug fix: Do not discard the DISTINCT as superfluous unless a subset of the result set is subject to a UNIQUE constraint and it none of the columns in that subset can be NULL.
* Bug fix: Do not optimize away an ORDER BY clause that has the same terms as a UNIQUE index unless those terms are also NOT NULL.
Diffstat (limited to 'databases/sqlite3-docs/distinfo')
| -rw-r--r-- | databases/sqlite3-docs/distinfo | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo index d5b9834d6b8..ea1de0c9a22 100644 --- a/databases/sqlite3-docs/distinfo +++ b/databases/sqlite3-docs/distinfo @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.8 2012/03/20 21:00:47 adam Exp $ +$NetBSD: distinfo,v 1.9 2012/05/15 08:09:25 adam Exp $ -SHA1 (sqlite-doc-3071100.zip) = 87cbed1918c2604daefd3588a8555067e55e53cf -RMD160 (sqlite-doc-3071100.zip) = 388bbcccb69d458f48f044bd65d282d9cf48dbe2 -Size (sqlite-doc-3071100.zip) = 4069512 bytes +SHA1 (sqlite-doc-3071200.zip) = a5a71f0440816d731d30ad080429c971497b068d +RMD160 (sqlite-doc-3071200.zip) = ad50b126669bb04b1a69b56d967201c7c716f52a +Size (sqlite-doc-3071200.zip) = 4083373 bytes |