[
https://issues.apache.org/jira/browse/TRAFODION-201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-201.
----------------------------------
Resolution: Fixed
Assignee: (was: Prashanth Vasudev)
Fix Version/s: 0.8 (pre-incubation)
> LP Bug: 1295473 - Same query returns different results when the column is a
> primary key
> ---------------------------------------------------------------------------------------
>
> Key: TRAFODION-201
> URL: https://issues.apache.org/jira/browse/TRAFODION-201
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Priority: Critical
> Fix For: 0.8 (pre-incubation)
>
>
> Same query returns different results on 2 tables with the same columns and
> the same data. The only difference is that one of the tables declares the
> column used in the query as a primary key. In the following output, the 1st
> part of the output shows that the query returns 3 rows when column a is not a
> primary key. The 2nd part of the output shows that the query returns only 2
> rows when column a is declared as a primary key. Value 0, which should be
> returned, is not returned.
> This is seen on the beta 0.7.0 RC1 build installed on a workstation.
> -bash-4.1$ sqlci
> Trafodion Conversational Interface 0.7.0
> (c) Copyright 2014 Hewlett-Packard Development Company, LP.
> >>create table minmax (a real not null);
> --- SQL operation complete.
> >>insert into minmax values (-10e10), (-1), (0), (1), (10e10);
> --- 5 row(s) inserted.
> >>select * from minmax where a < 10e-77;
> A
> ---------------
> -9.9999997E+010
> -1.0000000E+000
> 0.0000000E+000
> --- 3 row(s) selected.
> >>drop table minmax;
> ================================================================================================
> --- SQL operation complete.
> >>create table minmax (a real not null, primary key(a));
> --- SQL operation complete.
> >>insert into minmax values (-10e10), (-1), (0), (1), (10e10);
> --- 5 row(s) inserted.
> >>select * from minmax where a < 10e-77;
> A
> ---------------
> -9.9999997E+010
> -1.0000000E+000
> --- 2 row(s) selected.
> >>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
