Discussion:
[Liquibase-user] New Topic: createProcedure and MySQL
Liquibase Community Forum
2010-11-16 16:34:19 UTC
Permalink
A new topic, 'createProcedure and MySQL', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=787.new#new

The text of the topic is shown below:

I haven't run this yet because I'm a little leery of it. :-)

A standard MySQL idiom when defining stored procedures is to set the delimiter to something like | (pipe character), so that semicolons inside the body of the statement are not interpreted by MySQL as the end of the procedure definition.

I see that <createProcedure> is really just a <sql> refactoring with some defaults, but it doesn't appear to have any ability to set the delimiter at the end.

For MySQL, am I best off, then, using <sql> with splitStatements set to false and endDelimiter set to, say, the pipe character?

Best,
Laird

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The Liquibase Community Forum Team.

Loading...