[IGNITE-15623] Sql. Reject erroneous datetime literals.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: calcite2-required ignite-3
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 27/Sep/21 13:53
• Updated: 03/May/23 08:10
• Resolved: 03/May/23 08:10

Description

statement ok
CREATE TABLE timestamp(t TIMESTAMP)

/sql/types/timestamp/test_incorrect_timestamp.test

INSERT INTO timestamp VALUES ('1900-02-35 00:00:00')  <-- need to fail, but smartly converted instead.

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• is related to: CALCITE-5678 Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard
• links to: GitHub Pull Request #1997
• links to: GitHub Pull Request #1997