[jira] [Created] (CALCITE-4817) Expand SubstitutionVisitor of Aggregate with max/min, which column is he group by list of target

["Xurenhe (Jira)" <ji...@apache.org>]

Xurenhe created CALCITE-4817:
--------------------------------

             Summary: Expand SubstitutionVisitor of Aggregate with max/min, which column is he group by list of target
                 Key: CALCITE-4817
                 URL: https://issues.apache.org/jira/browse/CALCITE-4817
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Xurenhe
            Assignee: Xurenhe


Now, SubstitutionVisitor support `Query with distinct aggregate on the column is matched to the group list existing in target`, as [CALCITE-4374|https://issues.apache.org/jira/browse/CALCITE-4374] describes.

But, When query aggregate with max/min based on the column, which is in the group by list of target.

Materialized view recognition should also success.
{code:java}
//代码占位符
@Test void testQueryNoDistinctOptionalityAggCallColInTargetGroupBy1() {
  final String mv = ""
      + "select \"name\", \"deptno\" "
      + "from \"emps\" group by \"name\", \"deptno\"";
  final String query = ""
      + "select \"name\", min(\"deptno\")\n"
      + "from \"emps\" group by \"name\"";
  sql(mv, query).ok();
}
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)