Support for Conditional Inner Joins within Semi Join Operations

[michael-mue]

Currently, Relax does not support performing conditional inner joins within semi join operations. This limits the ability to retrieve records from table A where a condition is met in both A and B, while including only columns from A. Specifically, the following types of joins are not possible within Relax:

• ⋉ A.a = B.b (B): This semi join would include rows from A that satisfy the join condition with table B, but only retain the columns from A.

While conditional outer joins are possible, this operations is currently not supported.

[rlaiola]

Hi, @michael-mue. Anyone working on this issue?

If not, I'll will try to find students interested in contributing.

Cheers!

PS: Besides the left and right semi joins, it would be also nice to add this feature to anti joins.

[michael-mue]

Hi @rlaiola,

Currently, no one is working on this. It would be great if you could let students work on it! I also agree that adding this feature to anti joins would be great.