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
• Status: Duplicate
• Category: MySQL Server: Information schema
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[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