Liquibase Community Forum
2010-11-16 16:34:19 UTC
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.
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.