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

["Lei Chang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lei Chang closed HAWQ-593.
--------------------------
       Resolution: Fixed
    Fix Version/s: 2.0.0

> 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
>             Fix For: 2.0.0
>
>
> 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)