[SPARK-36745] ExtractEquiJoinKeys should return the original predicates on join keys

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 3.3.0
• Component/s: SQL
• Assignee: Yannis Sismanis
• Reporter: Yannis Sismanis
• Created: 13/Sep/21 18:54
• Updated: 16/Sep/21 05:18
• Resolved: 16/Sep/21 05:17

Description

The join condition returned from ExtractEquiJoinKeys does not correspond to the equi-join on the extracted left and right keys. A call site can be risky if it is not aware of that.

The pattern extractor should extract the rest of original join condition as well.

Issue Links

• links to: [Github] Pull Request #33985 (YannisSismanis)