[CALCITE-5391] JoinOnUniqueToSemiJoinRule should preserve field names, if possible

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.32.0
• Fix Version/s: 1.33.0
• Labels: pull-request-available
• Assignee: Scott Reynolds
• Reporter: Scott Reynolds
• Created: 18/Nov/22 23:11
• Updated: 07/Feb/23 22:33
• Resolved: 26/Nov/22 14:52

Description

The new rule pushes a copy of the original project without the alias names 

builder.project(project.getProjects());

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.

Issue Links

• is related to: CALCITE-5201 Improve SemiJoinRule to match Join's right input which is unique for Join keys
• relates to: CALCITE-1584 ProjectRemoveRule loses field names
• links to: GitHub Pull Request #2975