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.diff -r1.50 -r1.51 pkgsrc/databases/sqlite3/Makefile
(adam)
@@ -1,18 +1,17 @@ | @@ -1,18 +1,17 @@ | |||
1 | # $NetBSD: Makefile,v 1.50 2012/04/27 12:31:40 obache Exp $ | 1 | # $NetBSD: Makefile,v 1.51 2012/05/15 08:09:25 adam Exp $ | |
2 | 2 | |||
3 | DISTNAME= sqlite-autoconf-3071100 | 3 | DISTNAME= sqlite-autoconf-3071200 | |
4 | PKGNAME= sqlite3-3.7.11 | 4 | PKGNAME= sqlite3-3.7.12 | |
5 | PKGREVISION= 1 | |||
6 | CATEGORIES= databases | 5 | CATEGORIES= databases | |
7 | MASTER_SITES= http://www.hwaci.com/sw/sqlite/ \ | 6 | MASTER_SITES= http://www.hwaci.com/sw/sqlite/ \ | |
8 | http://www.sqlite.org/ | 7 | http://www.sqlite.org/ | |
9 | 8 | |||
10 | MAINTAINER= pkgsrc-users@NetBSD.org | 9 | MAINTAINER= pkgsrc-users@NetBSD.org | |
11 | HOMEPAGE= http://www.sqlite.org/ | 10 | HOMEPAGE= http://www.sqlite.org/ | |
12 | COMMENT= SQL Database Engine in a C Library | 11 | COMMENT= SQL Database Engine in a C Library | |
13 | LICENSE= public-domain | 12 | LICENSE= public-domain | |
14 | 13 | |||
15 | PKG_DESTDIR_SUPPORT= user-destdir | 14 | PKG_DESTDIR_SUPPORT= user-destdir | |
16 | 15 | |||
17 | .include "options.mk" | 16 | .include "options.mk" | |
18 | 17 |
@@ -1,5 +1,5 @@ | @@ -1,5 +1,5 @@ | |||
1 | $NetBSD: distinfo,v 1.67 2012/03/20 21:00:47 adam Exp $ | 1 | $NetBSD: distinfo,v 1.68 2012/05/15 08:09:25 adam Exp $ | |
2 | 2 | |||
3 | SHA1 (sqlite-autoconf-3071100.tar.gz) = a768f76b10df84d6a2c66178544d42725a8fdaf0 | 3 | SHA1 (sqlite-autoconf-3071200.tar.gz) = 30e6b0912f074cff5563697367c2ba9608d83bd3 | |
4 | RMD160 (sqlite-autoconf-3071100.tar.gz) = 09df3232f4eb7032c0a6081670b2bdcb6d80e865 | 4 | RMD160 (sqlite-autoconf-3071200.tar.gz) = 395d8d137a8d5627bd85a91c4751b0a24933cee2 | |
5 | Size (sqlite-autoconf-3071100.tar.gz) = 1807754 bytes | 5 | Size (sqlite-autoconf-3071200.tar.gz) = 1827241 bytes |
@@ -1,17 +1,17 @@ | @@ -1,17 +1,17 @@ | |||
1 | # $NetBSD: Makefile,v 1.8 2012/03/20 21:00:47 adam Exp $ | 1 | # $NetBSD: Makefile,v 1.9 2012/05/15 08:09:25 adam Exp $ | |
2 | 2 | |||
3 | DISTNAME= sqlite-doc-3071100 | 3 | DISTNAME= sqlite-doc-3071200 | |
4 | PKGNAME= sqlite3-docs-3.7.11 | 4 | PKGNAME= sqlite3-docs-3.7.12 | |
5 | CATEGORIES= databases | 5 | CATEGORIES= databases | |
6 | MASTER_SITES= http://www.hwaci.com/sw/sqlite/ \ | 6 | MASTER_SITES= http://www.hwaci.com/sw/sqlite/ \ | |
7 | http://www.sqlite.org/ | 7 | http://www.sqlite.org/ | |
8 | EXTRACT_SUFX= .zip | 8 | EXTRACT_SUFX= .zip | |
9 | 9 | |||
10 | MAINTAINER= pkgsrc-users@NetBSD.org | 10 | MAINTAINER= pkgsrc-users@NetBSD.org | |
11 | HOMEPAGE= http://sqlite.org/ | 11 | HOMEPAGE= http://sqlite.org/ | |
12 | COMMENT= SQL Database Engine in a C Library (docs package) | 12 | COMMENT= SQL Database Engine in a C Library (docs package) | |
13 | # "Portions of the documentation and some code used as part of the | 13 | # "Portions of the documentation and some code used as part of the | |
14 | # build process might fall under other licenses. We do not worry | 14 | # build process might fall under other licenses. We do not worry | |
15 | # about the licensing of the documentation and build code so much | 15 | # about the licensing of the documentation and build code so much | |
16 | # because none of these things are part of the core deliverable SQLite | 16 | # because none of these things are part of the core deliverable SQLite | |
17 | # library." | 17 | # library." |
@@ -1,14 +1,14 @@ | @@ -1,14 +1,14 @@ | |||
1 | @comment $NetBSD: PLIST,v 1.8 2012/03/20 21:00:47 adam Exp $ | 1 | @comment $NetBSD: PLIST,v 1.9 2012/05/15 08:09:25 adam Exp $ | |
2 | share/doc/sqlite3/34to35.html | 2 | share/doc/sqlite3/34to35.html | |
3 | share/doc/sqlite3/35to36.html | 3 | share/doc/sqlite3/35to36.html | |
4 | share/doc/sqlite3/about.html | 4 | share/doc/sqlite3/about.html | |
5 | share/doc/sqlite3/amalgamation.html | 5 | share/doc/sqlite3/amalgamation.html | |
6 | share/doc/sqlite3/arch.html | 6 | share/doc/sqlite3/arch.html | |
7 | share/doc/sqlite3/asyncvfs.html | 7 | share/doc/sqlite3/asyncvfs.html | |
8 | share/doc/sqlite3/atomiccommit.html | 8 | share/doc/sqlite3/atomiccommit.html | |
9 | share/doc/sqlite3/autoinc.html | 9 | share/doc/sqlite3/autoinc.html | |
10 | share/doc/sqlite3/backup.html | 10 | share/doc/sqlite3/backup.html | |
11 | share/doc/sqlite3/books.html | 11 | share/doc/sqlite3/books.html | |
12 | share/doc/sqlite3/btreemodule.html | 12 | share/doc/sqlite3/btreemodule.html | |
13 | share/doc/sqlite3/c3ref/aggregate_context.html | 13 | share/doc/sqlite3/c3ref/aggregate_context.html | |
14 | share/doc/sqlite3/c3ref/aggregate_count.html | 14 | share/doc/sqlite3/c3ref/aggregate_count.html | |
@@ -549,26 +549,27 @@ share/doc/sqlite3/releaselog/3_6_3.html | @@ -549,26 +549,27 @@ share/doc/sqlite3/releaselog/3_6_3.html | |||
549 | share/doc/sqlite3/releaselog/3_6_4.html | 549 | share/doc/sqlite3/releaselog/3_6_4.html | |
550 | share/doc/sqlite3/releaselog/3_6_5.html | 550 | share/doc/sqlite3/releaselog/3_6_5.html | |
551 | share/doc/sqlite3/releaselog/3_6_6.html | 551 | share/doc/sqlite3/releaselog/3_6_6.html | |
552 | share/doc/sqlite3/releaselog/3_6_6_1.html | 552 | share/doc/sqlite3/releaselog/3_6_6_1.html | |
553 | share/doc/sqlite3/releaselog/3_6_6_2.html | 553 | share/doc/sqlite3/releaselog/3_6_6_2.html | |
554 | share/doc/sqlite3/releaselog/3_6_7.html | 554 | share/doc/sqlite3/releaselog/3_6_7.html | |
555 | share/doc/sqlite3/releaselog/3_6_8.html | 555 | share/doc/sqlite3/releaselog/3_6_8.html | |
556 | share/doc/sqlite3/releaselog/3_6_9.html | 556 | share/doc/sqlite3/releaselog/3_6_9.html | |
557 | share/doc/sqlite3/releaselog/3_7_0.html | 557 | share/doc/sqlite3/releaselog/3_7_0.html | |
558 | share/doc/sqlite3/releaselog/3_7_0_1.html | 558 | share/doc/sqlite3/releaselog/3_7_0_1.html | |
559 | share/doc/sqlite3/releaselog/3_7_1.html | 559 | share/doc/sqlite3/releaselog/3_7_1.html | |
560 | share/doc/sqlite3/releaselog/3_7_10.html | 560 | share/doc/sqlite3/releaselog/3_7_10.html | |
561 | share/doc/sqlite3/releaselog/3_7_11.html | 561 | share/doc/sqlite3/releaselog/3_7_11.html | |
562 | share/doc/sqlite3/releaselog/3_7_12.html | |||
562 | share/doc/sqlite3/releaselog/3_7_2.html | 563 | share/doc/sqlite3/releaselog/3_7_2.html | |
563 | share/doc/sqlite3/releaselog/3_7_3.html | 564 | share/doc/sqlite3/releaselog/3_7_3.html | |
564 | share/doc/sqlite3/releaselog/3_7_4.html | 565 | share/doc/sqlite3/releaselog/3_7_4.html | |
565 | share/doc/sqlite3/releaselog/3_7_5.html | 566 | share/doc/sqlite3/releaselog/3_7_5.html | |
566 | share/doc/sqlite3/releaselog/3_7_6.html | 567 | share/doc/sqlite3/releaselog/3_7_6.html | |
567 | share/doc/sqlite3/releaselog/3_7_6_1.html | 568 | share/doc/sqlite3/releaselog/3_7_6_1.html | |
568 | share/doc/sqlite3/releaselog/3_7_6_2.html | 569 | share/doc/sqlite3/releaselog/3_7_6_2.html | |
569 | share/doc/sqlite3/releaselog/3_7_6_3.html | 570 | share/doc/sqlite3/releaselog/3_7_6_3.html | |
570 | share/doc/sqlite3/releaselog/3_7_7.html | 571 | share/doc/sqlite3/releaselog/3_7_7.html | |
571 | share/doc/sqlite3/releaselog/3_7_7_1.html | 572 | share/doc/sqlite3/releaselog/3_7_7_1.html | |
572 | share/doc/sqlite3/releaselog/3_7_8.html | 573 | share/doc/sqlite3/releaselog/3_7_8.html | |
573 | share/doc/sqlite3/releaselog/3_7_9.html | 574 | share/doc/sqlite3/releaselog/3_7_9.html | |
574 | share/doc/sqlite3/requirements.html | 575 | share/doc/sqlite3/requirements.html |
@@ -1,5 +1,5 @@ | @@ -1,5 +1,5 @@ | |||
1 | $NetBSD: distinfo,v 1.8 2012/03/20 21:00:47 adam Exp $ | 1 | $NetBSD: distinfo,v 1.9 2012/05/15 08:09:25 adam Exp $ | |
2 | 2 | |||
3 | SHA1 (sqlite-doc-3071100.zip) = 87cbed1918c2604daefd3588a8555067e55e53cf | 3 | SHA1 (sqlite-doc-3071200.zip) = a5a71f0440816d731d30ad080429c971497b068d | |
4 | RMD160 (sqlite-doc-3071100.zip) = 388bbcccb69d458f48f044bd65d282d9cf48dbe2 | 4 | RMD160 (sqlite-doc-3071200.zip) = ad50b126669bb04b1a69b56d967201c7c716f52a | |
5 | Size (sqlite-doc-3071100.zip) = 4069512 bytes | 5 | Size (sqlite-doc-3071200.zip) = 4083373 bytes |
@@ -1,18 +1,17 @@ | @@ -1,18 +1,17 @@ | |||
1 | # $NetBSD: Makefile,v 1.32 2012/04/27 12:31:40 obache Exp $ | 1 | # $NetBSD: Makefile,v 1.33 2012/05/15 08:09:25 adam Exp $ | |
2 | 2 | |||
3 | DISTNAME= sqlite-autoconf-3071100 | 3 | DISTNAME= sqlite-autoconf-3071200 | |
4 | PKGNAME= sqlite3-tcl-3.7.11 | 4 | PKGNAME= sqlite3-tcl-3.7.12 | |
5 | PKGREVISION= 1 | |||
6 | CATEGORIES= databases | 5 | CATEGORIES= databases | |
7 | MASTER_SITES= http://www.hwaci.com/sw/sqlite/ \ | 6 | MASTER_SITES= http://www.hwaci.com/sw/sqlite/ \ | |
8 | http://www.sqlite.org/ | 7 | http://www.sqlite.org/ | |
9 | 8 | |||
10 | MAINTAINER= pkgsrc-users@NetBSD.org | 9 | MAINTAINER= pkgsrc-users@NetBSD.org | |
11 | HOMEPAGE= http://www.sqlite.org/ | 10 | HOMEPAGE= http://www.sqlite.org/ | |
12 | COMMENT= SQL Database Engine in a C Library (TCL extension) | 11 | COMMENT= SQL Database Engine in a C Library (TCL extension) | |
13 | LICENSE= public-domain | 12 | LICENSE= public-domain | |
14 | 13 | |||
15 | PKG_DESTDIR_SUPPORT= user-destdir | 14 | PKG_DESTDIR_SUPPORT= user-destdir | |
16 | 15 | |||
17 | WRKSRC= ${WRKDIR}/${DISTNAME}/tea | 16 | WRKSRC= ${WRKDIR}/${DISTNAME}/tea | |
18 | 17 |
@@ -1,7 +1,7 @@ | @@ -1,7 +1,7 @@ | |||
1 | $NetBSD: distinfo,v 1.20 2012/03/20 21:00:47 adam Exp $ | 1 | $NetBSD: distinfo,v 1.21 2012/05/15 08:09:25 adam Exp $ | |
2 | 2 | |||
3 | SHA1 (sqlite-autoconf-3071100.tar.gz) = a768f76b10df84d6a2c66178544d42725a8fdaf0 | 3 | SHA1 (sqlite-autoconf-3071200.tar.gz) = 30e6b0912f074cff5563697367c2ba9608d83bd3 | |
4 | RMD160 (sqlite-autoconf-3071100.tar.gz) = 09df3232f4eb7032c0a6081670b2bdcb6d80e865 | 4 | RMD160 (sqlite-autoconf-3071200.tar.gz) = 395d8d137a8d5627bd85a91c4751b0a24933cee2 | |
5 | Size (sqlite-autoconf-3071100.tar.gz) = 1807754 bytes | 5 | Size (sqlite-autoconf-3071200.tar.gz) = 1827241 bytes | |
6 | SHA1 (patch-aa) = d4d0424eec39ede995c2c408dcf51876072d3fea | 6 | SHA1 (patch-aa) = d4d0424eec39ede995c2c408dcf51876072d3fea | |
7 | SHA1 (patch-ab) = 64a4352b9a8ed0518784837e390541cd4e1bc9aa | 7 | SHA1 (patch-ab) = 64a4352b9a8ed0518784837e390541cd4e1bc9aa |