diff options
Diffstat (limited to 'mysql-test/main/range.test')
| -rw-r--r-- | mysql-test/main/range.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/range.test b/mysql-test/main/range.test index bd2299bac5f..d4485292dc7 100644 --- a/mysql-test/main/range.test +++ b/mysql-test/main/range.test @@ -2051,5 +2051,25 @@ set eq_range_index_dive_limit=default; drop table t1; --echo # +--echo # MDEV-18551: New defaults for eq_range_index_dive_limit +--echo # + +create table ten(a int); +insert into ten values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); +create table t1(a int, key(a)); +insert into t1 select A.a + B.a*10 + C.a*100 from ten A, ten B,ten C; +insert into t1 select 1 from ten A, ten B,ten C; + +create table t2(a int, key(a)); +insert into t2 select A.a + B.a*10 + C.a*100 from ten A, ten B,ten C where A.a + B.a*10 + C.a*100 < 199; + +let $a= `select group_concat(a) from t2`; +eval analyze SELECT * FROM t1 where a in ($a); +insert into t2 values (200),(201); +let $a= `select group_concat(a) from t2`; +eval analyze SELECT * FROM t1 where a in ($a); +drop table t1,ten,t2; + +--echo # --echo # End of 10.2 tests --echo # |