diff options
| author | Alexander Nozdrin <alik@sun.com> | 2010-02-20 13:07:32 +0300 |
|---|---|---|
| committer | Alexander Nozdrin <alik@sun.com> | 2010-02-20 13:07:32 +0300 |
| commit | d1ad316a59b6bd48dec94433ffe982ddfc376e35 (patch) | |
| tree | c7e57caf2dddf80f1b45617e4a1bac400e4e880a /mysql-test/r/key.result | |
| parent | f027e4e00f0c4ecef89b635ae2ab1e48eb076bff (diff) | |
| download | mariadb-git-d1ad316a59b6bd48dec94433ffe982ddfc376e35.tar.gz | |
Patch for WL#3736: Extended Table, Column and Index Comments.
The task is to
(a) add a comment on indexes and
(b) increase the maximum length of column, table and the new index comments.
The patch committed on behalf of Yoshinori Matsunobu (Yoshinori.Matsunobu@Sun.COM).
Diffstat (limited to 'mysql-test/r/key.result')
| -rw-r--r-- | mysql-test/r/key.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/key.result b/mysql-test/r/key.result index 21fcfceff81..e63afeab126 100644 --- a/mysql-test/r/key.result +++ b/mysql-test/r/key.result @@ -148,12 +148,12 @@ a 2 drop table t1; create table t1 (a int not null unique, b int unique, c int, d int not null primary key, key(c), e int not null unique); show keys from t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment -t1 0 PRIMARY 1 d A 0 NULL NULL BTREE -t1 0 a 1 a A 0 NULL NULL BTREE -t1 0 e 1 e A 0 NULL NULL BTREE -t1 0 b 1 b A NULL NULL NULL YES BTREE -t1 1 c 1 c A NULL NULL NULL YES BTREE +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment +t1 0 PRIMARY 1 d A 0 NULL NULL BTREE +t1 0 a 1 a A 0 NULL NULL BTREE +t1 0 e 1 e A 0 NULL NULL BTREE +t1 0 b 1 b A NULL NULL NULL YES BTREE +t1 1 c 1 c A NULL NULL NULL YES BTREE drop table t1; CREATE TABLE t1 (c CHAR(10) NOT NULL,i INT NOT NULL AUTO_INCREMENT, UNIQUE (c,i)); |