Ruilong Huo created HAWQ-217:
--------------------------------

             Summary: "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: Lei Chang




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)

Reply via email to