diff options
Diffstat (limited to 'mysql-test/main/myisam.test')
| -rw-r--r-- | mysql-test/main/myisam.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/myisam.test b/mysql-test/main/myisam.test index f21136d4613..0b153514ecb 100644 --- a/mysql-test/main/myisam.test +++ b/mysql-test/main/myisam.test @@ -1810,3 +1810,22 @@ drop table t1; # show variables like 'myisam_block_size'; select @@global.myisam_block_size; + + +--echo # +--echo # MDEV-20704 An index on a double column erroneously uses prefix compression +--echo # + +CREATE TABLE t1 ( + id INT NOT NULL PRIMARY KEY, + d DOUBLE, + KEY (d) +) ENGINE=MyISAM; +let $MYSQLD_DATADIR= `select @@datadir`; +--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR +--exec $MYISAMCHK -d $MYSQLD_DATADIR/test/t1 +DROP TABLE t1; + +--echo # +--echo # End of 5.5 tests +--echo # |