Ruilong Huo created HAWQ-1796:
---------------------------------
Summary: 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
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)
