Timo Walther created FLINK-20323:
------------------------------------
Summary: CorrelateSortToRankRule cannot deal with multiple
groupings
Key: FLINK-20323
URL: https://issues.apache.org/jira/browse/FLINK-20323
Project: Flink
Issue Type: Improvement
Components: Table SQL / Planner
Reporter: Timo Walther
Fix the following test case in {{CorrelateSortToRankRuleTest}}:
{code}
@Test // TODO: this is a valid case to support
def testMultipleGroupingsNotSupported(): Unit = {
val query =
s"""
|SELECT f0, f2
|FROM
| (SELECT DISTINCT f0, f1 FROM t1) t2,
| LATERAL (
| SELECT f2
| FROM t1
| WHERE f0 = t2.f0 AND f1 = t2.f1
| ORDER BY f2
| DESC LIMIT 3
| )
""".stripMargin
util.verifyPlan(query)
}
{code}
Currently, we only support one equal condition not {{f0 = t2.f0 AND f1 =
t2.f1}}.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
