diff options
Diffstat (limited to 'test')
-rw-r--r-- | test/eqp.test | 2 | ||||
-rw-r--r-- | test/existsexpr.test | 4 |
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} |