Comment 1 for bug 685700

Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

That is because FLOAT is an alias for DOUBLE in Drizzle and we have no UNSIGNED. So:

drizzle> create table t4 (a float(5,2));
Query OK, 0 rows affected (0.09 sec)

drizzle> show create table t4\G
*************************** 1. row ***************************
       Table: t4
Create Table: CREATE TABLE `t4` (
  `a` DOUBLE(5,2) DEFAULT NULL
) ENGINE=InnoDB COLLATE = utf8_general_ci
1 row in set (0 sec)

drizzle> create table t5 (a float(5,2) unsigned);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'unsigned)' at line 1