liu ming created TRAFODION-2238:
Summary: Compiler Internal Error: RelExpr with unknown arity
encountered with combination of WITH clause and Intersect
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
(select iss.i_brand_id brand_id
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
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
SELECT COUNT(*) FROM cross_items;
*** ERROR Compiler Internal Error: RelExpr with unknown arity
encountered, originated from file ../optimizer/RelExpr.cpp at line 355.
*** ERROR The statement was not prepared.
This message was sent by Atlassian JIRA