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
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