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

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

Alice Chen created TRAFODION-160:
------------------------------------

             Summary: LP Bug: 1261993 - Select * and select count(*) show inconsistent results within a transaction
                 Key: TRAFODION-160
                 URL: https://issues.apache.org/jira/browse/TRAFODION-160
             Project: Apache Trafodion
          Issue Type: Bug
          Components: dtm
            Reporter: Weishiun Tsai
            Assignee: John de Roo
            Priority: Critical


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



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