[
https://issues.apache.org/jira/browse/DERBY-1773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bryan Pendleton updated DERBY-1773:
-----------------------------------
Attachment: fixedComments.diff
Attached 'fixedComments.diff' is essentially identical
to the previous patch, but I updated some of the comments
to be more accurate, and changed the string text in
a SanityManager,Debug statement. So, no functional
change, just cleanup.
All my regression tests have been clean.
> 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
> 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)