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

[Sandor Bodo-Merle (JIRA)]

Sandor Bodo-Merle created ARQ-1352:
--------------------------------------

             Summary: 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: Bartosz Majsak


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