Details
-
Sub-task
-
Status: Closed
-
Critical
-
Resolution: Invalid
-
None
Description
Computing a MAX or MIN of a TIME column using the OVER clause seem to generate wrong results compared to Postgres. Example of such queries:
SELECT MIN(CAST(columns[1] AS TIME)) OVER(PARTITION BY columns[0]) FROM `3281.csv`;
SELECT MAX(CAST(columns[1] AS TIME)) OVER(PARTITION BY columns[0]) FROM `3281.csv`;