Handling MemSQL stored procedures using liquibase mvn plugin

I have a stored procedures for MemSQL which require the the usage of keyword ‘DELIMITER’ in my sql file. Code snippet is as below.  

DELIMITER /
Any recommendations on how this can be fixed?

DELIMITER ;

Steve,

I tried changing the delimiter in the changelog and removing the last ‘DELIMITER ;’ in my sql file. It still fails with the same error.

To add, in my pom, i have two executions, one with goal of ‘updateSQL’, to generate a DDL SQL file, and one with goal of ‘update’. The SQL file generated by the ‘updateSQL’ goal works file when executed through the database command line utility.

What does your changelog look like? 

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/

OK - I think if you change the sqlFile endDelimiter attribute to slash rather than semicolon you should be good to go. You may also need to remove the final DELIMTER ; line from the stored-procedures.sql

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/