drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Taras Supyk (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4401) multi-table join projection returning character instead of integer type
Date Mon, 21 Mar 2016 13:26:25 GMT

    [ 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)

Mime
View raw message