Pavel Pereslegin created IGNITE-25154:
-----------------------------------------

             Summary: Sql. Adding interval to TIMESTAMP WITH LOCAL TIME ZONE 
doesn't check bounds
                 Key: IGNITE-25154
                 URL: https://issues.apache.org/jira/browse/IGNITE-25154
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Pavel Pereslegin


The following test must result in out of range exception.
{code:sql}
SELECT TIMESTAMP WITH LOCAL TIME ZONE '2024-01-01 00:00:00' + INTERVAL 2920000 
DAYS)
{sql}
or
{code:sql}
SELECT CURRENT_TIME + INTERVAL 2920000 DAYS)
{sql}

Actual result
{noformat}
+10018-09-08T21:00:00Z
{noformat}

This does not reproduce with dynamic parameters and TIMESTAMP (WITHOUT TIME 
ZONE).




--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to