[HAWQ-593] Function crashes with PANIC in planning stage related to gp_cte_sharing

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Resolved
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Optimizer
• Assignee: Amr El-Helw
• Reporter: xin zhang
• Created: 25/Mar/16 21:10
• Updated: 14/Jul/16 17:56
• Resolved: 14/Jul/16 17:56

Description

Small repro:

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;