db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1773) insertRow() and updateRow() fail with syntax error when column has an alias
Date Tue, 29 Aug 2006 07:10:27 GMT
insertRow() and updateRow() fail with syntax error when column has an alias
---------------------------------------------------------------------------

                 Key: DERBY-1773
                 URL: http://issues.apache.org/jira/browse/DERBY-1773
             Project: Derby
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 10.2.1.0
            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.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message