[jira] [Created] (CALCITE-5421) SqlToRel should populate corralateId for join with corralated query in HAVING condition

["James Starr (Jira)" <ji...@apache.org>]

James Starr created CALCITE-5421:
------------------------------------

             Summary: SqlToRel should populate corralateId for join with corralated query in HAVING condition
                 Key: CALCITE-5421
                 URL: https://issues.apache.org/jira/browse/CALCITE-5421
             Project: Calcite
          Issue Type: Improvement
            Reporter: James Starr
            Assignee: James Starr


{code:java}
class SqlToRelConverterTest extends SqlToRelTestBase {
  ...
  @Test void testInCorrelatedSubQueryInHavingRex() {
    final String sql = "select sum(sal) as s\n"
        + "from emp e1\n"
        + "group by deptno\n"
        + "having count(*) > 2\n"
        + "and exists(\n"
        + "  select true\n"
        + "  from emp e2\n"
        + "  where e1.deptno = e2.deptno)";
    sql(sql).withExpand(false).ok();
  }
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)