[jira] [Created] (FLINK-20323) CorrelateSortToRankRule cannot deal with multiple groupings

[Shang Yuanchun (Jira)]

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)