[HAWQ-135] Explain generate serial will cause coredump in optimizer off

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Optimizer
• Assignee: Ming Li
• Reporter: Ming Li
• Created: 06/Nov/15 10:13
• Updated: 21/Nov/15 03:31
• Resolved: 16/Nov/15 01:55

Description

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;