[DERBY-319] Derby returns incorrect values for "LENGTH" column of DatabaseMetaData.getProcedureColumns() result set.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.0, 10.0.2.1, 10.0.2.2, 10.1.1.0
• Fix Version/s: 10.1.1.0
• Component/s: JDBC
• Assignee: A B
• Reporter: A B
• Created: 27/May/05 06:41
• Updated: 11/Jun/05 00:28
• Resolved: 11/Jun/05 00:26

Description

Based on discussion from the following thread:

http://article.gmane.org/gmane.comp.apache.db.derby.devel/2585

The Derby implementation of DatabaseMetaData.getProcedureColumns() returns incorrect values for the "LENGTH" column of the result, primarily because there is no clear definition in the JDBC spec regarding what this method is supposed to return. Discussion in the above-posted thread concluded that the intent of the JDBC metadata is to "match the ODBC metadata", at least regard to this particular issue. So changes reflecting this conclusion should be submitted to Derby.