[
https://issues.apache.org/jira/browse/HAWQ-593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15214452#comment-15214452
]
ASF GitHub Bot commented on HAWQ-593:
-------------------------------------
Github user xinzweb commented on the pull request:
https://github.com/apache/incubator-hawq/pull/512#issuecomment-202480139
Merge:
https://github.com/apache/incubator-hawq/commit/01a27b7406d31a7ab5aa307b360f01c466165596
> Function crashes with PANIC in planning stage related to gp_cte_sharing
> -----------------------------------------------------------------------
>
> Key: HAWQ-593
> URL: https://issues.apache.org/jira/browse/HAWQ-593
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Optimizer
> Reporter: xin zhang
> Assignee: Amr El-Helw
>
> Small repro:
> {code}
> set optimizer=off;
> set gp_cte_sharing=on=on;
> create table t (c int);
> insert into t values (2);
> explain
> with cte0 (e) as (values (0), (1))
> select c, count(distinct d) disc_d
> from (
> select c, d
> from (
> select
> case
> when t.c in (select e from cte0) then 'a'
> when t.c not in (select e from cte0) then 'b'
> end as d,
> c
> from t, cte0
> ) A
> group by c, d
> ) B
> group by c;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
