[ https://issues.apache.org/jira/browse/HAWQ-593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15212668#comment-15212668 ]
ASF GitHub Bot commented on HAWQ-593: ------------------------------------- Github user xinzweb commented on the pull request: https://github.com/apache/incubator-hawq/pull/512#issuecomment-201621708 @changleicn @vraghavan78 > 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)