[DERBY-1030] In some situations a RETURNS NULL ON NULL function is called when one ot its parameters is NULL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.6.1.0
• Fix Version/s: 10.6.1.0
• Component/s: SQL
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Wrong query result
• Assignee: Richard N. Hillegas
• Reporter: Daniel John Debrunner
• Created: 23/Feb/06 04:59
• Updated: 21/Jan/11 18:28
• Resolved: 02/Dec/09 19:29

Description

The NULL argument to the function has to come from another function and that function's Java method has to return a Java object type corresponding to a fixed length SQL type, such as DATE, TIME and TIMESTAMP.

Will attach repro scripts.

Issue Links

• is part of: DERBY-2034 Tracking of bugs that lead to incorrect results being stored or returned to the client
• is related to: DERBY-479 Passing the return of a RETURN NULL ON NULL INPUT function to another function call throws linkage error.
• is related to: 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