MDEV-5980: EITS: if condition is used for REF access, its selectivity is still in filtered%

- Testcase. The bug is fixed by commit for MDEV-6003

1 files changed, 17 insertions, 0 deletions

diff --git a/mysql-test/t/selectivity_no_engine.test b/mysql-test/t/selectivity_no_engine.test
index 8f91f5d9261..bf549d7e7b0 100644
--- a/mysql-test/t/selectivity_no_engine.test
+++ b/mysql-test/t/selectivity_no_engine.test
@@ -103,6 +103,23 @@ explain extended select * from t2 where a in (1,2,3) and b in (1,2,3);
 drop table t2, t1;
 
 --echo # 
+--echo # MDEV-5980: EITS: if condition is used for REF access, its selectivity is still in filtered%
+--echo # 
+create table t0(a int);
+insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+create table t1(key1 int, col1 int, key(key1));
+insert into t1 select A.a, A.a from t0 A, t0 B, t0 C;
+
+set histogram_size=100;
+set use_stat_tables='preferably';
+set optimizer_use_condition_selectivity=4;
+analyze table t1 persistent for all;
+--echo # 10% is ok
+explain extended select * from t1 where col1=2;
+--echo # Must show 100%, not 10%
+explain extended select * from t1 where key1=2;
+drop table t0, t1;
+
 --echo # MDEV-6003: EITS: ref access, keypart2=const vs keypart2=expr - inconsistent filtered% value
 --echo # 
 create table t0(a int);