You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2010/10/01 10:25:32 UTC
[jira] Updated: (DERBY-4828) Import fails if column names contain
double quotes
[ 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.