[jira] [Created] (HAWQ-593) Function crashes with PANIC in planning stage related to gp_cte_sharing

["xin zhang (JIRA)" <ji...@apache.org>]

xin zhang created HAWQ-593:
------------------------------

             Summary: 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)