diff options
| author | Alexander Barkov <bar@mariadb.com> | 2019-10-01 09:37:40 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2019-10-01 09:37:40 +0400 |
| commit | 7e44c455f4de82081af5089e1f77378676aa45ff (patch) | |
| tree | 380cccc03bda084e6a8e38fd7ff6b4304ca8324a /mysql-test/main/myisam.result | |
| parent | 6c2724fc05d12904f8c2f58f8dbadd9523d18c96 (diff) | |
| parent | f203245e9edcfb202c1b23fba186be043ce6002d (diff) | |
| download | mariadb-git-7e44c455f4de82081af5089e1f77378676aa45ff.tar.gz | |
Merge remote-tracking branch 'origin/10.2' into 10.3
Diffstat (limited to 'mysql-test/main/myisam.result')
| -rw-r--r-- | mysql-test/main/myisam.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/main/myisam.result b/mysql-test/main/myisam.result index 4864ef0bb13..cf27974a53a 100644 --- a/mysql-test/main/myisam.result +++ b/mysql-test/main/myisam.result @@ -2670,3 +2670,26 @@ myisam_block_size 1024 select @@global.myisam_block_size; @@global.myisam_block_size 1024 +# +# MDEV-20704 An index on a double column erroneously uses prefix compression +# +CREATE TABLE t1 ( +id INT NOT NULL PRIMARY KEY, +d DOUBLE, +KEY (d) +) ENGINE=MyISAM; + +MyISAM file: MYSQLD_DATADIR/test/t1 +Record format: Fixed length +Character set: latin1_swedish_ci (8) +Data records: 0 Deleted blocks: 0 +Recordlength: 13 + +table description: +Key Start Len Index Type +1 2 4 unique long +2 6 8 multip. double NULL +DROP TABLE t1; +# +# End of 5.5 tests +# |