Result mismatch of weekOfYear

[zml1206]

Backend

VL (Velox)

Bug description

select d,weekofyear(d) from values ('2021-12-31'),('2022-01-01') as data(d)

spark:

+----------+-------------+
|         d|weekofyear(d)|
+----------+-------------+
|2021-12-31|           52|
|2022-01-01|           52|

gluten:

+----------+-------------+
|         d|weekofyear(d)|
+----------+-------------+
|2021-12-31|           52|
|2022-01-01|           53|

Spark version

None

Spark configurations

No response

System information

No response

Relevant logs

No response

[zhli1142015]

Looks this issue is already fixed for Presto but not Spark.
facebookincubator/velox@f8f538e

[PHILO-HE]

@zml1206, could you fix this issue in Velox? In the initial implementation, the only difference between spark and presto is the return type. See facebookincubator/velox#5941. Now we may just need to copy presto's fix for spark.

[zml1206]

@zml1206, could you fix this issue in Velox? In the initial implementation, the only difference between spark and presto is the return type. See facebookincubator/velox#5941. Now we may just need to copy presto's fix for spark.

Processing in facebookincubator/velox#10713.