[jira] [Created] (DRILL-5095) Selecting Join Columns returning null values in the second column

[Ravan (JIRA)]

Ravan created DRILL-5095:
----------------------------

             Summary: Selecting Join Columns returning null values in the 
second column
                 Key: DRILL-5095
                 URL: https://issues.apache.org/jira/browse/DRILL-5095
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.8.0
            Reporter: Ravan


select a.empno,a.ename,a.deptno,b.deptno deptno deptno_1,b.loc from emp a FULL 
JOIN dept b ON a.deptno = b.deptno

Returning O/P:- 

empno     ename   deptno  deptno_1  loc

7369.0  SMITH   20.0    null    DALLAS
7499.0  ALLEN   30.0    null    CHICAGO

Estimated O/P:-

empno     ename   deptno  deptno_1  loc

7369.0  SMITH   20.0    20.0    DALLAS
7499.0  ALLEN   30.0    30.0    CHICAGO




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