hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "zhenglin tao (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1470) Wrong result in subplan + externalscan
Date Mon, 22 May 2017 13:54:04 GMT
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)

Mime
View raw message