drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4401) multi-table join projection returning character instead of integer type
Date Wed, 17 Feb 2016 20:58:18 GMT
N Campbell created DRILL-4401:
---------------------------------

             Summary: multi-table join projection returning character instead of integer type
                 Key: DRILL-4401
                 URL: https://issues.apache.org/jira/browse/DRILL-4401
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.5.0
            Reporter: N Campbell


column 8 should be an integer type but is described by drill as character.


select tj.tj1rnum, tj.c1 tj1c1, tj.c2 tj1c2, tj2rnum, tj.tj2c1, tj.tj2c2,  tjoin3.rnum tj3rnum,
tjoin3.c1 tj3c1, tjoin3.c2 tj3c2 from   (select tjoin1.rnum tj1rnum, tjoin1.c1, tjoin2.c2,
tjoin2.rnum tj2rnum,    tjoin2.c1 tj2c1, tjoin2.c2 tj2c2   from postgres.public.tjoin1 left
outer join postgres.public.tjoin2 on tjoin1.c1=tjoin2.c1) tj  left outer join postgres.public.tjoin3
on tj.c1=tjoin3.c1  


create table TJOIN1 (RNUM integer   not null , C1 integer, C2 integer);
insert into TJOIN1 (RNUM, C1, C2) values ( 0, 10, 15);
insert into TJOIN1 (RNUM, C1, C2) values ( 1, 20, 25);
insert into TJOIN1 (RNUM, C1, C2) values ( 2, NULL, 50);

create table TJOIN2 (RNUM integer   not null , C1 integer, C2 char(2));
insert into TJOIN2 (RNUM, C1, C2) values ( 0, 10, 'BB');
insert into TJOIN2 (RNUM, C1, C2) values ( 1, 15, 'DD');
insert into TJOIN2 (RNUM, C1, C2) values ( 2, NULL, 'EE');
insert into TJOIN2 (RNUM, C1, C2) values ( 3, 10, 'FF');

create table TJOIN3 (RNUM integer   not null , C1 integer, C2 char(2));
insert into TJOIN3 (RNUM, C1, C2) values ( 0, 10, 'XX');
insert into TJOIN3 (RNUM, C1, C2) values ( 1, 15, 'YY');

create table TJOIN4 (RNUM integer   not null , C1 integer, C2 char(2));





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message