You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2011/03/29 16:08:05 UTC

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

     [ https://issues.apache.org/jira/browse/DERBY-5162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-5162:
---------------------------------

    Attachment: z.java

Attaching z.java, a program which demonstrates the bug.

> 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
>         Attachments: 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