[jira] [Created] (TRAFODION-763) LP Bug: 1392481 - UNLOAD query involves ORDER-BY returns ERORR[4001].

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

Alice Chen created TRAFODION-763:
------------------------------------

             Summary: LP Bug: 1392481 - UNLOAD query involves ORDER-BY returns ERORR[4001].
                 Key: TRAFODION-763
                 URL: https://issues.apache.org/jira/browse/TRAFODION-763
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Julie Thai
            Assignee: Apache Trafodion


Currently TRAF does not support order-by clause in UNLOAD stmt.
Appropriate error msg to be returned. 

SQL>unload with purgedata from target
into '/bulkload/QA_unload_tests/loc_queries' select
        l_orderkey,
        cast(sum(l_extendedprice*(1-l_discount)) as numeric(18,2)) as revenue,
        o_orderdate,
        o_shippriority
from
        g_tpch2x.customer,
        g_tpch2x.orders,
        g_tpch2x.lineitem
where
        c_mktsegment = 'HOUSEHOLD'
        and c_custkey = o_custkey
        and l_orderkey = o_orderkey
        and o_orderdate < date '1995-03-12'
        and l_shipdate > date '1995-03-12'
group by
        l_orderkey,
        o_orderdate,
        o_shippriority
order by
        revenue desc,
        o_orderdate;
*** ERROR[4001] Column REVENUE is not found.  Tables in scope: TRAFODION.BULKLOAD_UNLOAD.EXE_UTIL_EXPR__.  Default schema: TRAFODION.BULKLOAD_UNLOAD. [2014-11-12 17:46:20]
Assigned to LaunchPad User khaled Bouaziz



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