[
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)
