[jira] [Created] (TRAFODION-847) LP Bug: 1404951 - sebase/TEST010 fails returning only 1 o/p row

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

Alice Chen created TRAFODION-847:
------------------------------------

             Summary: LP Bug: 1404951 - sebase/TEST010 fails returning only 1 o/p row
                 Key: TRAFODION-847
                 URL: https://issues.apache.org/jira/browse/TRAFODION-847
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Ravisha Neelakanthappa
            Assignee: Apache Trafodion
            Priority: Critical
             Fix For: 1.1 (pre-incubation)


Seabase TEST010 fails due to difference in number of rows selected.

Log:
>>prepare x1 from
+>select * from t010t2 where a in (1,4) and b='a' and c = 1;

--- SQL command prepared.
>>
>>execute x1;

A B C D
----------

 1 a 1 1a1

--- 1 row(s) selected.

Expected:
>>prepare x1 from
+>select * from t010t2 where a in (1,4) and b='a' and c = 1;

--- SQL command prepared.
>>
>>execute x1;

A B C D
----------

 1 a 1 1a1
 4 a 1 4a1

--- 2 row(s) selected.

diff:
9002d9001
<  4 a 1 4a1
9004c9003
< --- 2 row(s) selected.
---
> --- 1 row(s) selected.
9034d9032
<  1 a 1 1a1
9039c9037
< --- 4 row(s) selected.
---
> --- 3 row(s) selected.

This needed to be investigated.
Assigned to LaunchPad User James Capps



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