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