[
https://issues.apache.org/jira/browse/FLINK-31279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17694970#comment-17694970
]
Martijn Visser commented on FLINK-31279:
----------------------------------------
[~jackylau] Why is this is a bug, the documentation shows that you should use
INTERVAL like
{code:java}
E.g., INTERVAL ‘10 00:00:00.004’ DAY TO SECOND, INTERVAL ‘10’ DAY, or INTERVAL
‘2-10’ YEAR TO MONTH return intervals.
{code}
https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/functions/systemfunctions/
> fix times using number and interval type bug
> ---------------------------------------------
>
> Key: FLINK-31279
> URL: https://issues.apache.org/jira/browse/FLINK-31279
> Project: Flink
> Issue Type: Bug
> Affects Versions: 1.18.0
> Reporter: jackylau
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.18.0
>
>
> {code:java}
> // code placeholder
> Flink SQL> select interval 3 day * 2;
> [ERROR] Could not execute SQL statement. Reason:
> org.apache.flink.table.planner.codegen.CodeGenException: Interval expression
> type expected. {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
