[DERBY-3511] Cannot resolve functions which return VARCHAR FOR BIT DATA or LONG VARCHAR FOR BIT DATA

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.1.3
• Fix Version/s: 10.4.1.3
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 07/Mar/08 16:12
• Updated: 21/Jan/11 18:17
• Resolved: 23/Jun/08 15:40

Description

I create a static method which returns a byte array and register it as a function returning one of the byte array types (VARCHAR FOR BIT DATA or LONG VARCHAR FOR BIT DATA). I expect that Derby will be able to resolve this method when I try to invoke the function. But Derby tells me it can't find a matching method. I will attach a test case.

Issue Links

• is blocked by: DERBY-3512 Using functions, you can create a LONG VARCHAR value which is longer than the maximum length of a Derby LONG VARCHAR
• is part of: DERBY-3652 Derby does not follow the SQL Standard when trying to map SQL routines to Java methods.