-
Notifications
You must be signed in to change notification settings - Fork 52
Open
Labels
Description
Sometimes a combination of outerjoin and "outer column is null" check is used to implement antijoins in SQL, for example in TPC-DS Q78:
One could just extend the existing logic for turning outerjoin + is not null into InnerJoin:
| if (isNotNullCheckOnColumn(outerJoinOp.getCreatedColumns(), selectionOp)) { |