[ 
https://issues.apache.org/jira/browse/HAWQ-217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ruilong Huo resolved HAWQ-217.
------------------------------
       Resolution: Fixed
    Fix Version/s: 2.0.0

The issue has been fixed along with HAWQ-218 since it is related to HAWQ-218. 
For details regarding resolution, refer to HAWQ-218.

> "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)

Reply via email to