1 files changed, 53 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_column_key_length.result b/mysql-test/suite/engines/funcs/r/tc_column_key_length.result
new file mode 100644
index 00000000000..988f05f4596
--- /dev/null
+++ b/mysql-test/suite/engines/funcs/r/tc_column_key_length.result
@@ -0,0 +1,53 @@
+DROP TABLE IF EXISTS t9;
+CREATE TABLE t9(c1 CHAR(10) NOT NULL KEY);
+SHOW TABLES;
+Tables_in_test
+t9
+SHOW CREATE TABLE t9;
+Table	Create Table
+t9	CREATE TABLE `t9` (
+  `c1` char(10) NOT NULL,
+  PRIMARY KEY (`c1`)
+) ENGINE=ENGINE DEFAULT CHARSET=latin1
+DROP TABLE t9;
+SHOW TABLES;
+Tables_in_test
+CREATE TABLE t9(c1 VARCHAR(10) NOT NULL KEY);
+SHOW TABLES;
+Tables_in_test
+t9
+SHOW CREATE TABLE t9;
+Table	Create Table
+t9	CREATE TABLE `t9` (
+  `c1` varchar(10) NOT NULL,
+  PRIMARY KEY (`c1`)
+) ENGINE=ENGINE DEFAULT CHARSET=latin1
+DROP TABLE t9;
+SHOW TABLES;
+Tables_in_test
+CREATE TABLE t9(c1 BINARY(10) NOT NULL KEY);
+SHOW TABLES;
+Tables_in_test
+t9
+SHOW CREATE TABLE t9;
+Table	Create Table
+t9	CREATE TABLE `t9` (
+  `c1` binary(10) NOT NULL,
+  PRIMARY KEY (`c1`)
+) ENGINE=ENGINE DEFAULT CHARSET=latin1
+DROP TABLE t9;
+SHOW TABLES;
+Tables_in_test
+CREATE TABLE t9(c1 VARBINARY(10) NOT NULL KEY);
+SHOW TABLES;
+Tables_in_test
+t9
+SHOW CREATE TABLE t9;
+Table	Create Table
+t9	CREATE TABLE `t9` (
+  `c1` varbinary(10) NOT NULL,
+  PRIMARY KEY (`c1`)
+) ENGINE=ENGINE DEFAULT CHARSET=latin1
+DROP TABLE t9;
+SHOW TABLES;
+Tables_in_test