diff options
| author | Jan Mercl <0xjnml@gmail.com> | 2020-08-26 23:31:54 +0200 |
|---|---|---|
| committer | Jan Mercl <0xjnml@gmail.com> | 2020-08-26 23:31:54 +0200 |
| commit | e662a135d139be00d9539517df0976318adbdfa1 (patch) | |
| tree | a3f39f3ad0b653020dbd24f23ca5e32ac86fce3b /testdata/tcl/index7.test | |
| parent | 43c865ce5d35eb463e4a05f65e8e388364480711 (diff) | |
release 1.4.0v1.4.0
Diffstat (limited to 'testdata/tcl/index7.test')
| -rw-r--r-- | testdata/tcl/index7.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/testdata/tcl/index7.test b/testdata/tcl/index7.test index f57792e..084e8c3 100644 --- a/testdata/tcl/index7.test +++ b/testdata/tcl/index7.test @@ -339,5 +339,17 @@ do_execsql_test index7-7.1 { SELECT * FROM t6 WHERE y IS TRUE ORDER BY x; } {1 1} +# 2020-05-27. tag-20200527-1. +# Incomplete stat1 information on a table with few rows should still use the +# index. +reset_db +do_execsql_test index7-8.1 { + CREATE TABLE t1(x INTEGER PRIMARY KEY, y); + CREATE INDEX t1y ON t1(y) WHERE y IS NOT NULL; + INSERT INTO t1(x) VALUES(1),(2); + ANALYZE; + EXPLAIN QUERY PLAN SELECT 1 FROM t1 WHERE y=5; +} {/SEARCH TABLE t1 USING COVERING INDEX t1y/} + finish_test |