[ https://issues.apache.org/jira/browse/DRILL-3414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Victoria Markman updated DRILL-3414: ------------------------------------ Attachment: j4.parquet j1.tar query.tar > 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 > Labels: window_funcion > Attachments: j1.tar, j4.parquet, query.tar > > > {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)