[
https://issues.apache.org/jira/browse/HAWQ-217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruilong Huo updated HAWQ-217:
-----------------------------
Description:
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:
{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:
{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}
was:
Reproduction steps:
Step 1:
{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:
{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}
> "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
> Reporter: Ruilong Huo
> Assignee: Ruilong Huo
>
> 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:
> {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:
> {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)
