[arquillian-issues] [JBoss JIRA] (ARQ-1352) Script can not insert unix path separator '/' into the DB

[Bartosz Majsak (JIRA)]

     [ https://issues.jboss.org/browse/ARQ-1352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bartosz Majsak resolved ARQ-1352.
---------------------------------

    Resolution: Done


Thank you! Pushed upstream.
                
> Script can not insert unix path separator '/' into the DB
> ---------------------------------------------------------
>
>                 Key: ARQ-1352
>                 URL: https://issues.jboss.org/browse/ARQ-1352
>             Project: Arquillian
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Extension - Persistence
>    Affects Versions: persistence_1.0.0.Alpha6
>            Reporter: Sandor Bodo-Merle
>            Assignee: Sandor Bodo-Merle
>             Fix For: persistence_1.0.0.next
>
>         Attachments: 0001-ScriptExecutor-fix-commit-parsing.patch
>
>
> I have a test class which try to insert a unix path value in the DB on schema creation:
> @CreateSchema({"setup.sql"})                
> public class UserTest {
> ...
> }
> Th the ScriptExecutor introduced in 1.0.0.Alpha6 will iron out the '/' character from the path on insert - like in the following small example:
> public class main {
>      public static void main(String[] args) {
>          final String ANSI_SQL_COMMENTS_PATTERN = "--.*|//.*|(?s)/\\\\*.*?\\\\*/|(?s)\\{.*?\\}";
>          String script = "INSERT INTO config (name, value) VALUES ('path', '/home/sbodo/test.txt');";
>          System.out.println(script.replaceAll(ANSI_SQL_COMMENTS_PATTERN, ""));
>      }
>  }
> Output is:
> INSERT INTO config (name, value) VALUES ('path', 'sbodo/test.txt');
> instead of:
> INSERT INTO config (name, value) VALUES ('path', '/home/sbodo/test.txt');
> Tested with Jboss 7.1.1 and Postgres 9.1.
> The test worked fine in 1.0.0.Alpha5.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira