db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2983) The ResultSet returned by DatabaseMetaData.getFunctions() does not contain a required column named FUNCTION_TYPE.
Date Fri, 03 Aug 2007 19:55:52 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rick Hillegas updated DERBY-2983:
---------------------------------

    Attachment: derby-2983-01-newColumn.diff

Attaching derby-2983-01-newColumn.diff. This adds the FUNCTION_TYPE column to the ResultSet
returned by DatabaseMetaData.getFunctions(). Touches the following files:


M      java/engine/org/apache/derby/catalog/AliasInfo.java
M      java/engine/org/apache/derby/catalog/types/SynonymAliasInfo.java
M      java/engine/org/apache/derby/catalog/types/MethodAliasInfo.java
M      java/engine/org/apache/derby/catalog/types/RoutineAliasInfo.java

Exposes a new method on AliasInfo. The method reports whether the Alias describes a TableFunction.


M      java/engine/org/apache/derby/impl/jdbc/metadata.properties

Adds the new column to the query which materializes the ResultSet for DatabaseMetaData.getFunctions().
The query invokes the new method on AliasInfo in order and uses a CASE expression to determine
what value to assign to the FUNCTION_TYPE column.


M      java/shared/org/apache/derby/shared/common/reference/JDBC40Translation.java
M      java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/JDBC40TranslationTest.java

Add the JDBC4 constants which are legal values for the new column.


M      java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/TestDbMetaData.java

Update this unit test to account for the new column. Also verify that the columns returned
by DatabaseMetaData.getFunctions() have the correct types.



> The ResultSet returned by DatabaseMetaData.getFunctions() does not contain a required
column named FUNCTION_TYPE.
> -----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2983
>                 URL: https://issues.apache.org/jira/browse/DERBY-2983
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.2.1.6, 10.2.2.0, 10.3.0.0, 10.3.1.0, 10.3.1.1, 10.3.1.2, 10.3.1.3,
10.3.1.4, 10.4.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>             Fix For: 10.4.0.0
>
>         Attachments: derby-2983-01-newColumn.diff, releaseNote.html
>
>
> The FUNCTION_TYPE column, sandwiched between REMARKS and SPECIFIC_NAME, is supposed to
describe the return type of the function.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message