[
http://issues.apache.org/jira/browse/DERBY-925?page=comments#action_12367959 ]
Dyre Tjeldvoll commented on DERBY-925:
--------------------------------------
I have some questions about the columns in the resultset that is returned from
this method.
Abbreviations:
GFP=DatabaseMetaData.getFunctionParameters()
GPC=DatabaseMetaData.getProcedureColumns()
Column (3, PARAMETER_NAME): Will this be NULL in the return value row?
Column (8, PRECISION): GPC returns non-NULL for all SQL types. Should it return
NULL for some types?
Column (9, LENGTH): GPC uses TypeDescriptor.getMaximumWidthInBytes(). When
running in ij, this returns 256 for VARCHAR(128), and it looks like it will
return 256 for CLOB and BLOB. That does not seem right to me...
Column (11, RADIX): GPC returns 10 for all types, except REAL, FLOAT and
DOUBLE. Should it not be NULL for some types, e.g. VARCHAR, CLOB?
Column (12, NULLABLE):
a) GPC always returns procedureNullable. Should GFP return functionNullable for
all types? (TypeDescriptor.isNullable() exists but is not used)
b) Should this column be NULL for the return value row?
Column (14, CHAR_OCTET_LENGTH) a) How can we identify the char/binary types in
Derby? Can we use DataTypeDescriptor.isBinary() and isCharacter()?
b) How to get the true max for the type? (Don't think
getMaximumWidthInBytes() will work as it returns maximumWidth for these types.
Column (16, IS_NULLABLE a) Is this a String equivalent of column 12?
b) Does YES in quotes mean String s = "YES" or String s =
"'YES'"?
> Implement new JDBC 4 metadata API getFunctionParameters()
> ---------------------------------------------------------
>
> Key: DERBY-925
> URL: http://issues.apache.org/jira/browse/DERBY-925
> Project: Derby
> Type: New Feature
> Components: JDBC
> Versions: 10.2.0.0
> Environment: JDK 1.6
> Reporter: David Van Couvering
> Assignee: Dyre Tjeldvoll
>
> I am currently implementing this to return an empty result set so at least
> we're compliant, but we should be able to provide real metadata here.
--
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
