[DRILL-3278] SUM(CAST(columns[0] AS BIGINT)) 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:27
• Updated: 11/Jun/15 19:12
• Resolved: 11/Jun/15 19:02

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[1] as BIGINT )) 
    OVER(PARTITION BY cast( columns[2] as CHAR(2))) 
FROM `allData.csv`;

Issue Links

• is a clone of: DRILL-3277 SUM(CAST(columns[0] AS INT)) OVER(...) gives wrong results
• is part of: DRILL-2015 Casting numeric value that does not fit in integer data type produces incorrect result