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 2019/10/29 12:20:00 UTC
[jira] [Created] (CALCITE-3456) AssertionError throws when
aggregation has non-aggregate calls
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)