[CALCITE-3824] JoinProjectTransposeRule should skip Projects containing windowing expression

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.23.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 26/Feb/20 00:59
• Updated: 27/Feb/24 22:23
• Resolved: 07/Mar/20 00:06

Description

This rule could push windowing expressions within join condition which doesn't make sense.

For example

select * from dept a 
     join (select rank() over (order by name) as r, 1 + 1 from dept) as b 
             on a.name = b.r

Above query produces following plan after the rule

LogicalProject(DEPTNO=[$0], NAME=[$1], R=[$3], EXPR$1=[$4])
  LogicalProject(DEPTNO=[$0], NAME=[$1], NAME0=[CAST($1):BIGINT NOT NULL], R=[RANK() OVER (ORDER BY $3 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)], EXPR$1=[+(1, 1)])
    LogicalJoin(condition=[=(CAST($1):BIGINT NOT NULL, RANK() OVER (ORDER BY $3 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW))], joinType=[inner])
      LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
      LogicalTableScan(table=[[CATALOG, SALES, DEPT]])

Issue Links

• links to: GitHub Pull Request #1830