Dies on multiple SQL expressions about migratus

[pjstadig]

Unfortunately, this is a known issue. The JDBC API allows you to add multiple SQL statements to a batch to execute, but you must do so explicitly and discretely. It does not allow you to pass a single string with multiple SQL statements for batch execution.

I'm in a position where I must either parse the SQL myself so that I can break up a file into multiple SQL statements, or I may have to introduce some special syntax (i.e. "--;;") that migratus can use to split statements apart. I'm not really thrilled with either option. In fact parsing the SQL may be a non-starter given the differences between DBs.

I welcome any feedback about this situation. I'm still mulling over the best way to try to solve this.

I think in your particular case you could probably create an index for the table within the CREATE TABLE statement, which would avoid the issue.

[gf3]

What a fun and seemingly arbitrary limitation. Thanks for the quick reply and insight.

[pjstadig]

I've implemented multiple statements separated by '--;;\n'. See pull request 9.

Any comments?

/cc @ejackson

[scgilardi]

looks like the code allows --;;.*\n which I think is preferable.