[SPARK-47810] Replace equivalent expression to <=> in join condition for

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Mingliang Zhu
• Reporter: Mingliang Zhu
• Created: 11/Apr/24 07:01
• Updated: 18/Apr/24 01:58
• Resolved: 18/Apr/24 01:58

Description

Replaces `t1.id is null and t2.id is null or t1.id = t2.id` to `t1.id <=> t2.id` in join condition for better performance.

Issue Links

• links to: GitHub Pull Request #45999