[jira] [Created] (TRAFODION-158) LP Bug: 1259694 - Statement atomicity does not work when update fails

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-158:
------------------------------------

             Summary: LP Bug: 1259694 - Statement atomicity does not work when update fails
                 Key: TRAFODION-158
                 URL: https://issues.apache.org/jira/browse/TRAFODION-158
             Project: Apache Trafodion
          Issue Type: Bug
          Components: dtm
            Reporter: Weishiun Tsai
            Assignee: Anoop Sharma
            Priority: Critical


When an update statement encounters a failure, the table is left partly updated.  As shown in the following example, the update statement encountered error 8411, which was expected.  The 1st row was updated, but the 2nd row was not.  The statement atomicity with the transaction support should have rolled back the entire statement.

>>create table dtarit6 (ivhr interval hour, ivmn interval minute);

--- SQL operation complete.
>>insert into dtarit6 values (interval '12' hour, interval '59' minute), (interval - '23' hour, interval - '59' minute);

--- 2 row(s) inserted.
>>select * from dtarit6;

IVHR  IVMN
----  ----

  12    59
-23   -59

--- 2 row(s) selected.
>>update dtarit6 set IVHR = IVHR - interval '24' hour, IVMN = IVMN - interval '60' minute;

*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:INTERVAL MINUTE(REC_INT_MINUTE) Source Value:0x89FF to Target Type:INTERVAL MINUTE(REC_INT_MINUTE).

--- 0 row(s) updated.
>>select * from dtarit6;

IVHR  IVMN
----  ----

-12   - 1
-23   -59

--- 2 row(s) selected.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)