[DERBY-5162] CLOB INOUT arg set to NULL by procedure does not preserve NULL value when re-invoked

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.8.1.2
• Fix Version/s: 10.8.1.2
• Component/s: JDBC, SQL
• Issue & fix info: Repro attached
• Bug behavior facts: Wrong query result
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 29/Mar/11 14:05
• Updated: 14/Jun/13 17:27
• Resolved: 29/Mar/11 22:57

Description

If a procedure sets an INOUT CLOB arg to NULL and is then re-invoked, the NULL is not preserved. Instead, the procedure sees the same CLOB that it saw in the last invocation. This bug was disclosed during the testing of the fix for DERBY-2515. I will attach a repro.

Issue Links

• is depended upon by: DERBY-2515 Network client does not retain the INOUT parameter value change for subsequent execution