[jira] [Created] (DRILL-3414) Window function on a null producing column of an outer join results in the wrong result

[Victoria Markman (JIRA)]

Victoria Markman created DRILL-3414:
---------------------------------------

             Summary: Window function on a null producing column of an outer 
join results in the wrong result
                 Key: DRILL-3414
                 URL: https://issues.apache.org/jira/browse/DRILL-3414
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 1.0.0
            Reporter: Victoria Markman
            Assignee: Jinfeng Ni
            Priority: Critical


{code:sql}
select
        j4.c_boolean,
        j4.c_date,
        j4.c_integer,
        sum(j4.c_integer) over (partition by j4.c_boolean order by j4.c_date, 
j4.c_integer)
from    j1
           left outer join
           j4 on j1.c_integer = j4.c_integer
order by 1,2,3;
{code}


If window function is on left side, query returns correct result.
This works:
{code:sql}
select
        j1.c_boolean,
        j1.c_date,
        sum(j1.c_integer) over (partition by j1.c_boolean order by j1.c_date)
from
        j1
                left outer join
        j4 on j1.c_integer = j4.c_integer
order by
        1, 2;
{code}

Attached:

1. query.tar (q2.sql , q2.res (postgres output), q2.out (drill output) )
2. tables : j1.tar, j4.parquet



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