You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Danny Chen (Jira)" <ji...@apache.org> on 2020/08/07 10:12:00 UTC
[jira] [Created] (CALCITE-4167) Group by COALESCE IN throws
NullPointerException
Danny Chen created CALCITE-4167:
-----------------------------------
Summary: Group by COALESCE IN throws NullPointerException
Key: CALCITE-4167
URL: https://issues.apache.org/jira/browse/CALCITE-4167
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.24.0
Reporter: Danny Chen
Assignee: Danny Chen
Fix For: 1.25.0
Added this test case in SqlToRelConverterTest:
{code:java}
@Test void testGroupByCoalesceIn() {
final String sql = "select case when coalesce(ename, 'a') in ('1', '2')\n" +
"then 'CKA' else 'QT' END, count(distinct deptno) from emp\n" +
"group by case when coalesce(ename, 'a') in ('1', '2') then 'CKA' else 'QT' END";
sql(sql).ok();
}
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)