[
http://jira.codehaus.org/browse/MSQL-47?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=207040#action_207040
]
Mark Struberg commented on MSQL-47:
-----------------------------------
sadly it's much more complicated. You may also use " as quotes
My test cases (already working) so far:
{noformat}
containsNot( "" );
containsNot( " " );
containsNot( " \t " );
contains( ";" );
contains( "SELECT * from myTable;" );
contains( "SELECT * from myTable; -- with sl comment" );
contains( "SELECT * from myTable; /* with part comment */" );
contains( "SELECT * from myTable /* with part comment inside*/ ; " );
contains( "INSERT INTO testTable (thevalue) VALUES ('value !'); --
comment at the end" );
// a " inside a ' quoted text
contains( "INSERT INTO testTable (thevalue) VALUES ('value \" !');" );
// a ' inside a " quoted text
contains( "INSERT INTO testTable (thevalue) VALUES (\"value ' !\");" );
containsNot( "SELECT * from myTable where value = ';' AND -- semicolon
is quoted!" );
{noformat}
The problem is that the code also has parsing for "REM" in it which will cause
another roadblocker if some text contains e.g. "REMEMBER" ...
And there is ROW vs NORMAL parsing mode to fumble around with.
> Syntax error if "--" is in escaped strings in sourced sql files
> ---------------------------------------------------------------
>
> Key: MSQL-47
> URL: http://jira.codehaus.org/browse/MSQL-47
> Project: Maven 2.x SQL Plugin
> Issue Type: Bug
> Environment: linux, maven 2.2.1, mysql 5.1.37, java 1.6.0_17
> Reporter: Ronald Steininger
> Assignee: Mark Struberg
> Priority: Minor
> Attachments: sql-maven-plugin-test.tgz
>
>
> see attached maven project.
> I get an syntax error if testcase.sql gets sourced via sql-maven-plugin. Said
> sql script works if sourced via mysql <testcase.sql
--
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
