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/where7.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/where7.test')
| -rw-r--r-- | test/where7.test | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/test/where7.test b/test/where7.test index 00cf5eb27..983418ae2 100644 --- a/test/where7.test +++ b/test/where7.test @@ -23341,8 +23341,8 @@ do_execsql_test where7-3.1 { CREATE INDEX t302_c3 on t302(c3); CREATE INDEX t302_c8_c3 on t302(c8, c3); CREATE INDEX t302_c5 on t302(c5); - - EXPLAIN QUERY PLAN +} +do_eqp_test where7-3.2 { SELECT t302.c1 FROM t302 JOIN t301 ON t302.c8 = +t301.c8 WHERE t302.c2 = 19571 @@ -23351,10 +23351,11 @@ do_execsql_test where7-3.1 { OR t301.c8 = 1407424651264000) ORDER BY t302.c5 LIMIT 200; } { - 0 0 1 {SEARCH TABLE t301 USING COVERING INDEX t301_c4 (c4=?)} - 0 0 1 {SEARCH TABLE t301 USING INTEGER PRIMARY KEY (rowid=?)} - 0 1 0 {SEARCH TABLE t302 USING INDEX t302_c8_c3 (c8=? AND c3>?)} - 0 0 0 {USE TEMP B-TREE FOR ORDER BY} + QUERY PLAN + |--SEARCH TABLE t301 USING COVERING INDEX t301_c4 (c4=?) + |--SEARCH TABLE t301 USING INTEGER PRIMARY KEY (rowid=?) + |--SEARCH TABLE t302 USING INDEX t302_c8_c3 (c8=? AND c3>?) + `--USE TEMP B-TREE FOR ORDER BY } finish_test |