You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Scott Reynolds (Jira)" <ji...@apache.org> on 2022/11/18 23:12:00 UTC

[jira] [Created] (CALCITE-5391) JoinOnUniqueToSemiJoinRule removes a Projections aliases

Scott Reynolds created CALCITE-5391:
---------------------------------------

             Summary: JoinOnUniqueToSemiJoinRule removes a Projections aliases
                 Key: CALCITE-5391
                 URL: https://issues.apache.org/jira/browse/CALCITE-5391
             Project: Calcite
          Issue Type: Bug
    Affects Versions: 1.32.0
            Reporter: Scott Reynolds
            Assignee: Scott Reynolds


The new rule pushes a copy of the [original project without the alias names|https://github.com/apache/calcite/pull/2848/files#r1026959819] 

{code:java}
builder.project(project.getProjects());
{code}

This results in a new SQL plan without the name fields -- they become {{$fN}} fields in different plans. 

Small change is required to put the names from the {{RelDataType}} of the {{Project}} similar to the other {{Semijoin}} rule.



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