[ https://issues.apache.org/jira/browse/IGNITE-15619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17832201#comment-17832201 ]
Pavel Pereslegin edited comment on IGNITE-15619 at 3/29/24 3:13 PM: -------------------------------------------------------------------- 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)' SELECT '30000-01-01'::DATE::VARCHAR = '30000-01-01' {code} As I understand such 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. was (Author: xtern): 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)' SELECT '30000-01-01'::DATE::VARCHAR = '30000-01-01' {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)