[jira] [Created] (IGNITE-15418) Calcite engine. TIMESTAMPDIFF function returns INTEGER type for MICROSECOND time unit

["Aleksey Plekhanov (Jira)" <ji...@apache.org>]

Aleksey Plekhanov created IGNITE-15418:
------------------------------------------

             Summary: Calcite engine. TIMESTAMPDIFF function returns INTEGER type for MICROSECOND time unit
                 Key: IGNITE-15418
                 URL: https://issues.apache.org/jira/browse/IGNITE-15418
             Project: Ignite
          Issue Type: Bug
            Reporter: Aleksey Plekhanov


SQL function {{TIMESTAMPDIFF}} returns {{INTEGER}} type for {{MICROSECOND}} time unit, but sometimes precession of {{int}} is not enough to store value. For example, value for
{code:java}
SELECT TIMESTAMPDIFF(MICROSECOND, TIMESTAMP '2022-02-01 10:30:26.000', TIMESTAMP '2022-05-01 10:30:28.122'){code}
is {{7689602122000}}, and it's more then maximum {{int}} value. It's better to extend {{TIMESTAMPDIFF}} return type to {{BIGINT}} for {{MICROSECOND}} time unit (\{{SqlTimestampDiffFunction.RETURN_TYPE_INFERENCE}} should be changed). 

The main problem - this function is defined in Calcite and hardcoded in the parser (see {{TimestampDiffFunctionCall}} in {{Parser.jj}}), so it's not so easy to provide our own implementation.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)