diff options
| author | Alexander Barkov <bar@mysql.com> | 2009-11-09 15:35:18 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mysql.com> | 2009-11-09 15:35:18 +0400 |
| commit | 725f93fa5500a88d7989f2cfa5467c4e96f142be (patch) | |
| tree | 1eafd8720630b26e3ed22e9d354ca92bf13712a7 /mysql-test/r | |
| parent | f3d89b2a18063e07e3d4190c3340ac91dda933b0 (diff) | |
| download | mariadb-git-725f93fa5500a88d7989f2cfa5467c4e96f142be.tar.gz | |
Bug#26180 Can't add columns to tables created with utf8 (regular) text indexes
Backporting from 6.0.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/ctype_utf8.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_utf8.result b/mysql-test/r/ctype_utf8.result index 4ff48bd380a..668b1b0febe 100644 --- a/mysql-test/r/ctype_utf8.result +++ b/mysql-test/r/ctype_utf8.result @@ -1881,6 +1881,23 @@ CONVERT(a, CHAR) CONVERT(b, CHAR) DROP TABLE t1; End of 5.0 tests Start of 5.4 tests +CREATE TABLE t1 ( +clipid INT NOT NULL, +Tape TINYTEXT, +PRIMARY KEY (clipid), +KEY tape(Tape(255)) +) CHARACTER SET=utf8; +ALTER TABLE t1 ADD mos TINYINT DEFAULT 0 AFTER clipid; +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `clipid` int(11) NOT NULL, + `mos` tinyint(4) DEFAULT '0', + `Tape` tinytext, + PRIMARY KEY (`clipid`), + KEY `tape` (`Tape`(255)) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 +DROP TABLE t1; DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( predicted_order int NOT NULL, |