Improvements to the EXPLAIN QUERY PLAN output for EXISTS-to-JOIN.

FossilOrigin-Name: 6b1ecbaa2ee405be040901dceac45d027d35c313622748ba4dbbd404e297a7fa

2 files changed, 3 insertions, 3 deletions

diff --git a/test/eqp.test b/test/eqp.test
index b7e7acd8a..147b5ceaf 100644
--- a/test/eqp.test
+++ b/test/eqp.test
@@ -338,7 +338,7 @@ det 3.3.3 {
 } {
   QUERY PLAN
   |--SCAN t1
-  `--SINGLETON t2
+  `--SCAN t2 EXISTS
 }
 
 #-------------------------------------------------------------------------
diff --git a/test/existsexpr.test b/test/existsexpr.test
index c28955b67..2bf2e8223 100644
--- a/test/existsexpr.test
+++ b/test/existsexpr.test
@@ -94,13 +94,13 @@ do_execsql_test 2.4.0 {
 
 do_eqp_test 2.4.1 {
   SELECT count(*) FROM t1 WHERE EXISTS (SELECT 1 FROM t2 WHERE c=a);
-} {SCAN t1*SINGLETON t2}
+} {SCAN t1*t2 EXISTS}
 do_execsql_test 2.4.2 {
   ANALYZE;
 }
 do_eqp_test 2.4.3 {
   SELECT count(*) FROM t1 WHERE EXISTS (SELECT 1 FROM t2 WHERE c=a);
-} {SCAN t1*SINGLETON t2}
+} {SCAN t1*t2 EXISTS}
 do_execsql_test 2.4.4 {
   SELECT count(*) FROM t1 WHERE EXISTS (SELECT 1 FROM t2 WHERE c=a);
 } {100}