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)