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.

3 files changed, 23 insertions, 13 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