aboutsummaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
Diffstat (limited to 'test')
-rw-r--r--test/eqp.test2
-rw-r--r--test/existsexpr.test4
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}