[jira] [Created] (CALCITE-2699) The bug of timestampadd handles time

["xuqianjin (JIRA)" <ji...@apache.org>]

xuqianjin created CALCITE-2699:
----------------------------------

             Summary: 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


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)