[
https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17046523#comment-17046523
]
Andrew Tsvelodub commented on CALCITE-3412:
-------------------------------------------
If this will be in 1.22 it would be great, but I'm totally ok if this will land
in 1.23. So no need to rush or break the release process because of this issue.
Thank you for such a swift response!
> FLOOR(timestamp TO WEEK) gives wrong result
> -------------------------------------------
>
> Key: CALCITE-3412
> URL: https://issues.apache.org/jira/browse/CALCITE-3412
> Project: Calcite
> Issue Type: Bug
> Components: avatica, core
> Reporter: huaicui
> Assignee: Julian Hyde
> Priority: Major
> Fix For: avatica-1.17.0, 1.23.0
>
> Attachments: image-2019-10-15-13-33-34-896.png
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> Floor timestamp to week exist error:
> The start day of the week is not Sunday or Monday, calcite use Thursday to
> split a week.
> Example:
> sql: select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
> Response:
> 2017-01-26 00:00:00.0
>
> 2017-01-26 is Thursday that is not our expect result. As result, 2017-01-22
> is the first day that we expect.
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
