liu ming created TRAFODION-2238:
-----------------------------------

             Summary: Compiler Internal Error: RelExpr with unknown arity 
encountered with combination of WITH clause and Intersect
                 Key: TRAFODION-2238
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2238
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: liu ming
            Assignee: liu ming



Set the following CQD for the intersects to take effect..
.
The following is a portion of Query 0000014 from TPC-DS.

CQD mode_special_4 'ON';

with cross_items as
(
select i_item_sk ss_item_sk
 from item,
    (select iss.i_brand_id brand_id
         ,iss.i_class_id class_id
         ,iss.i_category_id category_id
     from store_sales
         ,item iss
         ,date_dim d1
     where ss_item_sk = iss.i_item_sk
       and ss_sold_date_sk = d1.d_date_sk
       and d1.d_year between 1999 AND 1999 + 2
       
    intersect 
     select iws.i_brand_id
         ,iws.i_class_id
         ,iws.i_category_id
     from web_sales
         ,item iws
         ,date_dim d3
     where ws_item_sk = iws.i_item_sk
       and ws_sold_date_sk = d3.d_date_sk
       and d3.d_year between 1999 AND 1999 + 2
    ) x
)
SELECT COUNT(*) FROM cross_items;


*** ERROR[2235] Compiler Internal Error: RelExpr with unknown arity 
encountered, originated from file ../optimizer/RelExpr.cpp at line 355.

*** ERROR[8822] The statement was not prepared.



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

Reply via email to