lp:~stewart/drizzle/bug802248

Branch merges

Propose for merging

No branches dependent on this one.

Merged into lp:drizzle at revision 2627

Stewart Smith (community): Approve on 2013-02-27

Drizzle Trunk: Pending requested 2013-02-26

Diff: 43 lines (+23/-0)

3 files modified

drizzled/sql_yacc.yy (+1/-0)
tests/suite/regression/r/802248.result (+13/-0)
tests/suite/regression/t/802248.test (+9/-0)

api

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Bug #802248: show create table is returning invalid create table statement

Medium

Fix Released

Link a bug report

Related blueprints

2623. By Stewart Smith on 2013-02-26

Fix bug lp:802248: show create table is returning invalid create table statement

It was actually a parser problem, ROW_FORMAT was special (hysterical raisins).
We needed to have the row_format_or_text to actually accept text.

From the bug:

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?

2622. By Drizzle Continuous Integration on 2013-02-22

Merge lp:~mohyt/drizzle/trunk-bug-1116980 Build: jenkins-Drizzle-Builder-165

2621. By Drizzle Continuous Integration on 2013-02-22

Merge lp:~stewart/drizzle/kill-HAS_DOES_TRANSACTIONS Build: jenkins-Drizzle-Builder-164

2620. By Drizzle Continuous Integration on 2013-02-21

Merge lp:~prachee/drizzle/drizzle-dump Build: jenkins-Drizzle-Builder-163

2619. By Drizzle Continuous Integration on 2013-02-20

Merge lp:~stewart/drizzle/cleanups-1 Build: jenkins-Drizzle-Builder-162

2618. By Drizzle Continuous Integration on 2013-01-31

Merge lp:~brianaker/drizzle/fedora18-fix/ Build: jenkins-Drizzle-Builder-160

2617. By Drizzle Continuous Integration on 2013-01-24

Merge lp:~brianaker/drizzle/warning-cleanup Build: jenkins-Drizzle-Builder-155

2616. By Drizzle Continuous Integration on 2013-01-14

Merge lp:~stewart/drizzle/bug1001199 Build: jenkins-Drizzle-Builder-153

2615. By Drizzle Continuous Integration on 2013-01-11

Merge lp:~stewart/drizzle/bug1001199 Build: jenkins-Drizzle-Builder-152

2614. By Drizzle Continuous Integration on 2013-01-08

Merge lp:~brianaker/drizzle/fix-warnings Build: jenkins-Drizzle-Builder-151