MySQL statement not recognized due to multiple comment directives on a single line

[kongslund]

Using Flyway version 2.2 I discovered an issue with merging an initial MySQL dump of an existing database schema.

Flyway does not recognize the following as a statement:

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER EntityBeforeInsert BEFORE INSERT 
ON Entity FOR EACH ROW 
BEGIN
    ...
END */;;

If I separate the comment directives by a newline such as in the following example then Flyway recognizes the statement:

/*!50003 CREATE*/
/*!50017 DEFINER=`root`@`localhost`*/
/*!50003 TRIGGER EntityBeforeInsert BEFORE INSERT 
ON Entity FOR EACH ROW 
BEGIN
    ...
END */;;

The troublesome SQL snippet was added by the mysqldump tool.

[axelfontaine]

Thanks for reporting this. This is partly due to the parser not being able to deal with multiple statements per line at this point. I plan on revisiting it at some point in the near future to address this.

[axelfontaine]

I will document a limitation and revisit this for 3.1

[axelfontaine]

Limitation is in the docs: http://flywaydb.org/documentation/database/mysql.html

[axelfontaine]

Fixed. At last!