[#DERBY-229] Column names on ResultSet.updateXXX and getXXX methods are handled incorrectly

Derby

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

Created: 19/Apr/05 12:04 PM Updated: 03/Jun/05 02:57 PM

Component/s:

JDBC

Affects Version/s:

10.0.2.1, 10.1.1.0

Fix Version/s:

10.1.1.0

Time Tracking:

Not Specified

File Attachments:

	File Name	Date Attached	Attached By	Size
	x.java	2005-04-19 12:06 PM	Daniel John Debrunner	1 kB

Resolution Date:

03/Jun/05 02:56 PM

Description

« Hide

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

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Daniel John Debrunner made changes - 19/Apr/05 12:06 PM

Field	Original Value	New Value
Attachment		x.java [ 19679 ]

Daniel John Debrunner made changes - 19/Apr/05 12:10 PM

Affects Version/s

10.0.2.1 [ 10991 ]

Shreyas Kaushik made changes - 02/May/05 12:36 PM

Assignee

Shreyas Kaushik [ shreyas ]

Shreyas Kaushik made changes - 03/Jun/05 02:56 PM

Fix Version/s		10.1.0.0 [ 10993 ]
Status	Open [ 1 ]	Resolved [ 5 ]
Resolution		Fixed [ 1 ]

Shreyas Kaushik made changes - 03/Jun/05 02:57 PM

Status

Resolved [ 5 ]

Closed [ 6 ]