[TRAFODION-160] LP Bug: 1261993 - Select * and select count(*) show inconsistent results within a transaction

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.0 (pre-incubation)
• Component/s: dtm
• External issue URL: https://bugs.launchpad.net/bugs/1261993
• Assignee: Unassigned
• Reporter: Weishiun Tsai
• Created: 22/Jul/15 18:14
• Updated: 14/Aug/15 00:20
• Resolved: 14/Aug/15 00:20

Description

Within a transaction, after a row was inserted into a table, select * and select count from the same table showed inconsistent results. Select * showed the row that was inserted. Select count showed 0, as shown in the following example:

>>create table t (a int);

— SQL operation complete.
>>begin work;

— SQL operation complete.
>>insert into t values (1);

— 1 row(s) inserted.
>>select * from t;

A
-----------

1

— 1 row(s) selected.
>>select count from t;

(EXPR)
--------------------

0

— 1 row(s) selected.
>>