You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2016/02/17 21:58:18 UTC
[jira] [Created] (DRILL-4401) multi-table join projection returning
character instead of integer type
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)