[DRILL-3277] SUM(CAST(columns[0] AS INT)) OVER(...) gives wrong results

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Fix Version/s: 1.1.0
• Component/s: Execution - Flow
• Labels: window_function
• Assignee: Abdel Hakim Deneche
• Reporter: Abdel Hakim Deneche
• Created: 11/Jun/15 16:00
• Updated: 18/Jun/15 21:42
• Resolved: 18/Jun/15 21:42

Description

The following query return wrong results, there is a difference in actual vs expected results. Expected results were generated on Postgres 9.3

SELECT 
  SUM(cast( columns[0] as INT )) 
    OVER(PARTITION BY cast( columns[2] as CHAR(2))) 
FROM `allData.csv`;

Issue Links

• is cloned by: DRILL-3278 SUM(CAST(columns[0] AS BIGINT)) OVER(...) gives wrong results