[
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.
