[IGNITE-14724] Calcite engine. Create table with DATE column creates INTEGER column

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Assignee: Aleksey Plekhanov
• Reporter: Aleksey Plekhanov
• Created: 16/May/21 19:02
• Updated: 17/Jun/21 09:39
• Resolved: 17/Jun/21 09:39

Description

Reproducer:

sql("CREATE TABLE t(d DATE)", true); 
sql("INSERT INTO t VALUES (date '2021-01-01')", true);

Fails with:

org.apache.calcite.runtime.CalciteContextException: At line 0, column 0: Cannot assign to target field 'D' of type INTEGER from source field 'DATE '2021-01-01'' of type DATE

Issue Links

• is part of: IGNITE-14535 Caclite SQL engine capabilities
• links to: GitHub Pull Request #9111