show create table is returning invalid create table statement

Bug #802248 reported by Piotr Przybylski
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
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)
Changed in drizzle:
milestone: none → 7.2.5
importance: Undecided → Medium
status: New → Fix Committed
Stewart Smith (stewart)
Changed in drizzle:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.