[jira] [Created] (TRAFODION-220) LP Bug: 1305233 - update query's effect is delayed occasionally

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

Alice Chen created TRAFODION-220:
------------------------------------

             Summary: LP Bug: 1305233 - update query's effect is delayed occasionally
                 Key: TRAFODION-220
                 URL: https://issues.apache.org/jira/browse/TRAFODION-220
             Project: Apache Trafodion
          Issue Type: Bug
          Components: dtm
            Reporter: Suresh Subbiah
            Assignee: John de Roo
            Priority: Blocker


The Sql dev regression test core/test018 occasionally fails with this difference


49,50c49,50
<  2 10103 4
<  3 11004 5
---
>  2 103 4
>  3 1004 5

The top 2 lines are from the expected file, while the next 2 are from the log file.

The update statement that caused this diff is

>>update T018orig set b = b + 10000;

--- 3 row(s) updated.
>>select * from T018orig;

A B C
----------

 1 10012 3
 2 103 4
 3 1004 5

Note that the row with A = 1 has the correct value and reflects that the update has already occured. The next 2 rows (with A = 2 and A = 3) have the problem reported in this bug. The delay is only for a short inyterval since two statements more into the test we have this update which finds the row

>>update T018orig set c = c + 100 where b = 10103;

--- 1 row(s) updated.

Also a similar update later on in the test works as expected.

>>update T018orig set c = c + 10000;

--- 3 row(s) updated.
>>select * from T018orig;

A B C
----------

 1 10012 10013
 2 10103 10104
 3 11004 11005

The table does have an index on column b.

create table T018orig (a int NOT NULL, b int, c int, primary key (a))
+>#ifMX
+>no partition
+>#ifMX
+>;

--- SQL operation complete.
>>create index T018 on T018orig(b);

The DIFF and log files are attached.



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