<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
