Skip to content

Transform OuterJoins to AntiJoins, if possible #208

@jungmair

Description

@jungmair

Sometimes a combination of outerjoin and "outer column is null" check is used to implement antijoins in SQL, for example in TPC-DS Q78:

Image

One could just extend the existing logic for turning outerjoin + is not null into InnerJoin:

if (isNotNullCheckOnColumn(outerJoinOp.getCreatedColumns(), selectionOp)) {

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions