Skip to content

Reimplement the eliminate_cross_join #4176

@jackwener

Description

@jackwener

Describe the bug
Current implementation of eliminate_cross_join is wrong.
Because it can't rearrange join order.

When original plan is

filter: a.id = b.id and a.id = c.id
  crossjoin a  (bc)
    crossjoin b c

it will become 

filter: a.id = b.id and a.id = c.id
  inner a (bc) on a.id = b.id and a.id = c.id
    crossjoin b c

I will reimplement eliminate_cross_join to resolve this problem.

To Reproduce
Steps to reproduce the behavior:

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions