[jira] [Work started] (TRAFODION-2238) Compiler Internal Error: RelExpr with unknown arity encountered with combination of WITH clause and Intersect

["liu ming (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-2238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on TRAFODION-2238 started by liu ming.
-------------------------------------------
> 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)