[ https://issues.apache.org/jira/browse/HAWQ-217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ruilong Huo updated HAWQ-217: ----------------------------- Affects Version/s: 2.0.0-beta-incubating > "invalid memory alloc request size" during "SELECT * FROM t WHERE w ORDER BY > o" > ------------------------------------------------------------------------------- > > Key: HAWQ-217 > URL: https://issues.apache.org/jira/browse/HAWQ-217 > Project: Apache HAWQ > Issue Type: Bug > Components: Core > Affects Versions: 2.0.0-beta-incubating > Reporter: Ruilong Huo > Assignee: Ruilong Huo > Fix For: 2.0.0 > > > In "SELECT * FORM WHERE w ORDER BY o", it errors out with "ERROR: invalid > memory alloc request size 18446744073709551600 (context 'ExecutorState') > (mcxt.c:1107) (mcxt.c:475)". > Reproduction steps: > Step 1: prepare scheme and data > {noformat} > CREATE TABLE foo(a int, b int, c int) > DISTRIBUTED BY (a) > PARTITION BY RANGE (b) (START (1) END (100) EVERY (10)); > INSERT INTO foo SELECT generate_series(1,66), generate_series(1,99), > generate_series(1, 198); > ANALYZE foo; > {noformat} > Step 2: run query > {noformat} > gptest=# SELECT * FROM foo WHERE b = 105 ORDER BY 1,2,3; > ERROR: invalid memory alloc request size 18446744073709551600 (context > 'ExecutorState') (mcxt.c:1107) (mcxt.c:475) > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)