[jira] [Created] (TRAFODION-396) LP Bug: 1335477 - Group by query returns different results in 2 builds

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

Alice Chen created TRAFODION-396:
------------------------------------

             Summary: LP Bug: 1335477 - Group by query returns different results in 2 builds
                 Key: TRAFODION-396
                 URL: https://issues.apache.org/jira/browse/TRAFODION-396
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Weishiun Tsai
            Assignee: Hans Zeller
            Priority: Blocker


This particular group by query returns different results in 2 builds.  As shown here, 2 builds were installed on the same cluster centos-mapr1.  The table lineitem has not been changed.  Switching between the 2 builds:  0616_0930 and 0625_0930, with the same database, the query somehow returns different results.   The result from 0616_0930 is what is shown in SQ as well, so presumably the older build has the correct result.

[trafodion@centos-mapr1 ~]$ sqid
cat: /opt/hptc/pdsh/nodes: No such file or directory
MY_SQROOT=/home/trafodion/v0616_0930
who@host=trafodion@centos-mapr1
JAVA_HOME=/usr/lib/jvm/java
linux=2.6.32-358.23.2.el6.x86_64
redhat=6.4

[trafodion@centos-mapr1 scripts]$ sqlci | cat
Trafodion Conversational Interface 0.8.1
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>set schema g_tpch2x;

--- SQL operation complete.
>>select count(*) from lineitem where l_shipdate <= date '1998-09-23' group by l_returnflag, l_linestatus;

*** WARNING[6007] Multi-column statistics for columns (L_RETURNFLAG, L_LINESTATUS) from table TRAFODION.G_TPCH2X.LINEITEM were not available. The columns were being used by GroupBy operator. As a result, the access path chosen might not be the best possible.

(EXPR)
--------------------

             2962417
             77026
             2959267
             5899422

--- 4 row(s) selected.

====================================================================
[trafodion@centos-mapr1 scripts]$ sqid
cat: /opt/hptc/pdsh/nodes: No such file or directory
MY_SQROOT=/home/trafodion/v0625_0930
who@host=trafodion@centos-mapr1
JAVA_HOME=/usr/lib/jvm/java
linux=2.6.32-358.23.2.el6.x86_64
redhat=6.4

[trafodion@centos-mapr1 scripts]$ sqlci | cat
Trafodion Conversational Interface 0.8.1
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>set schema g_tpch2x;

--- SQL operation complete.
>>select count(*) from lineitem where l_shipdate <= date '1998-09-23' group by l_returnflag, l_linestatus;

*** WARNING[6007] Multi-column statistics for columns (L_RETURNFLAG, L_LINESTATUS) from table TRAFODION.G_TPCH2X.LINEITEM were not available. The columns were being used by GroupBy operator. As a result, the access path chosen might not be the best possible.

(EXPR)
--------------------

             2962417
             77028
             2959267
             5899428

--- 4 row(s) selected.



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