[jira] [Created] (DERBY-5170) Client doesn't handle double quotes in savepoint names

[Knut Anders Hatlen (JIRA)]

Client doesn't handle double quotes in savepoint names
------------------------------------------------------

                 Key: DERBY-5170
                 URL: https://issues.apache.org/jira/browse/DERBY-5170
             Project: Derby
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 10.7.1.1
            Reporter: Knut Anders Hatlen
            Assignee: Knut Anders Hatlen


I added the following test case to SavepointJdbc30Test and saw that it failed 
with the client driver:

    public void testQuotes() throws SQLException {
        setAutoCommit(false);
        Statement s = createStatement();
        s.execute("create table test_quotes(x int)");
        s.execute("insert into test_quotes values 1");

        Savepoint sp = getConnection().setSavepoint("a \" b ' c");

        s.execute("insert into test_quotes values 2");

        getConnection().rollback(sp);

        JDBC.assertSingleValueResultSet(
                s.executeQuery("select * from test_quotes"),
                "1");
    }

Embedded had no problems with the savepoint, but the client raised this error 
when calling setSavepoint():

java.sql.SQLSyntaxErrorException: Syntax error: Encountered "b" at line 1, 
column 16.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira