[IGNITE-19804] Sql. Fix timestamp|datetime processing errors

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: calcite3-required ignite-3
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 22/Jun/23 08:04
• Updated: 26/Jun/23 08:51

Description

Some cases are failed:

case 1:

CREATE TABLE IF NOT EXISTS timestamp (t TIMESTAMP);

INSERT INTO timestamp VALUES ('2008-01-01 00:00:01'), (NULL), ('2007-01-01 00:00:01')

Values passed to VALUES operator must have compatible types

case 2:
SELECT timestamp '2017-07-23 13:10:11';

Not expected result at: (test_timestamp.test_ignore:15). [row=0, col=0, expected=2017-07-23 13:10:11, actual=2017-07-23T13:10:11]

case 3:
SELECT TIMESTAMP '2001-04-20 14:42:11.12300000000000000000';

Not expected result at: (test_timestamp_ms.test_ignore:6). [row=0, col=0, expected=2001-04-20 14:42:11.123, actual=2001-04-20T14:42:11.123]