CREATE TABLE t1 (a int default 'aoeu'); succeeds

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

Bug Description

drizzle> create table t2 (a int default 'aoeu' );
Query OK, 0 rows affected (0.001048 sec)

drizzle> show create table t2;
+-------+----------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------+
| t2 | CREATE TABLE `t2` (
  `a` INT DEFAULT 'aoeu'
) ENGINE=InnoDB COLLATE = utf8_general_ci |
+-------+----------------------------------------------------------------------------------------+
1 row in set (0.000502 sec)

drizzle> insert into t2 values ();
Query OK, 1 row affected (0.000836 sec)

drizzle> select * from t2;
+------+
| a |
+------+
| 0 |
+------+
1 row in set (0.000543 sec)

Related branches

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.