You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Martijn Visser (Jira)" <ji...@apache.org> on 2023/03/01 09:56:00 UTC

[jira] [Commented] (FLINK-31279) fix times using number and interval type bug

    [ 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)