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.

9 files changed, 52 insertions, 39 deletions

diff --git a/databases/sqlite3-docs/Makefile b/databases/sqlite3-docs/Makefile
index a5c95f244c9..48c9a9c20b0 100644
--- a/databases/sqlite3-docs/Makefile
+++ b/databases/sqlite3-docs/Makefile
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile,v 1.24 2013/12/06 19:26:58 adam Exp $
+# $NetBSD: Makefile,v 1.25 2014/02/04 13:28:07 adam Exp $
 
-DISTNAME=	sqlite-doc-3080200
-PKGNAME=	sqlite3-docs-3.8.2
+DISTNAME=	sqlite-doc-3080300
+PKGNAME=	sqlite3-docs-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/
 EXTRACT_SUFX=	.zip
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index e16e6da725c..67178529608 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.22 2013/12/06 19:26:58 adam Exp $
+@comment $NetBSD: PLIST,v 1.23 2014/02/04 13:28:07 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -39,6 +39,7 @@ share/doc/sqlite3/c3ref/c_config_covering_index_scan.html
 share/doc/sqlite3/c3ref/c_dbconfig_enable_fkey.html
 share/doc/sqlite3/c3ref/c_dbstatus_options.html
 share/doc/sqlite3/c3ref/c_deny.html
+share/doc/sqlite3/c3ref/c_deterministic.html
 share/doc/sqlite3/c3ref/c_fail.html
 share/doc/sqlite3/c3ref/c_fcntl_busyhandler.html
 share/doc/sqlite3/c3ref/c_index_constraint_eq.html
@@ -374,13 +375,16 @@ share/doc/sqlite3/images/syntax/column-constraint.gif
 share/doc/sqlite3/images/syntax/column-def.gif
 share/doc/sqlite3/images/syntax/comment-syntax.gif
 share/doc/sqlite3/images/syntax/commit-stmt.gif
+share/doc/sqlite3/images/syntax/common-table-expression.gif
 share/doc/sqlite3/images/syntax/compound-operator.gif
+share/doc/sqlite3/images/syntax/compound-select-stmt.gif
 share/doc/sqlite3/images/syntax/conflict-clause.gif
 share/doc/sqlite3/images/syntax/create-index-stmt.gif
 share/doc/sqlite3/images/syntax/create-table-stmt.gif
 share/doc/sqlite3/images/syntax/create-trigger-stmt.gif
 share/doc/sqlite3/images/syntax/create-view-stmt.gif
 share/doc/sqlite3/images/syntax/create-virtual-table-stmt.gif
+share/doc/sqlite3/images/syntax/cte-table-name.gif
 share/doc/sqlite3/images/syntax/delete-stmt-limited.gif
 share/doc/sqlite3/images/syntax/delete-stmt.gif
 share/doc/sqlite3/images/syntax/detach-stmt.gif
@@ -389,12 +393,13 @@ share/doc/sqlite3/images/syntax/drop-table-stmt.gif
 share/doc/sqlite3/images/syntax/drop-trigger-stmt.gif
 share/doc/sqlite3/images/syntax/drop-view-stmt.gif
 share/doc/sqlite3/images/syntax/expr.gif
+share/doc/sqlite3/images/syntax/factored-select-stmt.gif
 share/doc/sqlite3/images/syntax/foreign-key-clause.gif
 share/doc/sqlite3/images/syntax/indexed-column.gif
 share/doc/sqlite3/images/syntax/insert-stmt.gif
+share/doc/sqlite3/images/syntax/join-clause.gif
 share/doc/sqlite3/images/syntax/join-constraint.gif
-share/doc/sqlite3/images/syntax/join-op.gif
-share/doc/sqlite3/images/syntax/join-source.gif
+share/doc/sqlite3/images/syntax/join-operator.gif
 share/doc/sqlite3/images/syntax/literal-value.gif
 share/doc/sqlite3/images/syntax/numeric-literal.gif
 share/doc/sqlite3/images/syntax/ordering-term.gif
@@ -402,6 +407,7 @@ share/doc/sqlite3/images/syntax/pragma-stmt.gif
 share/doc/sqlite3/images/syntax/pragma-value.gif
 share/doc/sqlite3/images/syntax/qualified-table-name.gif
 share/doc/sqlite3/images/syntax/raise-function.gif
+share/doc/sqlite3/images/syntax/recursive-cte.gif
 share/doc/sqlite3/images/syntax/reindex-stmt.gif
 share/doc/sqlite3/images/syntax/release-stmt.gif
 share/doc/sqlite3/images/syntax/result-column.gif
@@ -410,14 +416,16 @@ share/doc/sqlite3/images/syntax/savepoint-stmt.gif
 share/doc/sqlite3/images/syntax/select-core.gif
 share/doc/sqlite3/images/syntax/select-stmt.gif
 share/doc/sqlite3/images/syntax/signed-number.gif
-share/doc/sqlite3/images/syntax/single-source.gif
+share/doc/sqlite3/images/syntax/simple-select-stmt.gif
 share/doc/sqlite3/images/syntax/sql-stmt-list.gif
 share/doc/sqlite3/images/syntax/sql-stmt.gif
 share/doc/sqlite3/images/syntax/table-constraint.gif
+share/doc/sqlite3/images/syntax/table-or-subquery.gif
 share/doc/sqlite3/images/syntax/type-name.gif
 share/doc/sqlite3/images/syntax/update-stmt-limited.gif
 share/doc/sqlite3/images/syntax/update-stmt.gif
 share/doc/sqlite3/images/syntax/vacuum-stmt.gif
+share/doc/sqlite3/images/syntax/with-clause.gif
 share/doc/sqlite3/images/table-ex1b2.gif
 share/doc/sqlite3/images/vfs1.gif
 share/doc/sqlite3/index.html
@@ -458,6 +466,7 @@ share/doc/sqlite3/lang_select.html
 share/doc/sqlite3/lang_transaction.html
 share/doc/sqlite3/lang_update.html
 share/doc/sqlite3/lang_vacuum.html
+share/doc/sqlite3/lang_with.html
 share/doc/sqlite3/limits.html
 share/doc/sqlite3/loadext.html
 share/doc/sqlite3/lockingv3.html
@@ -600,6 +609,7 @@ share/doc/sqlite3/releaselog/3_8_0_1.html
 share/doc/sqlite3/releaselog/3_8_0_2.html
 share/doc/sqlite3/releaselog/3_8_1.html
 share/doc/sqlite3/releaselog/3_8_2.html
+share/doc/sqlite3/releaselog/3_8_3.html
 share/doc/sqlite3/releaselog/current.html
 share/doc/sqlite3/requirements.html
 share/doc/sqlite3/robots.txt
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 17135266221..b3aacb4455d 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.22 2013/12/06 19:26:58 adam Exp $
+$NetBSD: distinfo,v 1.23 2014/02/04 13:28:07 adam Exp $
 
-SHA1 (sqlite-doc-3080200.zip) = b9cbd42d08b8c1ce96656a6b111e918bb515b605
-RMD160 (sqlite-doc-3080200.zip) = abafc074162b47c0615e38d03c0758a4f03d45b5
-Size (sqlite-doc-3080200.zip) = 4272848 bytes
+SHA1 (sqlite-doc-3080300.zip) = 199c977b948d3e6b9b0b165cb661275e0856d38e
+RMD160 (sqlite-doc-3080300.zip) = f8eab1b04763061a01159984d2be9e8cc26c8f6f
+Size (sqlite-doc-3080300.zip) = 4600279 bytes
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	= .
diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile
index fcea1cfe0c1..29c7cde6ed8 100644
--- a/databases/sqlite3/Makefile
+++ b/databases/sqlite3/Makefile
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile,v 1.71 2013/12/06 19:26:58 adam Exp $
+# $NetBSD: Makefile,v 1.72 2014/02/04 13:28:07 adam Exp $
 
-DISTNAME=	sqlite-autoconf-3080200
-PKGNAME=	sqlite3-3.8.2
+DISTNAME=	sqlite-autoconf-3080300
+PKGNAME=	sqlite3-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/
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index 3e3b339c56f..887bc166a60 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.82 2013/12/06 19:26:58 adam Exp $
+$NetBSD: distinfo,v 1.83 2014/02/04 13:28:07 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 (sqlite-autoconf-3080300.tar.gz) = c2a21d71d0c7dc3af71cf90f04dfd22ecfb280c2
+RMD160 (sqlite-autoconf-3080300.tar.gz) = a797629a2722c6b1df4d6ee4bc97ef60258fbbb1
+Size (sqlite-autoconf-3080300.tar.gz) = 1923594 bytes