Changes 3.8.3:

Added support for common table expressions and the WITH clause.
Added the printf() SQL function.
Added SQLITE_DETERMINISTIC as an optional bit in the 4th argument to the sqlite3_create_function() and related interfaces, providing applications with the ability to create new functions that can be factored out of inner loops when they have constant arguments.
Add SQLITE_READONLY_DBMOVED error code, returned at the beginning of a transaction, to indicate that the underlying database file has been renamed or moved out from under SQLite.
Allow arbitrary expressions, including function calls and subqueries, in the filename argument to ATTACH.
Allow a VALUES clause to be used anywhere a SELECT statement is valid.
Reseed the PRNG used by sqlite3_randomness(N,P) when invoked with N==0. Automatically reseed after a fork() on unix.
Enhance the spellfix1 virtual table so that it can search efficiently by rowid.
Performance enhancements.
Improvements to the comments in the VDBE byte-code display when running EXPLAIN.
Add the "%token_class" directive to LEMON parser generator and use it to simplify the grammar.
Change the LEMON source code to avoid calling C-library functions that OpenBSD considers dangerous. (Ex: sprintf).
Bug fix: In the command-line shell CSV import feature, do not end a field when an escaped double-quote occurs at the end of a CRLN line.

4 files changed, 20 insertions, 17 deletions

diff --git a/databases/sqlite3-tcl/Makefile b/databases/sqlite3-tcl/Makefile
index cf273d0eb31..f5fb7d740d5 100644
--- a/databases/sqlite3-tcl/Makefile
+++ b/databases/sqlite3-tcl/Makefile
@@ -1,11 +1,10 @@
-# $NetBSD: Makefile,v 1.53 2014/01/11 14:42:02 adam Exp $
+# $NetBSD: Makefile,v 1.54 2014/02/04 13:28:08 adam Exp $
 
-DISTNAME=	sqlite-autoconf-3080200
-PKGNAME=	sqlite3-tcl-3.8.2
-PKGREVISION=	1
+DISTNAME=	sqlite-autoconf-3080300
+PKGNAME=	sqlite3-tcl-3.8.3
 CATEGORIES=	databases
-MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2013/ \
-		http://www.sqlite.org/2013/
+MASTER_SITES=	http://www.hwaci.com/sw/sqlite/2014/ \
+		http://www.sqlite.org/2014/
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
 HOMEPAGE=	http://www.sqlite.org/
@@ -22,6 +21,10 @@ PLIST_SUBST+=		TCL_TRIM_DOTS=${PKGVERSION_NOREV:S/.//g}
 
 BUILDLINK_API_DEPENDS.sqlite3+=	sqlite3>=3.6.10
 
+# avoid conflict with lang/tcl
+post-extract:
+	mv ${WRKSRC}/doc/sqlite3.n ${WRKSRC}/doc/sqlite3-tcl.n
+
 .include "../../databases/sqlite3/buildlink3.mk"
 .include "../../lang/tcl/buildlink3.mk"
 .include "../../mk/readline.buildlink3.mk"
diff --git a/databases/sqlite3-tcl/PLIST b/databases/sqlite3-tcl/PLIST
index e376680bd21..ab97e285f07 100644
--- a/databases/sqlite3-tcl/PLIST
+++ b/databases/sqlite3-tcl/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.8 2010/08/08 12:04:37 adam Exp $
-lib/tcl8.4/sqlite3/libsqlite${PKGVERSION}.so
-lib/tcl8.4/sqlite3/pkgIndex.tcl
-man/mann/sqlite3.n
+@comment $NetBSD: PLIST,v 1.9 2014/02/04 13:28:08 adam Exp $
+lib/sqlite3/libsqlite${PKGVERSION}.so
+lib/sqlite3/pkgIndex.tcl
+man/mann/sqlite3-tcl.n
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 5b7293c6a14..47e50f8a300 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.35 2013/12/06 19:26:58 adam Exp $
+$NetBSD: distinfo,v 1.36 2014/02/04 13:28:08 adam Exp $
 
-SHA1 (sqlite-autoconf-3080200.tar.gz) = 6033ef603ce221d367c665477514d972ef1dc90e
-RMD160 (sqlite-autoconf-3080200.tar.gz) = e3ea6439b9502a478e6678d01b7f17db1d4a1c83
-Size (sqlite-autoconf-3080200.tar.gz) = 1917056 bytes
-SHA1 (patch-aa) = d4d0424eec39ede995c2c408dcf51876072d3fea
+SHA1 (sqlite-autoconf-3080300.tar.gz) = c2a21d71d0c7dc3af71cf90f04dfd22ecfb280c2
+RMD160 (sqlite-autoconf-3080300.tar.gz) = a797629a2722c6b1df4d6ee4bc97ef60258fbbb1
+Size (sqlite-autoconf-3080300.tar.gz) = 1923594 bytes
+SHA1 (patch-aa) = c52c1b1d92f1f24b80315a2dba6777e64d7573de
 SHA1 (patch-ab) = 64a4352b9a8ed0518784837e390541cd4e1bc9aa
diff --git a/databases/sqlite3-tcl/patches/patch-aa b/databases/sqlite3-tcl/patches/patch-aa
index 8e4d78128c7..a6104bf8e82 100644
--- a/databases/sqlite3-tcl/patches/patch-aa
+++ b/databases/sqlite3-tcl/patches/patch-aa
@@ -1,4 +1,4 @@
-$NetBSD: patch-aa,v 1.1 2009/11/21 16:58:05 tnn Exp $
+$NetBSD: patch-aa,v 1.2 2014/02/04 13:28:08 adam Exp $
 
 --- Makefile.in.orig	2009-04-13 11:18:29.000000000 +0200
 +++ Makefile.in
@@ -7,7 +7,7 @@ $NetBSD: patch-aa,v 1.1 2009/11/21 16:58:05 tnn Exp $
  PKG_DIR		= $(PACKAGE_NAME)$(PACKAGE_VERSION)
  pkgdatadir	= $(datadir)/$(PKG_DIR)
 -pkglibdir	= $(libdir)/$(PKG_DIR)
-+pkglibdir	= $(libdir)/tcl8.4/sqlite3
++pkglibdir	= $(libdir)/sqlite3
  pkgincludedir	= $(includedir)/$(PKG_DIR)
  
  top_builddir	= .