[ https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Victoria Markman resolved DRILL-3677. ------------------------------------- Resolution: Invalid > Wrong result with LEAD window function when used in multiple windows in the > same query > -------------------------------------------------------------------------------------- > > Key: DRILL-3677 > URL: https://issues.apache.org/jira/browse/DRILL-3677 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill > Affects Versions: 1.2.0 > Reporter: Victoria Markman > Assignee: Deneche A. Hakim > Priority: Critical > Fix For: 1.2.0 > > Attachments: j1.tar, q46.out, q46.res > > > Query produces wrong result: > {code} > select > c_integer, > lead(c_integer) over (order by c_integer), > lead(c_integer) over (partition by c_time order by c_date) > from > j1 > ; > {code} > Attached: q46.res (result generated from postgres) > q46.out (output from Drill) > j1.tar - table used in the query > I tried to reproduce the same error on a smaller data set without any > success. Tried with the table with the same data as j1, but single parquet > file: same behavior. -- This message was sent by Atlassian JIRA (v6.3.4#6332)