calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Danny Chen (Jira)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-3456) AssertionError throws when aggregation has non-aggregate calls
Date Tue, 29 Oct 2019 12:20:00 GMT
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)

Mime
View raw message