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)