diff options
| author | Alexander Barkov <bar@mariadb.com> | 2019-06-11 07:54:37 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2019-06-11 07:54:37 +0400 |
| commit | f42bda6d7578297c016279abcc7e177237206724 (patch) | |
| tree | 01db4eed8dfe737a85aa8a0bcecf89e0f09b5579 /mysql-test/main/type_varchar.result | |
| parent | 163665640afb153c173d272eae98b0b63950cd83 (diff) | |
| download | mariadb-git-f42bda6d7578297c016279abcc7e177237206724.tar.gz | |
MDEV-19727 Add Type_handler::Key_part_spec_init_ft
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 +# |