[
https://issues.apache.org/jira/browse/DERBY-2515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-2515:
---------------------------------
Attachment: derby-2515-01-ac-copyINOUTreturnValues.diff
Attaching derby-2515-01-ac-copyINOUTreturnValues.diff. This patch fixes the bug
by copying output values to the corresponding input array in the network driver.
The tests passed cleanly for me except for known Heisenbugs and a new failure
in ProcedureTest introduced by this patch. The new test case in ProcedureTest
discloses DERBY-5162. Once that bug is fixed, ProcedureTest should run cleanly
too.
Touches the following files:
----------
M java/client/org/apache/derby/client/am/CallableStatement.java
In the network driver, input args and output args are maintained in two
separate arrays. This patch copies the output values of INOUT args to the
corresponding slots in the input array.
----------
M
java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ProcedureTest.java
Adds a test case to verify that INOUT values are preserved across invocations
for all datatypes.
> Network client does not retain the INOUT parameter value change for
> subsequent execution
> ----------------------------------------------------------------------------------------
>
> Key: DERBY-2515
> URL: https://issues.apache.org/jira/browse/DERBY-2515
> Project: Derby
> Issue Type: Bug
> Components: Network Client
> Affects Versions: 10.3.1.4
> Reporter: Kathey Marsden
> Priority: Minor
> Labels: derby_triage10_8
> Attachments: Test_2515.java,
> derby-2515-01-ac-copyINOUTreturnValues.diff
>
>
> If I set a INOUT parameter to a value (say 12.3) and it gets
> modified by the procedure to another value (say 45.6) then on
> the next execution
> of the same CallableStatement, embedded maintains the
> current value (45.6), while network server reverts to the
> former value (12.3).
> This issue was found while converting the test lang/procedure.java. See
> references to this issue in the converted LangProcedureTest.java
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
