[
https://issues.apache.org/jira/browse/IGNITE-25154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-25154:
--------------------------------------
Description:
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)
{code}
Actual result
{noformat}
+10018-09-08T21:00:00Z
{noformat}
This does not reproduce with dynamic parameters and TIMESTAMP (WITHOUT TIME
ZONE).
p.s. the same is applicable for the following:
{code:sql}
SELECT CURRENT_TIME + INTERVAL 2920000 DAYS)
{code}
was:
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)
{code}
or
{code:sql}
SELECT CURRENT_TIME + INTERVAL 2920000 DAYS)
{code}
Actual result
{noformat}
+10018-09-08T21:00:00Z
{noformat}
This does not reproduce with dynamic parameters and TIMESTAMP (WITHOUT TIME
ZONE).
> 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
> Priority: Major
> Labels: ignite-3
>
> 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)
> {code}
> Actual result
> {noformat}
> +10018-09-08T21:00:00Z
> {noformat}
> This does not reproduce with dynamic parameters and TIMESTAMP (WITHOUT TIME
> ZONE).
> p.s. the same is applicable for the following:
> {code:sql}
> SELECT CURRENT_TIME + INTERVAL 2920000 DAYS)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
