1 files changed, 17 insertions, 0 deletions
diff --git a/test/existsexpr.test b/test/existsexpr.test
index a5f60b944..81aa5799f 100644
--- a/test/existsexpr.test
+++ b/test/existsexpr.test
@@ -404,6 +404,23 @@ do_catchsql_test 6.1 {
   SELECT a FROM t1 WHERE EXISTS (SELECT 1 FROM t2 WHERE c COLLATE f = a)
 } {1 {no such collation sequence: f}}
 
+#-------------------------------------------------------------------------
+reset_db
+do_execsql_test 7.0 {
+  CREATE TABLE t1(x);
+  CREATE TABLE t2(y UNIQUE);
+
+  INSERT INTO t1 VALUES(1), (2);
+  INSERT INTO t2 VALUES(1), (3);
+
+  SELECT * FROM t1 one LEFT JOIN t1 two ON (one.x=two.x AND EXISTS (
+    SELECT 1 FROM t2 WHERE y=one.x
+  ));
+} {
+  1 1
+  2 {}
+}
+
 
 
 finish_test