Add test cases for ticket [89398880bcfff9].
FossilOrigin-Name: 9683e001ed38b41979220eef0bdfcb54df5f3191
diff --git a/manifest b/manifest
index 87ce18b..b1705d3 100644
--- a/manifest
+++ b/manifest
@@ -1,5 +1,5 @@
-C Add\sthe\s"showauth"\sextension\sin\sext/misc.
-D 2014-09-21T17:51:37.899
+C Add\stest\scases\sfor\sticket\s[89398880bcfff9].
+D 2014-09-21T20:31:26.194
F Makefile.arm-wince-mingw32ce-gcc d6df77f1f48d690bd73162294bbba7f59507c72f
F Makefile.in cf57f673d77606ab0f2d9627ca52a9ba1464146a
F Makefile.linux-gcc 91d710bdc4998cb015f39edf3cb314ec4f4d7e23
@@ -862,7 +862,7 @@
F test/stat.test 76fd746b85459e812a0193410fb599f0531f22de
F test/stmt.test 25d64e3dbf9a3ce89558667d7f39d966fe2a71b9
F test/subquery.test 666fdecceac258f5fd84bed09a64e49d9f37edd9
-F test/subquery2.test 91e1e364072aeff431d1f9689b15147e421d88c7
+F test/subquery2.test 438f8a7da1457277b22e4176510f7659b286995f
F test/subselect.test d24fd8757daf97dafd2e889c73ea4c4272dcf4e4
F test/substr.test 18f57c4ca8a598805c4d64e304c418734d843c1a
F test/superlock.test 1cde669f68d2dd37d6c9bd35eee1d95491ae3fc2
@@ -1199,7 +1199,7 @@
F tool/warnings-clang.sh f6aa929dc20ef1f856af04a730772f59283631d4
F tool/warnings.sh 0abfd78ceb09b7f7c27c688c8e3fe93268a13b32
F tool/win/sqlite.vsix deb315d026cc8400325c5863eef847784a219a2f
-P c0b61f7092a7fd2c5f51db26ce7a7a5c75c227fe
-R 90118272bfe5d13644b89a2578b8154b
+P 28d52c1c38d849f099bc777f5987d1ef89680c2a
+R df45958fe8f93552efb788581c98f0f7
U drh
-Z 3c4b3bea487974dee315367e89ebebc8
+Z e77b30925e1036bea887cc5097672af2
diff --git a/manifest.uuid b/manifest.uuid
index 4be4543..f4ca445 100644
--- a/manifest.uuid
+++ b/manifest.uuid
@@ -1 +1 @@
-28d52c1c38d849f099bc777f5987d1ef89680c2a
\ No newline at end of file
+9683e001ed38b41979220eef0bdfcb54df5f3191
\ No newline at end of file
diff --git a/test/subquery2.test b/test/subquery2.test
index 4406efc..de637d5 100644
--- a/test/subquery2.test
+++ b/test/subquery2.test
@@ -103,5 +103,50 @@
LIMIT (SELECT a FROM t5)
} {2 3 3 6 4 10}
+############################################################################
+# Ticket http://www.sqlite.org/src/info/d11a6e908f (2014-09-20)
+# Query planner fault on three-way nested join with compound inner SELECT
+#
+do_execsql_test 3.0 {
+ DROP TABLE IF EXISTS t1;
+ DROP TABLE IF EXISTS t2;
+ CREATE TABLE t1 (id INTEGER PRIMARY KEY, data TEXT);
+ INSERT INTO t1(id,data) VALUES(9,'nine-a');
+ INSERT INTO t1(id,data) VALUES(10,'ten-a');
+ INSERT INTO t1(id,data) VALUES(11,'eleven-a');
+ CREATE TABLE t2 (id INTEGER PRIMARY KEY, data TEXT);
+ INSERT INTO t2(id,data) VALUES(9,'nine-b');
+ INSERT INTO t2(id,data) VALUES(10,'ten-b');
+ INSERT INTO t2(id,data) VALUES(11,'eleven-b');
+
+ SELECT id FROM (
+ SELECT id,data FROM (
+ SELECT * FROM t1 UNION ALL SELECT * FROM t2
+ )
+ WHERE id=10 ORDER BY data
+ );
+} {10 10}
+do_execsql_test 3.1 {
+ SELECT data FROM (
+ SELECT 'dummy', data FROM (
+ SELECT data FROM t1 UNION ALL SELECT data FROM t1
+ ) ORDER BY data
+ );
+} {eleven-a eleven-a nine-a nine-a ten-a ten-a}
+do_execsql_test 3.2 {
+ DROP TABLE IF EXISTS t3;
+ DROP TABLE IF EXISTS t4;
+ CREATE TABLE t3(id INTEGER, data TEXT);
+ CREATE TABLE t4(id INTEGER, data TEXT);
+ INSERT INTO t3 VALUES(4, 'a'),(2,'c');
+ INSERT INTO t4 VALUES(3, 'b'),(1,'d');
+
+ SELECT data, id FROM (
+ SELECT id, data FROM (
+ SELECT * FROM t3 UNION ALL SELECT * FROM t4
+ ) ORDER BY data
+ );
+} {a 4 b 3 c 2 d 1}
+
finish_test