[
https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768285#comment-17768285
]
Stamatis Zampetakis commented on CALCITE-5957:
----------------------------------------------
This is a tricky situation cause if we admit that CALCITE-5678 aims to enforce
SQL standard compatibility then there is nothing to do here. If we decide to
enforce strict pattern with no optional zeros that's fine with me. However, we
need to converge soon cause this is blocking various other tickets and
potentially a subsequent release.
> Valid DATE '1945-2-2' is not accepted due to regression
> -------------------------------------------------------
>
> Key: CALCITE-5957
> URL: https://issues.apache.org/jira/browse/CALCITE-5957
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.35.0
> Reporter: Runkang He
> Priority: Blocker
> Fix For: avatica-1.24.0
>
> Attachments: image-2023-08-27-19-09-33-284.png
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> DATE '1945-2-2' is a valid date. In CALCITE-5923 when we turn on the result
> check of `testCastStringToDateTime`, we find that Calcite accepted DATE
> '1945-2-2' before CALCITE-5678 but not afterwards, so this is a regression
> that we need to fix.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
