You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Ming LI (JIRA)" <ji...@apache.org> on 2015/11/06 11:14:27 UTC

[jira] [Created] (HAWQ-135) Explain generate serial will cause coredump in optimizer off

Ming LI created HAWQ-135:
----------------------------

             Summary: Explain generate serial will cause coredump in optimizer off
                 Key: HAWQ-135
                 URL: https://issues.apache.org/jira/browse/HAWQ-135
             Project: Apache HAWQ
          Issue Type: Bug
          Components: Optimizer
            Reporter: Ming LI
            Assignee: Amr El-Helw


SET optimizer=off;
EXPLAIN ANALYZE
SELECT COUNT(i1) FROM generate_series(0,499) i1, generate_series(100,199) i2
GROUP BY i1,i2;

all other simplest query will crash when executed with 'optimizer=off'
explain select  generate_series(0,499);
explain select 1;




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)