Rui Li created FLINK-21592:
------------------------------
Summary: RemoveSingleAggregateRule fails due to nullability
mismatch
Key: FLINK-21592
URL: https://issues.apache.org/jira/browse/FLINK-21592
Project: Flink
Issue Type: Bug
Components: Table SQL / Planner
Reporter: Rui Li
Fix For: 1.13.0
The test case to reproduce the issue:
{code}
@Test
public void test() throws Exception {
tableEnv.executeSql("create table foo(x int,y int)");
tableEnv.executeSql("create table bar(i int,s string)");
System.out.println(tableEnv.explainSql("select (select count(x)-1 from
foo where foo.y=bar.i) from bar"));
}
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
