diff options
Diffstat (limited to 'mysql-test/main/type_varchar.result')
-rw-r--r-- | mysql-test/main/type_varchar.result | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/main/type_varchar.result b/mysql-test/main/type_varchar.result index 8911d36a020..214fb0a5b0f 100644 --- a/mysql-test/main/type_varchar.result +++ b/mysql-test/main/type_varchar.result @@ -723,3 +723,32 @@ SET sql_mode=DEFAULT; # # End of 10.4 tests # +# +# Start of 10.5 tests +# +# +# MDEV-15592 Column COMPRESSED should select a 'high order' datatype +# +TRUNCATE TABLE vchar; +SHOW CREATE TABLE vchar; +Table Create Table +vchar CREATE TABLE `vchar` ( + `v` varchar(30)/*old*/ DEFAULT NULL, + `c` char(3) DEFAULT NULL, + `e` enum('abc','def','ghi') DEFAULT NULL, + `t` text DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +ALTER TABLE vchar ADD FULLTEXT INDEX(v); +SHOW CREATE TABLE vchar; +Table Create Table +vchar CREATE TABLE `vchar` ( + `v` varchar(30) DEFAULT NULL, + `c` char(3) DEFAULT NULL, + `e` enum('abc','def','ghi') DEFAULT NULL, + `t` text DEFAULT NULL, + FULLTEXT KEY `v` (`v`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE vchar; +# +# End of 10.5 tests +# |