diff options
| author | drh <drh@noemail.net> | 2017-10-15 22:16:25 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2017-10-15 22:16:25 +0000 |
| commit | 47b1d68f25f2c921497c6a642a111d2d8e7d00cc (patch) | |
| tree | f6c40a613ce6f043a9de51767011c5a84a6c6f1c /test/analyze9.test | |
| parent | 835cd436e1e0a964d84034a88303a1b4c0e8083c (diff) | |
| download | sqlite-47b1d68f25f2c921497c6a642a111d2d8e7d00cc.tar.gz sqlite-47b1d68f25f2c921497c6a642a111d2d8e7d00cc.zip | |
In the query planner, do not consider index X to be a proper subset of
index Y if X is a covering index but Y is not.
FossilOrigin-Name: ee31c04353cd75ea4bbadee2994c30d3808b696a4f680187502d104902988a5d
Diffstat (limited to 'test/analyze9.test')
| -rw-r--r-- | test/analyze9.test | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/test/analyze9.test b/test/analyze9.test index 918577bd1..7c69806f8 100644 --- a/test/analyze9.test +++ b/test/analyze9.test @@ -1052,8 +1052,11 @@ do_execsql_test 23.0 { do_eqp_test 23.1 { SELECT * FROM t4 WHERE (e=1 AND b='xyz' AND c='zyx' AND a<'AEA') AND f<300 + -- Formerly used index i41. But i41 is not a covering index whereas + -- the PRIMARY KEY is a covering index, and so as of 2017-10-15, the + -- PRIMARY KEY is preferred. } { - 0 0 0 {SEARCH TABLE t4 USING INDEX i41 (e=? AND c=? AND b=? AND a<?)} + 0 0 0 {SEARCH TABLE t4 USING PRIMARY KEY (c=? AND b=? AND a<?)} } do_eqp_test 23.2 { SELECT * FROM t4 WHERE |