db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4828) Import fails if column names contain double quotes
Date Fri, 01 Oct 2010 08:25:32 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4828?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen updated DERBY-4828:
--------------------------------------

    Attachment: test.diff

Attached a test case that demonstrates the bug. If you apply the patch and run ImportExportTest,
you'll see this error:

1) testQuotesInColumnNames(org.apache.derbyTesting.functionTests.tests.tools.ImportExportTest)java.sql.SQLException:
The exception 'java.sql.SQLException: Syntax error: Encountered ":" at line 1, column 66.'
was thrown while evaluating an expression.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:142)
        at org.apache.derby.impl.jdbc.Util.seeNextException(Util.java:278)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:398)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2269)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1321)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1680)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1335)
        at org.apache.derbyTesting.functionTests.tests.tools.ImportExportTest.doImportFromFile(ImportExportTest.java:323)


> Import fails if column names contain double quotes
> --------------------------------------------------
>
>                 Key: DERBY-4828
>                 URL: https://issues.apache.org/jira/browse/DERBY-4828
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 10.7.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>            Priority: Minor
>         Attachments: test.diff
>
>
> If the target table for an import operation contains columns with double quotes in their
names, the import will fail with a syntax error.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message