Bug #29365 Wrong content of INFORMATION_SCHEMA.TABLES.TABLE_COMMENT, InnoDB
Submitted: 26 Jun 2007 15:52 Modified: 11 Dec 2007 13:55
Reporter: Matthias Leich Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Sergei Glukhov CPU Architecture:Any
Triage: D4 (Minor)

[26 Jun 2007 15:52] Matthias Leich
Description:
CREATE TABLE t1 (f1 BIGINT) ENGINE = InnoDB COMMENT 'My Table';

SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `f1` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='My Table'

SELECT TABLE_COMMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
TABLE_COMMENT
My Table; InnoDB free: 4096 kB
        XXXXXXXXXXXXXXXXXXXXXX What's this ?
        I expect to see "My Table" like in case of
        other storage engines.

My environment:
- mysql-5.1-rpl last ChangeSet@1.2536, 2007-06-22
- Linux openSUSE 10.2 (X86-64), Core2Duo (x86 64 Bit)
I guess that we have this bug on all OS and most
probably also in MySQL 5.0.

How to repeat:
See above
[11 Dec 2007 13:55] Sergei Glukhov
duplicated with bug#11379