empty table comment should be stored in table proto as not having a comment

Bug #611023 reported by Stewart Smith
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
Low
Stewart Smith

Bug Description

(when using statement_transform for show create table)

drizzle> create table t1 (a int) comment='ass';
Query OK, 0 rows affected (5.9 sec)

drizzle> alter table t1 comment='';
Query OK, 0 rows affected (9.6 sec)
Records: 0 Duplicates: 0 Warnings: 0

drizzle> show create table t1;
+-------+-------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-------------------------------------------------------------------------------------------------+
| t1 | CREATE TABLE `t1` (
  `a` int DEFAULT NULL
) ENGINE=InnoDB COMMENT='' COLLATE = utf8_general_ci |
+-------+-------------------------------------------------------------------------------------------------+
1 row in set (0 sec)

But *should* be instead

drizzle> show create table t1;
+-------+-------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-------------------------------------------------------------------------------------------------+
| t1 | CREATE TABLE `t1` (
  `a` int DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci |
+-------+-------------------------------------------------------------------------------------------------+
1 row in set (0 sec)

Related branches

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.