You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hawq.apache.org by "Ruilong Huo (Jira)" <ji...@apache.org> on 2021/07/26 06:02:00 UTC

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

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)