[DRILL-3595] Wrong results returned by query that uses LEAD window function

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0
• Component/s: Execution - Codegen, Execution - Flow
• Labels: window_function

Environment

private-branch-new-window-funcs

• Assignee: Abdel Hakim Deneche
• Reporter: Khurram Faraaz
• Created: 03/Aug/15 22:24
• Updated: 04/Aug/15 01:08
• Resolved: 03/Aug/15 23:26

Description

Query that uses LEAD window function returns wrong results on developer's private branch (new-window-funcs).

Results returned by Drill

0: jdbc:drill:schema=dfs.tmp> select lead(c1) over w from union_01 window w as (partition by c3 order by c1) limit 10;
+---------+
| EXPR$0  |
+---------+
| 878     |
| -150    |
| 402     |
| 402     |
| 402     |
| 402     |
| 402     |
| 160     |
| 160     |
| 160     |
+---------+
10 rows selected (0.349 seconds)

Results returned by Postgres

postgres=# select lead(c1) over w from union_01 window w as (partition by c3 order by c1) limit 10;
 lead 
------
     
     
  402
  402
  402
  402
  402
     
  160
  160
(10 rows)