[
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.
