Mika Naylor created FLINK-37803:
-----------------------------------
Summary: LocalTime without seconds is incorrectly serialized to
SQL as a value literal
Key: FLINK-37803
URL: https://issues.apache.org/jira/browse/FLINK-37803
Project: Flink
Issue Type: Bug
Components: Table SQL / API
Reporter: Mika Naylor
When creating a literal from a LocalTime object without seconds, like
LocalTime.of(12, 12), the serialisable string form of the value literal is
serialized into invalid SQL expression, in this case TIME '12:12' instead of
TIME '12:12:00', resulting in:
{code:java}
org.apache.flink.table.api.ValidationException: SQL validation failed: Illegal
TIME literal '12:12': not in format 'HH:mm:ss'{code}
This also affects LocalDateTime objects used in the same way:
{code:java}
org.apache.flink.table.api.ValidationException: SQL validation failed: Illegal
TIMESTAMP literal '2024-02-03 12:12': not in format 'yyyy-MM-dd HH:mm:ss'{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
