diff options
| author | drh <drh@noemail.net> | 2018-05-02 18:00:17 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2018-05-02 18:00:17 +0000 |
| commit | b3f0276b9e4fd6465aaefa6e527d3f7a19a59b8c (patch) | |
| tree | c9f50dc49d86bbddef84d7e52539152f908e1b4c /test/analyzeD.test | |
| parent | 84a01debf9cd527e422d4bc3cbd0149b8a3b9e34 (diff) | |
| download | sqlite-b3f0276b9e4fd6465aaefa6e527d3f7a19a59b8c.tar.gz sqlite-b3f0276b9e4fd6465aaefa6e527d3f7a19a59b8c.zip | |
Fix test cases so that they work with the new EXPLAIN QUERY PLAN output
format. Only some of the cases have been fixed. This is an incremental
check-in.
FossilOrigin-Name: 5f0e803e33aa557865d5fc830d9202d628de9a94c9757058ca48f1a560702cd3
Diffstat (limited to 'test/analyzeD.test')
| -rw-r--r-- | test/analyzeD.test | 16 |
1 files changed, 4 insertions, 12 deletions
diff --git a/test/analyzeD.test b/test/analyzeD.test index 4588aaeeb..9c7ed7586 100644 --- a/test/analyzeD.test +++ b/test/analyzeD.test @@ -63,9 +63,7 @@ do_test 1.1 { # do_eqp_test 1.2 { SELECT * FROM t1 WHERE a=3001 AND c=150; -} { - 0 0 0 {SEARCH TABLE t1 USING INDEX t1_c (c=?)} -} +} {SEARCH TABLE t1 USING INDEX t1_c (c=?)} do_test 1.3 { execsql { DELETE FROM sqlite_stat1 } @@ -80,9 +78,7 @@ do_test 1.3 { # do_eqp_test 1.4 { SELECT * FROM t1 WHERE a=3001 AND c=150; -} { - 0 0 0 {SEARCH TABLE t1 USING INDEX t1_ab (a=?)} -} +} {SEARCH TABLE t1 USING INDEX t1_ab (a=?)} do_test 1.5 { execsql { @@ -93,9 +89,7 @@ do_test 1.5 { do_eqp_test 1.6 { SELECT * FROM t1 WHERE a=13 AND c=150; -} { - 0 0 0 {SEARCH TABLE t1 USING INDEX t1_c (c=?)} -} +} {SEARCH TABLE t1 USING INDEX t1_c (c=?)} do_test 1.7 { execsql { DELETE FROM sqlite_stat1 } @@ -108,8 +102,6 @@ do_test 1.7 { # gets this right, even without stat1 data. do_eqp_test 1.8 { SELECT * FROM t1 WHERE a=13 AND c=150; -} { - 0 0 0 {SEARCH TABLE t1 USING INDEX t1_c (c=?)} -} +} {SEARCH TABLE t1 USING INDEX t1_c (c=?)} finish_test |