[ https://issues.apache.org/jira/browse/HAWQ-135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14995973#comment-14995973 ]
ASF GitHub Bot commented on HAWQ-135: ------------------------------------- Github user liming01 closed the pull request at: https://github.com/apache/incubator-hawq/pull/82 > 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: Ming LI > > 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)