linux-traipu team mailing list archive

[Stewart Smith <stewart@xxxxxxxxxxxxxxxx>]

** Changed in: drizzle
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/802248

Title:
  show create table is returning invalid create table statement

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  Fix Released

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?

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/802248/+subscriptions