[CALCITE-5045] Alias within GroupingSets throws type mis-match exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.29.0
• Fix Version/s: 1.31.0
• Component/s: core
• Labels: pull-request-available

Environment

jdk8

• Assignee: yanjing.wang
• Reporter: yanjing.wang
• Created: 15/Mar/22 12:30
• Updated: 03/Aug/22 16:21
• Resolved: 28/Jun/22 07:23

Description

@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();
}

the above test throws

Conversion to relational algebra failed to preserve datatypes:
validated type:
RecordType(INTEGER NOT NULL X) NOT NULL
converted type:
RecordType(INTEGER X) NOT NULL

The X has lost its NOT NULL constraints.

Issue Links

• is blocked by: CALCITE-4512 GROUP BY expression with argument name same with SELECT field and alias causes validation error
• is related to: CALCITE-5145 CASE statement within GROUPING SETS throws type mis-match exception
• links to: GitHub Pull Request #2838