[DERBY-4459] Verification error at execute-time when an outer function which takes a primitive arg is wrapped around an inner function which returns the corresponding Java wrapper object

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.2.1, 10.5.3.1, 10.6.1.0
• Fix Version/s: 10.5.3.2, 10.6.2.4, 10.7.1.1
• Component/s: SQL
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 01/Dec/09 16:07
• Updated: 14/Jun/13 17:35
• Resolved: 16/Feb/11 19:30

Description

An insane Derby raises a verification error when trying to run the following query:

values( negateInt( getNullInt() ) );

where negateInt() takes a primitive int argument and getNullInt() returns an Integer.

Sane Derby raises an assertion. The same test case, run against 10.3.3.1, also fails but raises a more graceful compile-time exception.

Issue Links

• blocks: DERBY-479 Passing the return of a RETURN NULL ON NULL INPUT function to another function call throws linkage error.
• is required by: DERBY-4994 10.5 backport effort issue (2011)
• relates to: DERBY-1030 In some situations a RETURNS NULL ON NULL function is called when one ot its parameters is NULL