show create table is returning invalid create table statement
Bug #802248 reported by
Piotr Przybylski
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=
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
lp:~stewart/drizzle/bug802248
- Stewart Smith (community): Approve
- Drizzle Trunk: Pending requested
-
Diff: 43 lines (+23/-0)3 files modifieddrizzled/sql_yacc.yy (+1/-0)
tests/suite/regression/r/802248.result (+13/-0)
tests/suite/regression/t/802248.test (+9/-0)
Changed in drizzle: | |
milestone: | none → 7.2.5 |
importance: | Undecided → Medium |
status: | New → Fix Committed |
Changed in drizzle: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.