[
https://issues.apache.org/jira/browse/IGNITE-15619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17832201#comment-17832201
]
Pavel Pereslegin commented on IGNITE-15619:
-------------------------------------------
The described example is related to IGNITE-15123 issue.
I think this issue mostly relates to different date formats and negative form.
For example:
{code:sql}
SELECT '-1000-01-01'::DATE::VARCHAR = '1001-01-01 (BC)'
{code}
As I understand BC/negative dates are not supported by Calcite currently
([CALCITE-5629|https://issues.apache.org/jira/browse/CALCITE-5629]).
{code:sql}
SELECT '1992/09/20'::DATE::VARCHAR = '1992-09-20'
{code}
Such format is not supported.
> Calcite. Fix numerous errors with DATE TIME types tests.
> --------------------------------------------------------
>
> Key: IGNITE-15619
> URL: https://issues.apache.org/jira/browse/IGNITE-15619
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ignite-3
>
> for example :
> {noformat}
> statement ok
> CREATE TABLE dates(i DATE)
> statement ok
> INSERT INTO dates VALUES ('1993-08-14'), (NULL)
> {noformat}
> {noformat}
> statement ok
> CREATE TABLE times(i TIME)
> statement ok
> INSERT INTO times VALUES ('00:01:20'), ('20:08:10.998'), ('20:08:10.33'),
> ('20:08:10.001'), (NULL)
> {noformat}
> failed tests:
> {noformat}
> /types/date/*
> /types/time/*
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
