Comment 1 for bug 771572

Revision history for this message
Joe Daly (skinny.moey) wrote :

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