Supported RIGHT and FULL JOIN with partial_merge join algorithm

Why it matters

This feature extends join algorithm capabilities by allowing RIGHT and FULL JOIN types using the partial_merge join algorithm. Previously, these join types were not supported with this algorithm. It enables users to perform more complex join operations efficiently, improving query flexibility and optimizing performance where applicable.

How to use it

To use this feature, set the join algorithm to partial_merge and use joins with ALL strictness. For example, in your session or query, run:

SET join_algorithm = 'partial_merge';

Then perform your RIGHT or FULL JOIN as needed. Note that only ALL strictness is allowed; other strictness types like ANY, SEMI, ANTI, and ASOF are not supported with this algorithm and join types.