Changes 3.7.11:

* Enhance the INSERT syntax to allow multiple rows to be inserted via
  the VALUES clause.
* Enhance the CREATE VIRTUAL TABLE command to support the IF NOT EXISTS clause.
* Added the sqlite3_stricmp() interface as a counterpart to sqlite3_strnicmp().
* Added the sqlite3_db_readonly() interface.
* Added the SQLITE_FCNTL_PRAGMA file control, giving VFS implementations
  the ability to add new PRAGMA statements or to override built-in PRAGMAs.
* Queries of the form: "SELECT max(x), y FROM table" returns the value of y on
  the same row that contains the maximum x value.
* Added support for the FTS4 languageid option.
* Documented support for the FTS4 content option. This feature has actually
  been in the code since version 3.7.9 but is only now considered to be
  officially supported.
* Pending statements no longer block ROLLBACK. Instead, the pending statement
  will return SQLITE_ABORT upon next access after the ROLLBACK.
* Improvements to the handling of CSV inputs in the command-line shell
* Fix a bug introduced in version 3.7.10 that might cause a LEFT JOIN to be
  incorrectly converted into an INNER JOIN if the WHERE clause indexable terms
  connected by OR.

8 files changed, 32 insertions, 28 deletions

diff --git a/databases/sqlite3-docs/Makefile b/databases/sqlite3-docs/Makefile
index a8d8dcf8b79..7f5a0e367c5 100644
--- a/databases/sqlite3-docs/Makefile
+++ b/databases/sqlite3-docs/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.7 2012/01/17 15:53:13 adam Exp $
+# $NetBSD: Makefile,v 1.8 2012/03/20 21:00:47 adam Exp $
 
-DISTNAME=	sqlite-doc-3071000
-PKGNAME=	sqlite3-docs-3.7.10
+DISTNAME=	sqlite-doc-3071100
+PKGNAME=	sqlite3-docs-3.7.11
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/ \
 		http://www.sqlite.org/
diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 3b5e942d248..3b841281da4 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2012/01/17 15:53:13 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2012/03/20 21:00:47 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -29,11 +29,11 @@ share/doc/sqlite3/c3ref/blob_write.html
 share/doc/sqlite3/c3ref/busy_handler.html
 share/doc/sqlite3/c3ref/busy_timeout.html
 share/doc/sqlite3/c3ref/c_abort.html
+share/doc/sqlite3/c3ref/c_abort_rollback.html
 share/doc/sqlite3/c3ref/c_access_exists.html
 share/doc/sqlite3/c3ref/c_alter_table.html
 share/doc/sqlite3/c3ref/c_any.html
 share/doc/sqlite3/c3ref/c_blob.html
-share/doc/sqlite3/c3ref/c_busy_recovery.html
 share/doc/sqlite3/c3ref/c_checkpoint_full.html
 share/doc/sqlite3/c3ref/c_config_getmalloc.html
 share/doc/sqlite3/c3ref/c_dbconfig_enable_fkey.html
@@ -80,6 +80,7 @@ share/doc/sqlite3/c3ref/db_config.html
 share/doc/sqlite3/c3ref/db_filename.html
 share/doc/sqlite3/c3ref/db_handle.html
 share/doc/sqlite3/c3ref/db_mutex.html
+share/doc/sqlite3/c3ref/db_readonly.html
 share/doc/sqlite3/c3ref/db_release_memory.html
 share/doc/sqlite3/c3ref/db_status.html
 share/doc/sqlite3/c3ref/declare_vtab.html
@@ -143,7 +144,7 @@ share/doc/sqlite3/c3ref/stmt.html
 share/doc/sqlite3/c3ref/stmt_busy.html
 share/doc/sqlite3/c3ref/stmt_readonly.html
 share/doc/sqlite3/c3ref/stmt_status.html
-share/doc/sqlite3/c3ref/strnicmp.html
+share/doc/sqlite3/c3ref/stricmp.html
 share/doc/sqlite3/c3ref/table_column_metadata.html
 share/doc/sqlite3/c3ref/temp_directory.html
 share/doc/sqlite3/c3ref/test_control.html
@@ -285,6 +286,8 @@ share/doc/sqlite3/images/foreignlogos/adobe.gif
 share/doc/sqlite3/images/foreignlogos/airbus1.gif
 share/doc/sqlite3/images/foreignlogos/airbus2.gif
 share/doc/sqlite3/images/foreignlogos/apple.gif
+share/doc/sqlite3/images/foreignlogos/bentley.gif
+share/doc/sqlite3/images/foreignlogos/bentley.jpg
 share/doc/sqlite3/images/foreignlogos/bloomberg.gif
 share/doc/sqlite3/images/foreignlogos/dropbox.gif
 share/doc/sqlite3/images/foreignlogos/firefox.gif
@@ -555,6 +558,7 @@ share/doc/sqlite3/releaselog/3_7_0.html
 share/doc/sqlite3/releaselog/3_7_0_1.html
 share/doc/sqlite3/releaselog/3_7_1.html
 share/doc/sqlite3/releaselog/3_7_10.html
+share/doc/sqlite3/releaselog/3_7_11.html
 share/doc/sqlite3/releaselog/3_7_2.html
 share/doc/sqlite3/releaselog/3_7_3.html
 share/doc/sqlite3/releaselog/3_7_4.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 7e2b45d4ee5..d5b9834d6b8 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.7 2012/01/17 15:53:13 adam Exp $
+$NetBSD: distinfo,v 1.8 2012/03/20 21:00:47 adam Exp $
 
-SHA1 (sqlite-doc-3071000.zip) = 9957b9f2e955d82b2484cb44cc6fb4a53313d085
-RMD160 (sqlite-doc-3071000.zip) = 6a75f7c10a8421a99e28c5430ab4f0a0ac09e6d6
-Size (sqlite-doc-3071000.zip) = 3630343 bytes
+SHA1 (sqlite-doc-3071100.zip) = 87cbed1918c2604daefd3588a8555067e55e53cf
+RMD160 (sqlite-doc-3071100.zip) = 388bbcccb69d458f48f044bd65d282d9cf48dbe2
+Size (sqlite-doc-3071100.zip) = 4069512 bytes
diff --git a/databases/sqlite3-tcl/Makefile b/databases/sqlite3-tcl/Makefile
index c0402cf9d4e..50d43a0ab79 100644
--- a/databases/sqlite3-tcl/Makefile
+++ b/databases/sqlite3-tcl/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.30 2012/01/17 15:53:13 adam Exp $
+# $NetBSD: Makefile,v 1.31 2012/03/20 21:00:47 adam Exp $
 
-DISTNAME=	sqlite-autoconf-3071000
-PKGNAME=	sqlite3-tcl-3.7.10
+DISTNAME=	sqlite-autoconf-3071100
+PKGNAME=	sqlite3-tcl-3.7.11
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/ \
 		http://www.sqlite.org/
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index e6d25173f23..a89ead150a9 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.19 2012/01/17 15:53:13 adam Exp $
+$NetBSD: distinfo,v 1.20 2012/03/20 21:00:47 adam Exp $
 
-SHA1 (sqlite-autoconf-3071000.tar.gz) = 0442d5a1bff50153039951b09db649864d8af0bb
-RMD160 (sqlite-autoconf-3071000.tar.gz) = 8932a5cd4b596632c63af30cbd94c2b6c9d45377
-Size (sqlite-autoconf-3071000.tar.gz) = 1801640 bytes
+SHA1 (sqlite-autoconf-3071100.tar.gz) = a768f76b10df84d6a2c66178544d42725a8fdaf0
+RMD160 (sqlite-autoconf-3071100.tar.gz) = 09df3232f4eb7032c0a6081670b2bdcb6d80e865
+Size (sqlite-autoconf-3071100.tar.gz) = 1807754 bytes
 SHA1 (patch-aa) = d4d0424eec39ede995c2c408dcf51876072d3fea
 SHA1 (patch-ab) = 64a4352b9a8ed0518784837e390541cd4e1bc9aa
diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile
index ea3ef21817a..6027ea49168 100644
--- a/databases/sqlite3/Makefile
+++ b/databases/sqlite3/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.48 2012/01/17 15:53:13 adam Exp $
+# $NetBSD: Makefile,v 1.49 2012/03/20 21:00:47 adam Exp $
 
-DISTNAME=	sqlite-autoconf-3071000
-PKGNAME=	sqlite3-3.7.10
+DISTNAME=	sqlite-autoconf-3071100
+PKGNAME=	sqlite3-3.7.11
 CATEGORIES=	databases
 MASTER_SITES=	http://www.hwaci.com/sw/sqlite/ \
 		http://www.sqlite.org/
diff --git a/databases/sqlite3/builtin.mk b/databases/sqlite3/builtin.mk
index 7d9a7b721a1..cfed316fcb0 100644
--- a/databases/sqlite3/builtin.mk
+++ b/databases/sqlite3/builtin.mk
@@ -1,4 +1,4 @@
-# $NetBSD: builtin.mk,v 1.2 2011/11/10 17:18:10 wiz Exp $
+# $NetBSD: builtin.mk,v 1.3 2012/03/20 21:00:47 adam Exp $
 
 BUILTIN_PKG:=	sqlite3
 
@@ -12,12 +12,12 @@ PKGCONFIG_BASE.sqlite3=	/usr
 ### solely to determine whether a built-in implementation exists.
 ###
 
-CHECK_BUILTIN.sqlite3?=      no
+CHECK_BUILTIN.sqlite3?=		no
 .if !empty(CHECK_BUILTIN.sqlite3:M[nN][oO])
 
 .  if !empty(USE_BUILTIN.sqlite3:M[yY][eE][sS])
-BUILDLINK_PREFIX.sqlite3=    /usr
-BUILDLINK_FILES.sqlite3+=    lib/pkgconfig/sqlite3.pc
+BUILDLINK_PREFIX.sqlite3=	/usr
+BUILDLINK_FILES.sqlite3+=	lib/pkgconfig/sqlite3.pc
 .  endif
 
 .endif  # CHECK_BUILTIN.sqlite3
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index cde82776b08..df6ddcad394 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.66 2012/01/17 15:53:13 adam Exp $
+$NetBSD: distinfo,v 1.67 2012/03/20 21:00:47 adam Exp $
 
-SHA1 (sqlite-autoconf-3071000.tar.gz) = 0442d5a1bff50153039951b09db649864d8af0bb
-RMD160 (sqlite-autoconf-3071000.tar.gz) = 8932a5cd4b596632c63af30cbd94c2b6c9d45377
-Size (sqlite-autoconf-3071000.tar.gz) = 1801640 bytes
+SHA1 (sqlite-autoconf-3071100.tar.gz) = a768f76b10df84d6a2c66178544d42725a8fdaf0
+RMD160 (sqlite-autoconf-3071100.tar.gz) = 09df3232f4eb7032c0a6081670b2bdcb6d80e865
+Size (sqlite-autoconf-3071100.tar.gz) = 1807754 bytes