[
https://issues.apache.org/jira/browse/TRAFODION-2238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15520700#comment-15520700
]
ASF GitHub Bot commented on TRAFODION-2238:
-------------------------------------------
GitHub user traflm opened a pull request:
https://github.com/apache/incubator-trafodion/pull/727
[TRAFODION-2238] Compiler Internal Error: RelExpr with unknown arity …
…encountered with combination of WITH clause and Intersect
WITH will use copyTree() try to do a deep copy of the binded node. But
before INTERSECT doesn't implement the CopyTopNode() method, so cannot be
copied.
This fix the issue and let the Q14 from TPCDS compile success.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/traflm/incubator-trafodion TRAFODION-2238
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/727.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #727
----
commit 26fdf9b9f766fd3b1bb0f673aec933b2d3f9bafd
Author: Liu Ming <[email protected]>
Date: 2016-09-25T11:54:02Z
[TRAFODION-2238] Compiler Internal Error: RelExpr with unknown arity
encountered with combination of WITH clause and Intersect
----
> 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)
