[Tech Request]: Reimplement hash MARK join

[aunjgr]

Is there an existing issue for the same tech request?

• [X] I have checked the existing issues.

Does this tech request not affect user experience?

• [X] This tech request doesn't affect user experience.

What would you like to be added ?

The former hash MARK join implementation is broken and abandoned. All MARK join plans are executed by nested-loop join.

We still need a working hash MARK join.

Why is this needed ?

No response

Additional information

No response