[
https://issues.apache.org/jira/browse/DERBY-1773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bryan Pendleton resolved DERBY-1773.
------------------------------------
Resolution: Fixed
Fix Version/s: 10.13.0.0
I've completed the work I intended for this issue; resolving.
> 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
> Assignee: Bryan Pendleton
> Priority: Minor
> Labels: derby_triage10_5_2
> Fix For: 10.13.0.0
>
> Attachments: ASF.LICENSE.NOT.GRANTED--Alias.java,
> NoUpdatesToAliasedColumnsWithTest.diff, anyVsAll.diff, fixedComments.diff,
> updatedToHeadMarch2010.diff, updatedToHeadMarch2016.diff
>
>
> 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 was sent by Atlassian JIRA
(v6.3.4#6332)
