diff options
Diffstat (limited to 'test/index6.test')
-rw-r--r-- | test/index6.test | 21 |
1 files changed, 15 insertions, 6 deletions
diff --git a/test/index6.test b/test/index6.test index e9ea570b8..d70e86aef 100644 --- a/test/index6.test +++ b/test/index6.test @@ -144,12 +144,21 @@ do_test index6-2.2 { SELECT * FROM t2 WHERE a=5; } } {/.* TABLE t2 USING INDEX t2a1 .*/} -do_test index6-2.3 { - execsql { - EXPLAIN QUERY PLAN - SELECT * FROM t2 WHERE a IS NOT NULL; - } -} {/.* TABLE t2 USING INDEX t2a1 .*/} +ifcapable stat3 { + do_test index6-2.3stat3 { + execsql { + EXPLAIN QUERY PLAN + SELECT * FROM t2 WHERE a IS NOT NULL; + } + } {/.* TABLE t2 USING INDEX t2a1 .*/} +} else { + do_test index6-2.3stat3 { + execsql { + EXPLAIN QUERY PLAN + SELECT * FROM t2 WHERE a IS NOT NULL AND a>0; + } + } {/.* TABLE t2 USING INDEX t2a1 .*/} +} do_test index6-2.4 { execsql { EXPLAIN QUERY PLAN |