You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "luoyuxia (Jira)" <ji...@apache.org> on 2024/01/24 04:02:00 UTC
[jira] [Updated] (FLINK-31090) Flink SQL fail to select INTERVAL
[ https://issues.apache.org/jira/browse/FLINK-31090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
luoyuxia updated FLINK-31090:
-----------------------------
Fix Version/s: 1.18.0
> Flink SQL fail to select INTERVAL
> ----------------------------------
>
> Key: FLINK-31090
> URL: https://issues.apache.org/jira/browse/FLINK-31090
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner, Table SQL / Runtime
> Reporter: luoyuxia
> Priority: Major
> Fix For: 1.18.0
>
>
> Can be reproduce in CalcITCase with the following code:
>
> {code:java}
> @Test def testSelectInterval(): Unit = { checkResult("SELECT INTERVAL 2 DAY", data3) }
> {code}
>
>
> It'll throw the exception:
> org.apache.flink.table.planner.codegen.CodeGenException: Interval expression type expected.
> at org.apache.flink.table.planner.codegen.CodeGenUtils$.requireTimeInterval(CodeGenUtils.scala:419)
> at org.apache.flink.table.planner.codegen.ExprCodeGenerator.generateCallExpression(ExprCodeGenerator.scala:549)
> at org.apache.flink.table.planner.codegen.ExprCodeGenerator.visitCall(ExprCodeGenerator.scala:490)
> at org.apache.flink.table.planner.codegen.ExprCodeGenerator.visitCall(ExprCodeGenerator.scala:57)
> at org.apache.calcite.rex.RexCall.accept(RexCall.java:189)
> at org.apache.flink.table.planner.codegen.ExprCodeGenerator.generateExpression(ExprCodeGenerator.scala:143)
> at org.apache.flink.table.planner.codegen.ExpressionReducer.$anonfun$reduce$2(ExpressionReducer.scala:81)
> at scala.collection.immutable.List.map(List.scala:282)
> at org.apache.flink.table.planner.codegen.ExpressionReducer.reduce(ExpressionReducer.scala:81)
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)