[
https://issues.apache.org/jira/browse/IGNITE-24947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-24947:
--------------------------------------
Affects Version/s: 3.0
> Sql. Add validation for cast VARCHAR::DATE/TIMESTAMP with zero DAY value
> ------------------------------------------------------------------------
>
> Key: IGNITE-24947
> URL: https://issues.apache.org/jira/browse/IGNITE-24947
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0
> Reporter: Pavel Pereslegin
> Priority: Major
> Labels: ignite-3
>
> {code:sql}
> SELECT '0001-00-01'::DATE -- Throws: Value of MONTH field is out of range
> in '0001-00-01' (correct)
> SELECT '0001-01-00'::DATE -- produces invalid result [0000-12-31]
> SELECT '0001-01-32'::DATE -- Throws: Value of DAY field is out of range in
> '0001-01-32' (correct)
> {code}
> This affects TIMESTAMP/TIMESTAMP_WITH_LOCAL_TIME_ZONE also.
> For literal value exception is thrown.
> {code:sql}
> SELECT date '0001-01-00' -- Illegal DATE literal '0001-01-00': not in
> format 'yyyy-MM-dd'
> {code}
> Looks acceptable.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
