[
https://issues.apache.org/jira/browse/DERBY-5162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-5162:
---------------------------------
Attachment: derby-5162-01-aa-restoreToNull.diff
Attaching derby-5162-01-aa-restoreToNull.diff. This is a 1-line patch to
SQLChar.restoreToNull() which fixes this bug. I will run regression tests. I
don't propose to write a separate regression test for this problem. This fix
should be covered by the more exhaustive test supplied in
derby-2515-01-ac-copyINOUTreturnValues.diff.
Touches the following file:
M java/engine/org/apache/derby/iapi/types/SQLChar.java
> CLOB INOUT arg set to NULL by procedure does not preserve NULL value when
> re-invoked
> ------------------------------------------------------------------------------------
>
> Key: DERBY-5162
> URL: https://issues.apache.org/jira/browse/DERBY-5162
> Project: Derby
> Issue Type: Bug
> Components: JDBC, SQL
> Affects Versions: 10.8.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-5162-01-aa-restoreToNull.diff, z.java
>
>
> 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.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
