[ https://issues.apache.org/jira/browse/HAWQ-135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14993462#comment-14993462 ]
ASF GitHub Bot commented on HAWQ-135: ------------------------------------- GitHub user liming01 opened a pull request: https://github.com/apache/incubator-hawq/pull/82 HAWQ-135. Fixed coredump when explain generate_serial in optimizer off Need to set query as DISPATCH_SEQUENTIAL when legacy query optimizer doesn't set it as DISPATCH_PARALLEL. You can merge this pull request into a Git repository by running: $ git pull https://github.com/liming01/incubator-hawq mli/explain_crash_legacy_opt Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-hawq/pull/82.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #82 ---- commit 0306f0cf2ca6e24b6d7b7bc439f417647fb8c86f Author: Ming LI <m...@pivotal.io> Date: 2015-11-06T10:15:29Z HAWQ-135. Fixed coredump when explain generate_serial in optimizer off ---- > 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)