Changes 3.9.2:

* Fix the schema parser so that it interprets certain (obscure and ill-formed) CREATE TABLE statements the same as legacy.
* Fix a query planner problem that could result in an incorrect answer due to the use of automatic indexing in subqueries in the FROM clause of a correlated scalar subqueries.

5 files changed, 20 insertions, 22 deletions

diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 3f816670b0f..6eb17ad3637 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.46 2015/10/17 07:36:50 adam Exp $
+@comment $NetBSD: PLIST,v 1.47 2015/11/04 06:32:25 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -665,6 +665,7 @@ share/doc/sqlite3/releaselog/3_8_8_3.html
 share/doc/sqlite3/releaselog/3_8_9.html
 share/doc/sqlite3/releaselog/3_9_0.html
 share/doc/sqlite3/releaselog/3_9_1.html
+share/doc/sqlite3/releaselog/3_9_2.html
 share/doc/sqlite3/releaselog/current.html
 share/doc/sqlite3/requirements.html
 share/doc/sqlite3/rescode.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index 9fbd12947b5..501228a16b0 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,7 +1,6 @@
-$NetBSD: distinfo,v 1.47 2015/11/03 01:56:35 agc Exp $
+$NetBSD: distinfo,v 1.48 2015/11/04 06:32:25 adam Exp $
 
-SHA1 (sqlite-doc-3090100.zip) = 4546fc4304427621c49b99f71fc938890f1e7a72
-RMD160 (sqlite-doc-3090100.zip) = 194e761c1566fcfcbd2e94957e948d195d463145
-SHA512 (sqlite-doc-3090100.zip) = f6d8248a6740b50a5c3cb5ab34bd3011adcec882066c203afd3da906e162a44019af4ffe485651e3ef6679610480f78e566bde46dbf2f15bf9577fcdfeec65f2
-SHA512 (sqlite-doc-3090100.zip) = f6d8248a6740b50a5c3cb5ab34bd3011adcec882066c203afd3da906e162a44019af4ffe485651e3ef6679610480f78e566bde46dbf2f15bf9577fcdfeec65f2
-Size (sqlite-doc-3090100.zip) = 5289099 bytes
+SHA1 (sqlite-doc-3090200.zip) = 31a2e8a845e24968ede785ec09e057514c3538fd
+RMD160 (sqlite-doc-3090200.zip) = c88bf1d9787fb32beabe98b7a171799e9221a50c
+SHA512 (sqlite-doc-3090200.zip) = aef3b340613eed376dca491fd25b98ced30b69454b24412cb094854c53496bddfb479293634b46f1c793377981d4094c38a6b9c3e67775b471407c4d8cc21435
+Size (sqlite-doc-3090200.zip) = 5295693 bytes
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 8333f83667c..5b7a3c6e6a9 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,8 +1,7 @@
-$NetBSD: distinfo,v 1.60 2015/11/03 01:56:35 agc Exp $
+$NetBSD: distinfo,v 1.61 2015/11/04 06:32:25 adam Exp $
 
-SHA1 (sqlite-autoconf-3090100.tar.gz) = 6b7d22c24c9695118a2706c8e026fb3c31780a30
-RMD160 (sqlite-autoconf-3090100.tar.gz) = f848ac3ce9f5264310697c73d72a2f4ae770be07
-SHA512 (sqlite-autoconf-3090100.tar.gz) = 6465c22afa68a44b7a6e739d242d2c921147fba11c92bb3a7d0bc5b6a58bd3f85d42a1e2710f60c18c5d82e4fc6f5651255f3aebd684e0fdc69dd099337182cb
-SHA512 (sqlite-autoconf-3090100.tar.gz) = 6465c22afa68a44b7a6e739d242d2c921147fba11c92bb3a7d0bc5b6a58bd3f85d42a1e2710f60c18c5d82e4fc6f5651255f3aebd684e0fdc69dd099337182cb
-Size (sqlite-autoconf-3090100.tar.gz) = 2284128 bytes
+SHA1 (sqlite-autoconf-3090200.tar.gz) = dae1ae5297fece9671ae0c434a7ecd0cda09c76a
+RMD160 (sqlite-autoconf-3090200.tar.gz) = 6dd6e0779b1cea20141ed4659311461e125b73bf
+SHA512 (sqlite-autoconf-3090200.tar.gz) = c4fdd7dee58e2e4c83091f2a98d8099c6403a66f566be46b54d465c5a58404555fdc1d08050ca60edb6366d220407cfc7409921c123915f78a04cd9930217fa7
+Size (sqlite-autoconf-3090200.tar.gz) = 2284431 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d
diff --git a/databases/sqlite3/Makefile.version b/databases/sqlite3/Makefile.version
index 81c30c02035..50adc63e8e7 100644
--- a/databases/sqlite3/Makefile.version
+++ b/databases/sqlite3/Makefile.version
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile.version,v 1.8 2015/10/17 07:36:50 adam Exp $
+# $NetBSD: Makefile.version,v 1.9 2015/11/04 06:32:25 adam Exp $
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 
-SQLITE3_DISTVERSION=	3090100
-SQLITE3_VERSION=	3.9.1
+SQLITE3_DISTVERSION=	3090200
+SQLITE3_VERSION=	3.9.2
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index eedbeda0ffd..c4019cf9c61 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,8 +1,7 @@
-$NetBSD: distinfo,v 1.111 2015/11/03 01:56:35 agc Exp $
+$NetBSD: distinfo,v 1.112 2015/11/04 06:32:25 adam Exp $
 
-SHA1 (sqlite-autoconf-3090100.tar.gz) = 6b7d22c24c9695118a2706c8e026fb3c31780a30
-RMD160 (sqlite-autoconf-3090100.tar.gz) = f848ac3ce9f5264310697c73d72a2f4ae770be07
-SHA512 (sqlite-autoconf-3090100.tar.gz) = 6465c22afa68a44b7a6e739d242d2c921147fba11c92bb3a7d0bc5b6a58bd3f85d42a1e2710f60c18c5d82e4fc6f5651255f3aebd684e0fdc69dd099337182cb
-SHA512 (sqlite-autoconf-3090100.tar.gz) = 6465c22afa68a44b7a6e739d242d2c921147fba11c92bb3a7d0bc5b6a58bd3f85d42a1e2710f60c18c5d82e4fc6f5651255f3aebd684e0fdc69dd099337182cb
-Size (sqlite-autoconf-3090100.tar.gz) = 2284128 bytes
+SHA1 (sqlite-autoconf-3090200.tar.gz) = dae1ae5297fece9671ae0c434a7ecd0cda09c76a
+RMD160 (sqlite-autoconf-3090200.tar.gz) = 6dd6e0779b1cea20141ed4659311461e125b73bf
+SHA512 (sqlite-autoconf-3090200.tar.gz) = c4fdd7dee58e2e4c83091f2a98d8099c6403a66f566be46b54d465c5a58404555fdc1d08050ca60edb6366d220407cfc7409921c123915f78a04cd9930217fa7
+Size (sqlite-autoconf-3090200.tar.gz) = 2284431 bytes
 SHA1 (patch-configure) = 1b9379f8f995456e9e39416123e08c0b4aa6d9b5