[
https://issues.apache.org/jira/browse/IGNITE-18663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17832213#comment-17832213
]
Pavel Pereslegin commented on IGNITE-18663:
-------------------------------------------
looks like a duplicate of IGNITE-14602
> Sql. DATE Literals are not validated correctly.
> -----------------------------------------------
>
> Key: IGNITE-18663
> URL: https://issues.apache.org/jira/browse/IGNITE-18663
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Minor
> Labels: calcite2-required, calcite3-required, ignite-3
> Fix For: 3.0.0-beta2
>
>
> Date literal with incorrect are not rejected. Some examples:
> {code:java}
> # month out of range
> INSERT INTO dates VALUES ('1993-20-14')
> # day out of range
> INSERT INTO dates VALUES ('1993-08-99')
> # day out of range because not a leapyear
> INSERT INTO dates VALUES ('1993-02-29')
> # day out of range because not a leapyear
> INSERT INTO dates VALUES ('1900-02-29')
> {code}
> See more examples in test_incorrect_dates.test
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
