[ https://issues.apache.org/jira/browse/TRAFODION-220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696096#comment-14696096 ]
Atanu Mishra commented on TRAFODION-220: ---------------------------------------- Atanu Mishra (atanu-mishra) wrote on 2014-06-06: #4 Change submitted on 6/5 by disabling the early commit reply. Changed in trafodion: status: New → Fix Committed Stacey Johnson (sjohnson-w) on 2014-06-10 information type: Proprietary → Public Weishiun Tsai (wei-shiun-tsai) wrote on 2014-08-26: #5 QA testing has not seen this problem ever since the early commit reply is disabled. Mark this case as problem fixed. Changed in trafodion: status: Fix Committed → Fix Released > 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 > Fix For: 1.0 (pre-incubation) > > > 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)