[
https://issues.apache.org/jira/browse/CALCITE-5045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17549486#comment-17549486
]
Andrei Sereda commented on CALCITE-5045:
----------------------------------------
Hello,
Please let me know if you want this issue to be included in the next Calcite
release 1.31.
If so, do you think it can be resolved in 1-2 weeks ?
Our goal is to create an RC mid-June.
Thanks.
> 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
> Priority: Major
> 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.7#820007)
