[jira] [Created] (HAWQ-1470) Wrong result in subplan + externalscan

["zhenglin tao (JIRA)" <ji...@apache.org>]

zhenglin tao created HAWQ-1470:
----------------------------------

             Summary: Wrong result in subplan + externalscan
                 Key: HAWQ-1470
                 URL: https://issues.apache.org/jira/browse/HAWQ-1470
             Project: Apache HAWQ
          Issue Type: Bug
          Components: External Tables
            Reporter: zhenglin tao
            Assignee: Ed Espino


Reproduce steps:
```
CREATE EXTERNAL TABLE testext (                           a int,                                                          b character varying(255)                                   ) LOCATION (                                                         'gpfdist://localhost:8081/test.csv'                        ) FORMAT 'text' (delimiter E',' null E'' escape E'OFF');
file content is:
1,abc
2,bce
3,ced

create table test1(c int);

insert into test1 values(1);

insert into test1 values(2);

insert into test1 values(3);

insert into test1 values(4);

select c,(select s.b from testext s where t.c=s.a) from test1 t;
 c | ?column?
---+----------
 1 |
 2 |
 3 |
 4 |
(4 rows)
```



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)