[IGNITE-15619] Calcite. Fix numerous errors with DATE TIME types tests.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite calcite2-required calcite3-required ignite-3
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 27/Sep/21 12:32
• Updated: 29/Mar/24 15:13

Description

for example :

statement ok
CREATE TABLE dates(i DATE)

statement ok
INSERT INTO dates VALUES ('1993-08-14'), (NULL)

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)

failed tests:

/types/date/*
/types/time/*

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine