Danny Chen created CALCITE-3456: ----------------------------------- Summary: AssertionError throws when aggregation has non-aggregate calls Key: CALCITE-3456 URL: https://issues.apache.org/jira/browse/CALCITE-3456 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.21.0 Reporter: Danny Chen Assignee: Danny Chen Fix For: 1.22.0
Check this sql in SqlToRelConverterTest: {code:java} @Test public void testAggregateWithCaseWhen() { final String sql = "select\n" + " CASE WHEN job IN ('810000', '820000') THEN job\n" + " ELSE 'error'\n" + " END AS id,\n" + " count(empno)\n" + "FROM emp\n" + "where job <> '' or job in ('810000', '820000')\n" + "GROUP by deptno, job"; sql(sql).ok(); } {code} I tested PostgreSQL 9.6 and MySQL 5.6, this is a valid SQL and they both outputs the right result. -- This message was sent by Atlassian Jira (v8.3.4#803005)