You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2015/08/14 02:20:45 UTC

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

     [ https://issues.apache.org/jira/browse/TRAFODION-160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Atanu Mishra closed TRAFODION-160.
----------------------------------
       Resolution: Fixed
         Assignee:     (was: John de Roo)
    Fix Version/s: 1.0 (pre-incubation)

> 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
>            Priority: Critical
>             Fix For: 1.0 (pre-incubation)
>
>
> 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)