diff options
Diffstat (limited to 'mysql-test/main/merge.test')
| -rw-r--r-- | mysql-test/main/merge.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/main/merge.test b/mysql-test/main/merge.test index aef2fa364d6..83173a46a8f 100644 --- a/mysql-test/main/merge.test +++ b/mysql-test/main/merge.test @@ -2897,5 +2897,14 @@ SELECT a, COUNT(*) FROM t1 WHERE a >= '2000-01-01 00:00:00' GROUP BY a; DROP TABLE t1; --echo # +--echo # MDEV-30525: Assertion `ranges > 0' fails in IO_AND_CPU_COST handler::keyread_time +--echo # +CREATE TABLE t1 (a INT, KEY(a)) ENGINE=MyISAM; +CREATE TABLE t2 (a INT, KEY(a)) ENGINE=MyISAM; +CREATE TABLE tm (a INT, KEY(a)) ENGINE=MRG_MyISAM UNION=(t1,t2); +SELECT DISTINCT a FROM tm WHERE a > 50; +DROP TABLE tm, t1, t2; + +--echo # --echo # End of 11.0 tests --echo # |