/ Check-in [153c6450]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix a test case related to partial indices so that it works even if STAT3 is disabled.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 153c645025637bbff14dfce793e4b92210ded7e8
User & Date: drh 2013-08-06 19:18:17
Context
2013-08-07
01:18
Fix typos and add clarification to comments in where.c. No code changes. check-in: f8d8790e user: drh tags: trunk
2013-08-06
19:18
Fix a test case related to partial indices so that it works even if STAT3 is disabled. check-in: 153c6450 user: drh tags: trunk
18:35
Adjust #ifdefs in test_autoext.c so that it compiles with SQLITE_OMIT_LOAD_EXTENSION. Fix compiler warnings in two other test modules. No changes to the core. check-in: 89930ea3 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/index6.test.

   140    140   } {800}
   141    141   do_test index6-2.2 {
   142    142     execsql {
   143    143       EXPLAIN QUERY PLAN
   144    144       SELECT * FROM t2 WHERE a=5;
   145    145     }
   146    146   } {/.* TABLE t2 USING INDEX t2a1 .*/}
   147         -do_test index6-2.3 {
   148         -  execsql {
   149         -    EXPLAIN QUERY PLAN
   150         -    SELECT * FROM t2 WHERE a IS NOT NULL;
   151         -  }
   152         -} {/.* TABLE t2 USING INDEX t2a1 .*/}
          147  +ifcapable stat3 {
          148  +  do_test index6-2.3stat3 {
          149  +    execsql {
          150  +      EXPLAIN QUERY PLAN
          151  +      SELECT * FROM t2 WHERE a IS NOT NULL;
          152  +    }
          153  +  } {/.* TABLE t2 USING INDEX t2a1 .*/}
          154  +} else {
          155  +  do_test index6-2.3stat3 {
          156  +    execsql {
          157  +      EXPLAIN QUERY PLAN
          158  +      SELECT * FROM t2 WHERE a IS NOT NULL AND a>0;
          159  +    }
          160  +  } {/.* TABLE t2 USING INDEX t2a1 .*/}
          161  +}
   153    162   do_test index6-2.4 {
   154    163     execsql {
   155    164       EXPLAIN QUERY PLAN
   156    165       SELECT * FROM t2 WHERE a IS NULL;
   157    166     }
   158    167   } {~/.*INDEX t2a1.*/}
   159    168