[jira] [Created] (CALCITE-5045) Alias within GroupingSets throws type mis-match exception

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

yanjing.wang created CALCITE-5045:
-------------------------------------

             Summary: Alias within GroupingSets throws type mis-match exception
                 Key: CALCITE-5045
                 URL: https://issues.apache.org/jira/browse/CALCITE-5045
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.29.0
         Environment: jdk8
            Reporter: yanjing.wang
            Assignee: yanjing.wang
             Fix For: 1.31.0


{noformat}
@Test void testAliasWithinGroupingSets() {
  final String sql = "SELECT empno / 2 AS x\n"
      + "FROM emp\n"
      + "GROUP BY ROLLUP(x)";
  sql(sql)
      .withConformance(SqlConformanceEnum.LENIENT)
      .ok();
}{noformat}
the above test throws
{noformat}
Conversion to relational algebra failed to preserve datatypes:
validated type:
RecordType(INTEGER NOT NULL X) NOT NULL
converted type:
RecordType(INTEGER X) NOT NULL{noformat}
The X has lost its NOT NULL constraints.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)