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
{{ message }}
Repository navigation
Handle Non-Equal Condition in EliminateCrossJoin #7549
Current EliminateCrossJoin don't handle non-equal condition properly.
We don't need differentiate between handling equal conditions and non-equal conditions, because multi join is a Query Graph and both equal conditions and non-equal conditions are edges in Graph.
Implementation
collect all condition(non-equal and equal) and all children from Inner/Cross Join into a struct (like MultiJoin)
assign equal/non-eq condition to children to be new inner join (Prioritize handling the 'equal condition)
find other condition(eq/non-eq) which can put into this join, and add them into this join
Activity