You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
There needs to be a new join predicate structure to replace usingPredicate that describes a join using an equality relation between columns on the left and right. The new predicate, let's call this the equalityPredicate extends usingPredicate by allowing the names of the join columns on the left and right to differ.
Once this predicate exists, the following needs to happen:
the constructor for USING must be changed to use equalityPredicate
There needs to be a new join predicate structure to replace usingPredicate that describes a join using an equality relation between columns on the left and right. The new predicate, let's call this the
equalityPredicateextendsusingPredicateby allowing the names of the join columns on the left and right to differ.Once this predicate exists, the following needs to happen:
equalityPredicateequalityPredicateas well.for the purpose of EXPLAIN we can then describe the equalityPredicate using the following syntax:
ON EQUALS(left columns..., right columns...)