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:06:05 UTC
[jira] [Created] (DERBY-5162) CLOB INOUT arg set to NULL by
procedure does not preserve NULL value when re-invoked
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
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
[jira] [Updated] (DERBY-5162) CLOB INOUT arg set to NULL by
procedure does not preserve NULL value when re-invoked
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-5162:
---------------------------------
Issue & fix info: [Patch Available, Repro attached] (was: [Repro attached])
> 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
[jira] [Assigned] (DERBY-5162) CLOB INOUT arg set to NULL by
procedure does not preserve NULL value when re-invoked
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas reassigned DERBY-5162:
------------------------------------
Assignee: Rick Hillegas
> 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: 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
[jira] [Updated] (DERBY-5162) CLOB INOUT arg set to NULL by
procedure does not preserve NULL value when re-invoked
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Resolved] (DERBY-5162) CLOB INOUT arg set to NULL by
procedure does not preserve NULL value when re-invoked
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas resolved DERBY-5162.
----------------------------------
Resolution: Fixed
Fix Version/s: 10.8.0.0
Issue & fix info: [Repro attached] (was: [Repro attached, Patch Available])
Tests passed cleanly except for known Heisenbugs. Committed derby-5162-01-aa-restoreToNull.diff at subversion revision 1086798.
> 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
> Fix For: 10.8.0.0
>
> 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
[jira] [Updated] (DERBY-5162) CLOB INOUT arg set to NULL by
procedure does not preserve NULL value when re-invoked
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ 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