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