[jira] [Created] (CALCITE-5597) Column that be order by should not be aggregate

[Jiajun Xie (Jira)]

Jiajun Xie created CALCITE-5597:
-----------------------------------

             Summary: Column that be order by should not be aggregate
                 Key: CALCITE-5597
                 URL: https://issues.apache.org/jira/browse/CALCITE-5597
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Jiajun Xie


Here is unit test
{code:java}
@Test void testDistinctOrderByRand() {
  final String sql = "select distinct deptno from emp order by rand()";
  sql(sql).ok();
} {code}
We will get error logical plan
{code:java}
LogicalProject(DEPTNO=[$0])
  LogicalSort(sort0=[$1], dir0=[ASC])
    LogicalAggregate(group=[{0, 1}]) //rand() in group, result will be error
      LogicalProject(DEPTNO=[$7], EXPR$1=[RAND()])
        LogicalTableScan(table=[[CATALOG, SALES, EMP]])
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)