diff options
Diffstat (limited to 'test/subquery.test')
| -rw-r--r-- | test/subquery.test | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/test/subquery.test b/test/subquery.test index f601d3f..93c3f28 100644 --- a/test/subquery.test +++ b/test/subquery.test @@ -241,8 +241,11 @@ do_test subquery-2.5.3.1 { } {10.0} do_test subquery-2.5.3.2 { # Verify that the t4i index was not used in the previous query - set ::sqlite_query_plan -} {t4 {}} + execsql { + EXPLAIN QUERY PLAN + SELECT * FROM t4 WHERE x IN (SELECT a FROM t3); + } +} {~/t4i/} do_test subquery-2.5.4 { execsql { DROP TABLE t3; |