Select * and select count(*) show inconsistent results within a transaction

[Weishiun Tsai]

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.
>>

[John de Roo (john-deroo)]

Fixed and verified in seatrans_2 branch. Merged into datalake_64 branch, revision 39062.

[Weishiun Tsai (wei-shiun-tsai)]

verified on the datalake v39114 build, which was the first datalake build when seatrans_2 was merged into. This problem has been fixed:

[trafodion@centos-mapr1 scripts]$ sqlci | cat
Trafodion Conversational Interface 0.7.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>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)
--------------------

                   1

--- 1 row(s) selected.
>>rollback work;

--- SQL operation complete.
>>