[jira] [Updated] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK
[
https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
huaicui updated CALCITE-3412:
-
Description:
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 Tuesday that is not our expect result. As result, 2017-01-22 is
the first day that we expect.
was:
Floor timestamp to week exist error:
The start day of the week is not Sunday or Monday, calcite use Tuesday 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 Tuesday that is not our expect result. As result, 2017-01-22 is
the first day that we expect.
> Response Error for FLOOR TIMESTAMP TO WEEK
> ---
>
> Key: CALCITE-3412
> URL: https://issues.apache.org/jira/browse/CALCITE-3412
> Project: Calcite
> Issue Type: Bug
> Components: core
> Environment: mac,linux
>Reporter: huaicui
>Priority: Major
> 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 Tuesday 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)
[jira] [Updated] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK
[
https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
huaicui updated CALCITE-3412:
-
Description:
Floor timestamp to week exist error:
The start day of the week is not Sunday or Monday, calcite use Tuesday 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 Tuesday that is not our expect result. As result, 2017-01-22 is
the first day that is we expect.
was:
Floor timestamp to week exist error:
The start day of the week is not Sunday or Monday, calcite use Tuesday 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 Tuesday that is not our expect result. As result, 2017-01-22 is
what we expect.
> Response Error for FLOOR TIMESTAMP TO WEEK
> ---
>
> Key: CALCITE-3412
> URL: https://issues.apache.org/jira/browse/CALCITE-3412
> Project: Calcite
> Issue Type: Bug
> Components: core
> Environment: mac,linux
>Reporter: huaicui
>Priority: Major
> 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 Tuesday 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 Tuesday that is not our expect result. As result, 2017-01-22 is
> the first day that is we expect.
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK
[
https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
huaicui updated CALCITE-3412:
-
Description:
Floor timestamp to week exist error:
The start day of the week is not Sunday or Monday, calcite use Tuesday 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 Tuesday that is not our expect result. As result, 2017-01-22 is
the first day that we expect.
was:
Floor timestamp to week exist error:
The start day of the week is not Sunday or Monday, calcite use Tuesday 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 Tuesday that is not our expect result. As result, 2017-01-22 is
the first day that is we expect.
> Response Error for FLOOR TIMESTAMP TO WEEK
> ---
>
> Key: CALCITE-3412
> URL: https://issues.apache.org/jira/browse/CALCITE-3412
> Project: Calcite
> Issue Type: Bug
> Components: core
> Environment: mac,linux
>Reporter: huaicui
>Priority: Major
> 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 Tuesday 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 Tuesday 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)
[jira] [Updated] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK
[
https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
huaicui updated CALCITE-3412:
-
Description:
Floor timestamp to week exist error:
The start day of the week is not Sunday or Monday, calcite use Tuesday 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 Tuesday that is not our expect result. As result, 2017-01-22 is
what we expect.
was:
The start day of the week is not Sunday or Monday, calcite use Tuesday to split
a week, like this:
select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
The response is :
2017-01-26 00:00:00.0
2017-01-26 is Tuesday.
> Response Error for FLOOR TIMESTAMP TO WEEK
> ---
>
> Key: CALCITE-3412
> URL: https://issues.apache.org/jira/browse/CALCITE-3412
> Project: Calcite
> Issue Type: Bug
> Components: core
> Environment: mac,linux
>Reporter: huaicui
>Priority: Major
> 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 Tuesday 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 Tuesday that is not our expect result. As result, 2017-01-22 is
> what we expect.
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK
[
https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
huaicui updated CALCITE-3412:
-
Description:
The start day of the week is not Sunday or Monday, calcite use Tuesday to split
a week, like this:
select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
The response is :
2017-01-26 00:00:00.0
2017-01-26 is Tuesday.
!image-2019-10-15-13-33-34-896.png!
was:
The start day of the week is not Sunday or Monday, calcite use Tuesday to split
a week, like this:
select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
The response is :
2017-01-26 00:00:00.0
!image-2019-10-15-13-33-34-896.png!
> Response Error for FLOOR TIMESTAMP TO WEEK
> ---
>
> Key: CALCITE-3412
> URL: https://issues.apache.org/jira/browse/CALCITE-3412
> Project: Calcite
> Issue Type: Bug
> Components: core
> Environment: mac,linux
>Reporter: huaicui
>Priority: Major
> Attachments: image-2019-10-15-13-33-34-896.png
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> The start day of the week is not Sunday or Monday, calcite use Tuesday to
> split a week, like this:
> select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
> The response is :
> 2017-01-26 00:00:00.0
> 2017-01-26 is Tuesday.
>
>
> !image-2019-10-15-13-33-34-896.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK
[
https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
huaicui updated CALCITE-3412:
-
Description:
The start day of the week is not Sunday or Monday, calcite use Tuesday to split
a week, like this:
select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
The response is :
2017-01-26 00:00:00.0
2017-01-26 is Tuesday.
was:
The start day of the week is not Sunday or Monday, calcite use Tuesday to split
a week, like this:
select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
The response is :
2017-01-26 00:00:00.0
2017-01-26 is Tuesday.
!image-2019-10-15-13-33-34-896.png!
> Response Error for FLOOR TIMESTAMP TO WEEK
> ---
>
> Key: CALCITE-3412
> URL: https://issues.apache.org/jira/browse/CALCITE-3412
> Project: Calcite
> Issue Type: Bug
> Components: core
> Environment: mac,linux
>Reporter: huaicui
>Priority: Major
> Attachments: image-2019-10-15-13-33-34-896.png
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> The start day of the week is not Sunday or Monday, calcite use Tuesday to
> split a week, like this:
> select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
> The response is :
> 2017-01-26 00:00:00.0
> 2017-01-26 is Tuesday.
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK
[
https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
huaicui updated CALCITE-3412:
-
Environment: mac,linux (was: The start day of the week is not Sunday or
Monday, calcite use Tuesday to split a week, like this:
select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
The response is :
2017-01-26 00:00:00.0
!image-2019-10-15-13-33-34-896.png!)
> Response Error for FLOOR TIMESTAMP TO WEEK
> ---
>
> Key: CALCITE-3412
> URL: https://issues.apache.org/jira/browse/CALCITE-3412
> Project: Calcite
> Issue Type: Bug
> Components: core
> Environment: mac,linux
>Reporter: huaicui
>Priority: Major
> Attachments: image-2019-10-15-13-33-34-896.png
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> The start day of the week is not Sunday or Monday, calcite use Tuesday to
> split a week, like this:
> select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
> The response is :
> 2017-01-26 00:00:00.0
>
> !image-2019-10-15-13-33-34-896.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (CALCITE-3412) Response Error for FLOOR TIMESTAMP TO WEEK
[
https://issues.apache.org/jira/browse/CALCITE-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
huaicui updated CALCITE-3412:
-
Description:
The start day of the week is not Sunday or Monday, calcite use Tuesday to split
a week, like this:
select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
The response is :
2017-01-26 00:00:00.0
!image-2019-10-15-13-33-34-896.png!
> Response Error for FLOOR TIMESTAMP TO WEEK
> ---
>
> Key: CALCITE-3412
> URL: https://issues.apache.org/jira/browse/CALCITE-3412
> Project: Calcite
> Issue Type: Bug
> Components: core
> Environment: The start day of the week is not Sunday or Monday,
> calcite use Tuesday to split a week, like this:
> select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
> The response is :
> 2017-01-26 00:00:00.0
>
> !image-2019-10-15-13-33-34-896.png!
>Reporter: huaicui
>Priority: Major
> Attachments: image-2019-10-15-13-33-34-896.png
>
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> The start day of the week is not Sunday or Monday, calcite use Tuesday to
> split a week, like this:
> select FLOOR(CAST('2017-01-28' AS TIMESTAMP) TO WEEK);
> The response is :
> 2017-01-26 00:00:00.0
>
> !image-2019-10-15-13-33-34-896.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
