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)
