[
https://issues.apache.org/jira/browse/DERBY-1773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen updated DERBY-1773:
--------------------------------------
Issue & fix info: [Repro attached]
Urgency: Normal
Triaged for 10.5.2.
> insertRow() and updateRow() fail with syntax error when column has an alias
> ---------------------------------------------------------------------------
>
> Key: DERBY-1773
> URL: https://issues.apache.org/jira/browse/DERBY-1773
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.1.6
> Reporter: Knut Anders Hatlen
> Priority: Minor
> Attachments: Alias.java
>
>
> When the select query used in an updatable result set has column aliases, a
> syntax error is thrown when executing ResultSet.insertRow() and
> ResultSet.updateRow(). The problem is seen on embedded and client. Repro is
> attached.
> Exception in thread "main" ERROR 42X14: 'A1' is not a column in table or VTI
> 'APP.T'.
> at
> org.apache.derby.iapi.error.StandardException.newException(StandardException.java:316)
> at
> org.apache.derby.impl.sql.compile.ResultColumn.bindResultColumnByName(ResultColumn.java:677)
> at
> org.apache.derby.impl.sql.compile.ResultColumnList.bindResultColumnsByName(ResultColumnList.java:682)
> at
> org.apache.derby.impl.sql.compile.ResultSetNode.bindResultColumns(ResultSetNode.java:683)
> at
> org.apache.derby.impl.sql.compile.SelectNode.bindResultColumns(SelectNode.java:742)
> at
> org.apache.derby.impl.sql.compile.UpdateNode.bind(UpdateNode.java:349)
> at
> org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:345)
> at
> org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:111)
> at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:723)
> at
> org.apache.derby.impl.jdbc.EmbedResultSet.updateRow(EmbedResultSet.java:3734)
> at Alias.main(Alias.java:15)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
