db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dyre Tjeldvoll (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-925) Implement new JDBC 4 metadata API getFunctionParameters()
Date Mon, 27 Feb 2006 14:28:59 GMT
    [ 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


Mime
View raw message