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