[DERBY-2745] DatabaseMetaData.getFunctions() is missing the FUNCTION_TYPE column

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.2.2.0, 10.3.1.4
• Component/s: JDBC
• Assignee: Unassigned
• Reporter: Daniel John Debrunner
• Created: 01/Jun/07 17:03
• Updated: 15/Aug/07 22:26
• Resolved: 15/Aug/07 22:26

Description

From the jdbc4.TestDbMetaData test it appears that DMD.getFunctions() is missing the FUNCTION_TYPE column.
Here's the expected column names from the test:
"FUNCTION_CAT", "FUNCTION_SCHEM", "FUNCTION_NAME", "REMARKS", "SPECIFIC_NAME"

JDK 6 javadoc has this additional column (as the 5th column)

1. FUNCTION_TYPE short => kind of function:

• functionResultUnknown - Cannot determine if a return value or table will be returned
• functionNoTable- Does not return a table
• functionReturnsTable - Returns a table

Issue Links

• duplicates: DERBY-2983 The ResultSet returned by DatabaseMetaData.getFunctions() does not contain a required column named FUNCTION_TYPE.