part of the problem is in transformCreateSchemaStatementToSql() there are no quotes for DEFINER value. But another problem is that the parser seems to choke on having multiple definitions:
drizzle> CREATE SCHEMA `test6` COLLATE utf8_general_ci DEFINER 'jdaly';
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 'DEFINER 'jdaly'' at line 1
drizzle>
The last statement is a combination of the first two, perhaps Im missing a secret identifier
part of the problem is in transformCreate SchemaStatement ToSql() there are no quotes for DEFINER value. But another problem is that the parser seems to choke on having multiple definitions:
drizzle> CREATE SCHEMA `test4` DEFINER 'jdaly';
Query OK, 1 row affected (0.001228 sec)
drizzle> CREATE SCHEMA `test5` COLLATE utf8_general_ci;
Query OK, 1 row affected (0.001069 sec)
drizzle> CREATE SCHEMA `test6` COLLATE utf8_general_ci DEFINER 'jdaly';
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 'DEFINER 'jdaly'' at line 1
drizzle>
The last statement is a combination of the first two, perhaps Im missing a secret identifier