[jira] [Closed] (HAWQ-1796) plan cores in fix_scan_expr_mutator

["Zhenglin Tao (Jira)" <ji...@apache.org>]

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

Zhenglin Tao closed HAWQ-1796.
------------------------------
    Resolution: Fixed

> plan cores in fix_scan_expr_mutator
> -----------------------------------
>
>                 Key: HAWQ-1796
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1796
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Planner
>            Reporter: Ruilong Huo
>            Assignee: Radar Da Lei
>            Priority: Major
>             Fix For: 3.0.0.0
>
>
> ```
> CREATE TABLE t1 (a int, b int) format 'orc' DISTRIBUTED BY (a);
> CREATE TABLE x (a int) format 'orc' DISTRIBUTED BY (a);
> CREATE TABLE t2 (a int, b int) format 'orc' DISTRIBUTED BY (a);
> select * from x where a= (select sum(t1.a) from t1 inner join (select x.a as outer_ref, * from t2) as foo on (foo.a=t1.a+ outer_ref) group by foo.a);
> ```



--
This message was sent by Atlassian Jira
(v8.3.4#803005)