Comment of table with partitions is displayed incorrectly

[expired user #8709]'s profile image [expired user #8709] posted 9 years ago in General Permalink
Hi,

The comment of a table with partitions is not displayed corretly in the comment input field and the "CREATE code" tab.
The create code in the result of "show create table ..." contains the corret comment.

Example:

Create code of "show create table ...":
CREATE TABLE `my_table` (
`my_key` char(1) NOT NULL,
PRIMARY KEY (`my_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Test'
/*!50500 PARTITION BY LIST  COLUMNS(my_key)
(PARTITION partition1 VALUES IN ('') ENGINE = InnoDB) */


Create code shown in HeidiSQL 9.1.0.4867:
CREATE TABLE `my_table` (
`my_key` CHAR(1) NOT NULL,
PRIMARY KEY (`my_key`)
)
COMMENT='Test\'\r\n/*!50500 PARTITION BY LIST  COLUMNS(my_key)\r\n(PARTITION partition1 VALUES IN ('
COLLATE='latin1_swedish_ci'
/*!50100 PARTITION BY LIST  COLUMNS(my_key)
(PARTITION partition1 VALUES IN ('') ENGINE = InnoDB)  */;


Text displayed in the comment input field:
Test'
/*!50500 PARTITION BY LIST  COLUMNS(my_key)
(PARTITION partition1 VALUES IN (

Please login to leave a reply, or register at first.