show create table is returning invalid create table statement

Bug #802248 reported by Piotr Przybylski on 2011-06-26
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Medium
Unassigned

Bug Description

Execute the following queries:

create table test (a int) engine=innodb row_format=compaCT;
show create table test;

Result:
 CREATE TABLE `test` (
  `a` INT DEFAULT NULL
) ENGINE=InnoDB ROW_FORMAT='compaCT' COLLATE = utf8_general_ci

Row format has single quotes around it, making this query invalid. Besides, shouldn't it return COMPACT instead of using the same mixed case as the original create statement?

Related branches

Stewart Smith (stewart) on 2013-02-26
Changed in drizzle:
milestone: none → 7.2.5
importance: Undecided → Medium
status: New → Fix Committed
Stewart Smith (stewart) on 2013-02-28
Changed in drizzle:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers