[
http://jira.codehaus.org/browse/MSQL-35?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ondrej Zizka closed MSQL-35.
----------------------------
Resolution: Not A Bug
What a shame, I forgot about Maven's escaping of "$"... Closing.
> <delimiter> uses only one character as separator
> ------------------------------------------------
>
> Key: MSQL-35
> URL: http://jira.codehaus.org/browse/MSQL-35
> Project: Maven 2.x SQL Plugin
> Issue Type: Bug
> Affects Versions: 1.3
> Reporter: Ondrej Zizka
>
> When using delimiter longer than one character, e.g. "$$", the first
> character is left in the query.
> Various tools generate SQL scripts delimited by such character sequence.
> ------------------------------------------------------------------------------------
> <configuration>
> <delimiter>$$</delimiter>
> <srcFiles>
> <srcFile>functions-create.sql</srcFile>
> </srcFiles>
> </configuration>
> ------------------------------------------------------------------------------------
> CREATE PROCEDURE `test_proc`() BEGIN
> RETURN;
> END $$
> ------------------------------------------------------------------------------------
> [ERROR]Failed to execute: CREATE FUNCTION
> `isir_sled_AnyUndefinedOrBeginMatch`(sledVal VARCHAR(512), isirVal
> VARCHAR(512)) RETURNS tinyint(1) BEGIN IF sledVal IS NULL OR isirVal IS NULL
> THEN RETURN TRUE; END IF; SET isirVal = REPLACE( isirVal, '"', ''); IF
> REPLACE(isirVal,' ','') LIKE CONCAT( REPLACE(sledVal,' ',''),'%') THEN RETURN
> TRUE; ELSE RETURN FALSE; END IF; END $
> -------------------------------------------------------------------------------------------
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near '$' at line 1
--
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
