Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Today, planner might use a different key sets when generate hash-to-random exchange operator for a join's left and right side.
For instance, if we have join condition :
L1 = R1 and L2 = R2,
Planner may generate a plan where the join's left side is hash distributed using L1, while the right side is hash distributed using (R1, R2). Such plan is not valid, since it would produce wrong query result.
To do that, we need make sure the planner will use the same set of keys when ask for hash distribution for a join's left and right side.