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)