Sat Apr 11 12:42:06 2015 UTC ()
Changes 3.8.9:
Add VxWorks-7 as an officially supported and tested platform.
Added the sqlite3_status64() interface.
Fix memory size tracking so that it works even if SQLite uses more than 2GiB of memory.
Added the PRAGMA index_xinfo command.
Fix a potential 32-bit integer overflow problem in the sqlite3_blob_read() and sqlite3_blob_write() interfaces.
Ensure that prepared statements automatically reset on extended error codes of SQLITE_BUSY and SQLITE_LOCKED even when compiled using SQLITE_OMIT_AUTORESET.
Correct miscounts in the sqlite3_analyzer.exe utility related to WITHOUT ROWID tables.
Added the ".dbinfo" command to the command-line shell.
Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function.
Fix a bug in the fts3 snippet() function causing it to omit leading separator characters from snippets that begin with the first token in a column.


(adam)
diff -r1.93 -r1.94 pkgsrc/databases/sqlite3/Makefile
diff -r1.101 -r1.102 pkgsrc/databases/sqlite3/distinfo
diff -r1.40 -r1.41 pkgsrc/databases/sqlite3-docs/Makefile
diff -r1.38 -r1.39 pkgsrc/databases/sqlite3-docs/PLIST
diff -r1.38 -r1.39 pkgsrc/databases/sqlite3-docs/distinfo
diff -r1.72 -r1.73 pkgsrc/databases/sqlite3-tcl/Makefile
diff -r1.51 -r1.52 pkgsrc/databases/sqlite3-tcl/distinfo

cvs diff -r1.93 -r1.94 pkgsrc/databases/sqlite3/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/Makefile 2015/04/06 08:17:14 1.93
+++ pkgsrc/databases/sqlite3/Makefile 2015/04/11 12:42:06 1.94
@@ -1,18 +1,17 @@ @@ -1,18 +1,17 @@
1# $NetBSD: Makefile,v 1.93 2015/04/06 08:17:14 adam Exp $ 1# $NetBSD: Makefile,v 1.94 2015/04/11 12:42:06 adam Exp $
2 2
3DISTNAME= sqlite-autoconf-3080803 3DISTNAME= sqlite-autoconf-3080900
4PKGNAME= sqlite3-3.8.8.3 4PKGNAME= sqlite3-3.8.9
5PKGREVISION= 1 
6CATEGORIES= databases 5CATEGORIES= databases
7MASTER_SITES= http://www.hwaci.com/sw/sqlite/2015/ \ 6MASTER_SITES= http://www.hwaci.com/sw/sqlite/2015/ \
8 http://www.sqlite.org/2015/ 7 http://www.sqlite.org/2015/
9 8
10MAINTAINER= pkgsrc-users@NetBSD.org 9MAINTAINER= pkgsrc-users@NetBSD.org
11HOMEPAGE= http://www.sqlite.org/ 10HOMEPAGE= http://www.sqlite.org/
12COMMENT= SQL Database Engine in a C Library 11COMMENT= SQL Database Engine in a C Library
13LICENSE= public-domain 12LICENSE= public-domain
14 13
15.include "options.mk" 14.include "options.mk"
16 15
17USE_LIBTOOL= yes 16USE_LIBTOOL= yes
18USE_TOOLS+= gmake 17USE_TOOLS+= gmake

cvs diff -r1.101 -r1.102 pkgsrc/databases/sqlite3/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3/distinfo 2015/03/02 13:34:16 1.101
+++ pkgsrc/databases/sqlite3/distinfo 2015/04/11 12:42:06 1.102
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.101 2015/03/02 13:34:16 adam Exp $ 1$NetBSD: distinfo,v 1.102 2015/04/11 12:42:06 adam Exp $
2 2
3SHA1 (sqlite-autoconf-3080803.tar.gz) = 2fe3f6226a2a08a2e814b97cd53e36bb3c597112 3SHA1 (sqlite-autoconf-3080900.tar.gz) = db70dee268700b312cbaa5b3e5cf8454e1c8b7b9
4RMD160 (sqlite-autoconf-3080803.tar.gz) = 9063dd4ae39745dfe44d99f514ec084ee4442685 4RMD160 (sqlite-autoconf-3080900.tar.gz) = b89b63ccf07a5b55976643a41e6d7481c1ed284d
5Size (sqlite-autoconf-3080803.tar.gz) = 2021112 bytes 5Size (sqlite-autoconf-3080900.tar.gz) = 2037200 bytes

cvs diff -r1.40 -r1.41 pkgsrc/databases/sqlite3-docs/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-docs/Makefile 2015/03/02 13:34:16 1.40
+++ pkgsrc/databases/sqlite3-docs/Makefile 2015/04/11 12:42:06 1.41
@@ -1,17 +1,17 @@ @@ -1,17 +1,17 @@
1# $NetBSD: Makefile,v 1.40 2015/03/02 13:34:16 adam Exp $ 1# $NetBSD: Makefile,v 1.41 2015/04/11 12:42:06 adam Exp $
2 2
3DISTNAME= sqlite-doc-3080803 3DISTNAME= sqlite-doc-3080900
4PKGNAME= sqlite3-docs-3.8.8.3 4PKGNAME= sqlite3-docs-3.8.9
5CATEGORIES= databases 5CATEGORIES= databases
6MASTER_SITES= http://www.hwaci.com/sw/sqlite/2015/ \ 6MASTER_SITES= http://www.hwaci.com/sw/sqlite/2015/ \
7 http://www.sqlite.org/2015/ 7 http://www.sqlite.org/2015/
8EXTRACT_SUFX= .zip 8EXTRACT_SUFX= .zip
9 9
10MAINTAINER= pkgsrc-users@NetBSD.org 10MAINTAINER= pkgsrc-users@NetBSD.org
11HOMEPAGE= http://sqlite.org/ 11HOMEPAGE= http://sqlite.org/
12COMMENT= SQL Database Engine in a C Library (docs package) 12COMMENT= 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."

cvs diff -r1.38 -r1.39 pkgsrc/databases/sqlite3-docs/PLIST (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-docs/PLIST 2015/03/02 13:34:16 1.38
+++ pkgsrc/databases/sqlite3-docs/PLIST 2015/04/11 12:42:06 1.39
@@ -1,14 +1,14 @@ @@ -1,14 +1,14 @@
1@comment $NetBSD: PLIST,v 1.38 2015/03/02 13:34:16 adam Exp $ 1@comment $NetBSD: PLIST,v 1.39 2015/04/11 12:42:06 adam Exp $
2share/doc/sqlite3/34to35.html 2share/doc/sqlite3/34to35.html
3share/doc/sqlite3/35to36.html 3share/doc/sqlite3/35to36.html
4share/doc/sqlite3/about.html 4share/doc/sqlite3/about.html
5share/doc/sqlite3/aff_short.html 5share/doc/sqlite3/aff_short.html
6share/doc/sqlite3/affcase1.html 6share/doc/sqlite3/affcase1.html
7share/doc/sqlite3/amalgamation.html 7share/doc/sqlite3/amalgamation.html
8share/doc/sqlite3/appfileformat.html 8share/doc/sqlite3/appfileformat.html
9share/doc/sqlite3/arch.html 9share/doc/sqlite3/arch.html
10share/doc/sqlite3/asyncvfs.html 10share/doc/sqlite3/asyncvfs.html
11share/doc/sqlite3/atomiccommit.html 11share/doc/sqlite3/atomiccommit.html
12share/doc/sqlite3/autoinc.html 12share/doc/sqlite3/autoinc.html
13share/doc/sqlite3/backup.html 13share/doc/sqlite3/backup.html
14share/doc/sqlite3/books.html 14share/doc/sqlite3/books.html
@@ -206,26 +206,27 @@ share/doc/sqlite3/download.html @@ -206,26 +206,27 @@ share/doc/sqlite3/download.html
206share/doc/sqlite3/eqp.html 206share/doc/sqlite3/eqp.html
207share/doc/sqlite3/errlog.html 207share/doc/sqlite3/errlog.html
208share/doc/sqlite3/famous.html 208share/doc/sqlite3/famous.html
209share/doc/sqlite3/faq.html 209share/doc/sqlite3/faq.html
210share/doc/sqlite3/favicon.ico 210share/doc/sqlite3/favicon.ico
211share/doc/sqlite3/features.html 211share/doc/sqlite3/features.html
212share/doc/sqlite3/fileformat.html 212share/doc/sqlite3/fileformat.html
213share/doc/sqlite3/fileformat2.html 213share/doc/sqlite3/fileformat2.html
214share/doc/sqlite3/fileio.html 214share/doc/sqlite3/fileio.html
215share/doc/sqlite3/footprint.html 215share/doc/sqlite3/footprint.html
216share/doc/sqlite3/foreignkeys.html 216share/doc/sqlite3/foreignkeys.html
217share/doc/sqlite3/formatchng.html 217share/doc/sqlite3/formatchng.html
218share/doc/sqlite3/fts3.html 218share/doc/sqlite3/fts3.html
 219share/doc/sqlite3/fts5.html
219share/doc/sqlite3/getthecode.html 220share/doc/sqlite3/getthecode.html
220share/doc/sqlite3/howtocompile.html 221share/doc/sqlite3/howtocompile.html
221share/doc/sqlite3/howtocorrupt.html 222share/doc/sqlite3/howtocorrupt.html
222share/doc/sqlite3/hp1.html 223share/doc/sqlite3/hp1.html
223share/doc/sqlite3/images/2005osaward.gif 224share/doc/sqlite3/images/2005osaward.gif
224share/doc/sqlite3/images/SQLite.gif 225share/doc/sqlite3/images/SQLite.gif
225share/doc/sqlite3/images/SQLite_big.gif 226share/doc/sqlite3/images/SQLite_big.gif
226share/doc/sqlite3/images/ac/commit-0.gif 227share/doc/sqlite3/images/ac/commit-0.gif
227share/doc/sqlite3/images/ac/commit-1.gif 228share/doc/sqlite3/images/ac/commit-1.gif
228share/doc/sqlite3/images/ac/commit-2.gif 229share/doc/sqlite3/images/ac/commit-2.gif
229share/doc/sqlite3/images/ac/commit-3.gif 230share/doc/sqlite3/images/ac/commit-3.gif
230share/doc/sqlite3/images/ac/commit-4.gif 231share/doc/sqlite3/images/ac/commit-4.gif
231share/doc/sqlite3/images/ac/commit-5.gif 232share/doc/sqlite3/images/ac/commit-5.gif
@@ -324,26 +325,30 @@ share/doc/sqlite3/images/foreignlogos/sk @@ -324,26 +325,30 @@ share/doc/sqlite3/images/foreignlogos/sk
324share/doc/sqlite3/images/foreignlogos/sony.gif 325share/doc/sqlite3/images/foreignlogos/sony.gif
325share/doc/sqlite3/images/foreignlogos/sunmicro.gif 326share/doc/sqlite3/images/foreignlogos/sunmicro.gif
326share/doc/sqlite3/images/foreignlogos/symbian.gif 327share/doc/sqlite3/images/foreignlogos/symbian.gif
327share/doc/sqlite3/images/foreignlogos/tcl.gif 328share/doc/sqlite3/images/foreignlogos/tcl.gif
328share/doc/sqlite3/images/foreignlogos/toshiba.gif 329share/doc/sqlite3/images/foreignlogos/toshiba.gif
329share/doc/sqlite3/images/fts3_doclist.png 330share/doc/sqlite3/images/fts3_doclist.png
330share/doc/sqlite3/images/fts3_doclist.svg 331share/doc/sqlite3/images/fts3_doclist.svg
331share/doc/sqlite3/images/fts3_doclist2.png 332share/doc/sqlite3/images/fts3_doclist2.png
332share/doc/sqlite3/images/fts3_doclist2.svg 333share/doc/sqlite3/images/fts3_doclist2.svg
333share/doc/sqlite3/images/fts3_interior_node.png 334share/doc/sqlite3/images/fts3_interior_node.png
334share/doc/sqlite3/images/fts3_interior_node.svg 335share/doc/sqlite3/images/fts3_interior_node.svg
335share/doc/sqlite3/images/fts3_leaf_node.png 336share/doc/sqlite3/images/fts3_leaf_node.png
336share/doc/sqlite3/images/fts3_leaf_node.svg 337share/doc/sqlite3/images/fts3_leaf_node.svg
 338share/doc/sqlite3/images/fts5_formula.odf
 339share/doc/sqlite3/images/fts5_formula1.png
 340share/doc/sqlite3/images/fts5_formula2.png
 341share/doc/sqlite3/images/fts5_formula3.png
337share/doc/sqlite3/images/fullscanb.gif 342share/doc/sqlite3/images/fullscanb.gif
338share/doc/sqlite3/images/harmony.gif 343share/doc/sqlite3/images/harmony.gif
339share/doc/sqlite3/images/index-ex1-x-b.gif 344share/doc/sqlite3/images/index-ex1-x-b.gif
340share/doc/sqlite3/images/indirect1b1.gif 345share/doc/sqlite3/images/indirect1b1.gif
341share/doc/sqlite3/images/joe1.jpg 346share/doc/sqlite3/images/joe1.jpg
342share/doc/sqlite3/images/ne.gif 347share/doc/sqlite3/images/ne.gif
343share/doc/sqlite3/images/ne.png 348share/doc/sqlite3/images/ne.png
344share/doc/sqlite3/images/nocopy.gif 349share/doc/sqlite3/images/nocopy.gif
345share/doc/sqlite3/images/nw.gif 350share/doc/sqlite3/images/nw.gif
346share/doc/sqlite3/images/nw.png 351share/doc/sqlite3/images/nw.png
347share/doc/sqlite3/images/powered_by_sqlite.gif 352share/doc/sqlite3/images/powered_by_sqlite.gif
348share/doc/sqlite3/images/private_branch.gif 353share/doc/sqlite3/images/private_branch.gif
349share/doc/sqlite3/images/qp/fqp1.gif 354share/doc/sqlite3/images/qp/fqp1.gif
@@ -629,26 +634,27 @@ share/doc/sqlite3/releaselog/3_8_4_1.htm @@ -629,26 +634,27 @@ share/doc/sqlite3/releaselog/3_8_4_1.htm
629share/doc/sqlite3/releaselog/3_8_4_2.html 634share/doc/sqlite3/releaselog/3_8_4_2.html
630share/doc/sqlite3/releaselog/3_8_4_3.html 635share/doc/sqlite3/releaselog/3_8_4_3.html
631share/doc/sqlite3/releaselog/3_8_5.html 636share/doc/sqlite3/releaselog/3_8_5.html
632share/doc/sqlite3/releaselog/3_8_6.html 637share/doc/sqlite3/releaselog/3_8_6.html
633share/doc/sqlite3/releaselog/3_8_7.html 638share/doc/sqlite3/releaselog/3_8_7.html
634share/doc/sqlite3/releaselog/3_8_7_1.html 639share/doc/sqlite3/releaselog/3_8_7_1.html
635share/doc/sqlite3/releaselog/3_8_7_2.html 640share/doc/sqlite3/releaselog/3_8_7_2.html
636share/doc/sqlite3/releaselog/3_8_7_3.html 641share/doc/sqlite3/releaselog/3_8_7_3.html
637share/doc/sqlite3/releaselog/3_8_7_4.html 642share/doc/sqlite3/releaselog/3_8_7_4.html
638share/doc/sqlite3/releaselog/3_8_8.html 643share/doc/sqlite3/releaselog/3_8_8.html
639share/doc/sqlite3/releaselog/3_8_8_1.html 644share/doc/sqlite3/releaselog/3_8_8_1.html
640share/doc/sqlite3/releaselog/3_8_8_2.html 645share/doc/sqlite3/releaselog/3_8_8_2.html
641share/doc/sqlite3/releaselog/3_8_8_3.html 646share/doc/sqlite3/releaselog/3_8_8_3.html
 647share/doc/sqlite3/releaselog/3_8_9.html
642share/doc/sqlite3/releaselog/current.html 648share/doc/sqlite3/releaselog/current.html
643share/doc/sqlite3/requirements.html 649share/doc/sqlite3/requirements.html
644share/doc/sqlite3/rescode.html 650share/doc/sqlite3/rescode.html
645share/doc/sqlite3/robots.txt 651share/doc/sqlite3/robots.txt
646share/doc/sqlite3/rtree.html 652share/doc/sqlite3/rtree.html
647share/doc/sqlite3/selfcontained.html 653share/doc/sqlite3/selfcontained.html
648share/doc/sqlite3/serverless.html 654share/doc/sqlite3/serverless.html
649share/doc/sqlite3/session.html 655share/doc/sqlite3/session.html
650share/doc/sqlite3/session/constlist.html 656share/doc/sqlite3/session/constlist.html
651share/doc/sqlite3/session/funclist.html 657share/doc/sqlite3/session/funclist.html
652share/doc/sqlite3/session/intro.html 658share/doc/sqlite3/session/intro.html
653share/doc/sqlite3/session/objlist.html 659share/doc/sqlite3/session/objlist.html
654share/doc/sqlite3/sharedcache.html 660share/doc/sqlite3/sharedcache.html

cvs diff -r1.38 -r1.39 pkgsrc/databases/sqlite3-docs/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-docs/distinfo 2015/03/02 13:34:16 1.38
+++ pkgsrc/databases/sqlite3-docs/distinfo 2015/04/11 12:42:06 1.39
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.38 2015/03/02 13:34:16 adam Exp $ 1$NetBSD: distinfo,v 1.39 2015/04/11 12:42:06 adam Exp $
2 2
3SHA1 (sqlite-doc-3080803.zip) = 27c2cada8e663f694c0469bcae09eb0d8c55dd7c 3SHA1 (sqlite-doc-3080900.zip) = c677b73a0be5419427a01431d24d718ec4cde6a9
4RMD160 (sqlite-doc-3080803.zip) = 3eae7234ce9f3df40a65b2b17b8ecb73600e630e 4RMD160 (sqlite-doc-3080900.zip) = 0567148dc603a5b633dea7b756c0edcf671d3857
5Size (sqlite-doc-3080803.zip) = 4972781 bytes 5Size (sqlite-doc-3080900.zip) = 5025367 bytes

cvs diff -r1.72 -r1.73 pkgsrc/databases/sqlite3-tcl/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-tcl/Makefile 2015/04/06 08:17:24 1.72
+++ pkgsrc/databases/sqlite3-tcl/Makefile 2015/04/11 12:42:06 1.73
@@ -1,18 +1,17 @@ @@ -1,18 +1,17 @@
1# $NetBSD: Makefile,v 1.72 2015/04/06 08:17:24 adam Exp $ 1# $NetBSD: Makefile,v 1.73 2015/04/11 12:42:06 adam Exp $
2 2
3DISTNAME= sqlite-autoconf-3080803 3DISTNAME= sqlite-autoconf-3080900
4PKGNAME= sqlite3-tcl-3.8.8.3 4PKGNAME= sqlite3-tcl-3.8.9
5PKGREVISION= 1 
6CATEGORIES= databases 5CATEGORIES= databases
7MASTER_SITES= http://www.hwaci.com/sw/sqlite/2015/ \ 6MASTER_SITES= http://www.hwaci.com/sw/sqlite/2015/ \
8 http://www.sqlite.org/2015/ 7 http://www.sqlite.org/2015/
9 8
10MAINTAINER= pkgsrc-users@NetBSD.org 9MAINTAINER= pkgsrc-users@NetBSD.org
11HOMEPAGE= http://www.sqlite.org/ 10HOMEPAGE= http://www.sqlite.org/
12COMMENT= SQL Database Engine in a C Library (TCL extension) 11COMMENT= SQL Database Engine in a C Library (TCL extension)
13LICENSE= public-domain 12LICENSE= public-domain
14 13
15WRKSRC= ${WRKDIR}/${DISTNAME}/tea 14WRKSRC= ${WRKDIR}/${DISTNAME}/tea
16 15
17USE_TOOLS+= gmake 16USE_TOOLS+= gmake
18GNU_CONFIGURE= yes 17GNU_CONFIGURE= yes

cvs diff -r1.51 -r1.52 pkgsrc/databases/sqlite3-tcl/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/sqlite3-tcl/distinfo 2015/03/02 13:34:16 1.51
+++ pkgsrc/databases/sqlite3-tcl/distinfo 2015/04/11 12:42:06 1.52
@@ -1,6 +1,6 @@ @@ -1,6 +1,6 @@
1$NetBSD: distinfo,v 1.51 2015/03/02 13:34:16 adam Exp $ 1$NetBSD: distinfo,v 1.52 2015/04/11 12:42:06 adam Exp $
2 2
3SHA1 (sqlite-autoconf-3080803.tar.gz) = 2fe3f6226a2a08a2e814b97cd53e36bb3c597112 3SHA1 (sqlite-autoconf-3080900.tar.gz) = db70dee268700b312cbaa5b3e5cf8454e1c8b7b9
4RMD160 (sqlite-autoconf-3080803.tar.gz) = 9063dd4ae39745dfe44d99f514ec084ee4442685 4RMD160 (sqlite-autoconf-3080900.tar.gz) = b89b63ccf07a5b55976643a41e6d7481c1ed284d
5Size (sqlite-autoconf-3080803.tar.gz) = 2021112 bytes 5Size (sqlite-autoconf-3080900.tar.gz) = 2037200 bytes
6SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d 6SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d