[IGNITE-19161] Sql. Can`t insert timestamp representing in ISO_INSTANT format.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: calcite2-required calcite3-required ignite-3
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 30/Mar/23 06:02
• Updated: 30/Mar/23 06:03

Description

DateTimeFormatter#ISO_INSTANT format like 2023-03-29T08:22:33.005007Z can`t be inserted:

CREATE TABLE timestamps(id INTEGER PRIMARY KEY, i TIMESTAMP)
INSERT INTO timestamps VALUES (101, TIMESTAMP '2023-03-29T08:22:33.005007Z') - failed.