You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "xuqianjin (JIRA)" <ji...@apache.org> on 2018/11/23 07:12:00 UTC
[jira] [Updated] (CALCITE-2699) The bug of timestampadd handles
time
[ https://issues.apache.org/jira/browse/CALCITE-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
xuqianjin updated CALCITE-2699:
-------------------------------
Description:
Two errors occur when {{timestampadd(MINUTE, 1, time '01:00:00')}} is executed:
# The return result can only be of {{TimeStamp}} type and is expected to be of {{Time}} type
# The return value is {{1970-01-01 01:01:00}}, and the expectation is {{01:01:00}}
# Compared with {{mysql}} database, I think it should meet the following conditions:
||expression||Expect the result||
|timestampadd(MINUTE, -1, time '00:00:00')|NULL|
|timestampadd(MINUTE, 1, time '00:00:00')|00:01:00|
|timestampadd(MINUTE, 1, time '23:59:59')|00:00:59|
|timestampadd(SECOND, 1, time '23:59:59')|00:00:00|
|timestampadd(HOUR, 1, time '23:59:59')|00:59:59|
was:
Two errors occur when {{timestampadd(MINUTE, 1, time '01:00:00')}} is executed:
# The return result can only be of {{TimeStamp}} type and is expected to be of {{Time}} type
# The return value is {{1970-01-01 01:01:00}}, and the expectation is {{01:01:00}}
# Compared with {{mysql}} database, I think it should meet the following conditions:
||expression||Expect the result||
|timestampadd(MINUTE, -1, time '00:00:00')|NULL|
|timestampadd(MINUTE, 1, time '00:00:00')|00:01:00|
|timestampadd(MINUTE, 1, time '23:59:59')|00:00:59|
|timestampadd(SECOND, 1, time '23:59:59')|00:00:00|
|timestampadd(HOUR, 1, time '23:59:59')|00:59:59|
> The bug of timestampadd handles time
> -------------------------------------
>
> Key: CALCITE-2699
> URL: https://issues.apache.org/jira/browse/CALCITE-2699
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.17.0, 1.18.0
> Reporter: xuqianjin
> Assignee: Julian Hyde
> Priority: Major
>
> Two errors occur when {{timestampadd(MINUTE, 1, time '01:00:00')}} is executed:
> # The return result can only be of {{TimeStamp}} type and is expected to be of {{Time}} type
> # The return value is {{1970-01-01 01:01:00}}, and the expectation is {{01:01:00}}
> # Compared with {{mysql}} database, I think it should meet the following conditions:
> ||expression||Expect the result||
> |timestampadd(MINUTE, -1, time '00:00:00')|NULL|
> |timestampadd(MINUTE, 1, time '00:00:00')|00:01:00|
> |timestampadd(MINUTE, 1, time '23:59:59')|00:00:59|
> |timestampadd(SECOND, 1, time '23:59:59')|00:00:00|
> |timestampadd(HOUR, 1, time '23:59:59')|00:59:59|
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)