[jira] [Commented] (DRILL-4401) multi-table join projection returning character instead of integer type

["Taras Supyk (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-4401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15204174#comment-15204174 ] 

Taras Supyk commented on DRILL-4401:
------------------------------------

This bug can't be reproduced. Looks like it is fixed already.

> 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: Storage - JDBC
>    Affects Versions: 1.5.0
>            Reporter: N Campbell
>            Assignee: Taras Supyk
>
> 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)