[DRILL-3677] Wrong result with LEAD window function when used in multiple windows in the same query

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Invalid
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0
• Component/s: Functions - Drill
• Assignee: Abdel Hakim Deneche
• Reporter: Victoria Markman
• Created: 20/Aug/15 18:10
• Updated: 21/Aug/15 01:19
• Resolved: 21/Aug/15 01:19

Description

Query produces wrong result:

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
;

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.