[
http://jira.codehaus.org/browse/MSQL-36?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=207785#action_207785
]
Robert Scholte commented on MSQL-36:
------------------------------------
Seems like it's not really a bug, maybe just a matter of extra documentation.
Main question, do you need to set the delimiter for this case? (the
delimiterType has to be set to DelimiterType.ROW, correct?)
The semicolon is no issue anymore at least since MSQL-47, which contains a test
for this usecase.
> Invalid delimeter when using postgres quotes
> --------------------------------------------
>
> Key: MSQL-36
> URL: http://jira.codehaus.org/browse/MSQL-36
> Project: Maven 2.x SQL Plugin
> Issue Type: Bug
> Affects Versions: 1.2, 1.3, 1.4
> Environment: postgresql (any version)
> sql-maven-plugin 1.2, 1.3
> Reporter: Igor Artamonov
>
> When executing postgres-specific sql like this:
> {quote}
> CREATE OR REPLACE FUNCTION my_trig()
> RETURNS "trigger" AS
> $BODY$
> declare
> t text;
> begin
> -- any plpgsql code here, where each line ends with semicolon
> return NEW;
> end$BODY$
> LANGUAGE 'plpgsql' VOLATILE;
> {quote}
> it will cause an error:
> bq. ERROR: unterminated dollar-quoted string at or near "$BODY$declare t text
> It's because of SqlExecMojo.java which splits sql by ';', but all code
> between the $QUOTE$ and $QUOTE$ need to be parsed as one command at this case.
> As i know postgres jdbc driver already can parse code like this, and maybe
> you can make an investigation into it
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
