Column names on ResultSet.updateXXX and getXXX methods are handled incorrectly
------------------------------------------------------------------------------

         Key: DERBY-229
         URL: http://issues.apache.org/jira/browse/DERBY-229
     Project: Derby
        Type: Bug
  Components: JDBC  
    Versions: 10.1.0.0    
    Reporter: Daniel John Debrunner
 Attachments: x.java

Sections 14.2.3 and [14.2.3] of JDBC 3.0 spec say

Column names supplied to getter [updater] methods are case insensitive. If a 
select list
contains the same column more than once, the first instance of the column will 
be
returned [updated].

Derby returns or updates the last column in the select list, not the first. 
With the attached Java class I see

PRE-UPDATE
1,100
POST-UPDATE
1,500
POST-UPDATE getXXX(name)
AB:500,ab500

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

Reply via email to