Use SortMergeJoinExec consistently in physical plan outputs
Which issue does this PR close?
#19238
Rationale for this change
SortMergeJoinExec is currently displayed inconsistently across physical plan formats, see join.slt vs. explain_tree.slt.
These examples show that the tree-fmt plan uses SortMergeJoinExec, while the indent-fmt plan uses SortMergeJoin.
Standardizing the operator name improves clarity and aligns with the naming conventions of other execution operators.
What changes are included in this PR?
Updates the DisplayAs implementation for SortMergeJoinExec to output "SortMergeJoinExec: ...".
Updates SQL Logic Test expected outputs in joins.slt to reflect the unified naming.
No functional behavior changes; this is a display/consistency fix.
Are these changes tested?
Yes. This change is encapsulated in existing SQL Logic Tests. I updated those expected outputs to match the new standardized naming.
All tests pass with the updated format.
Are there any user-facing changes?
Yes—users inspecting physical plans will now consistently see SortMergeJoinExec instead of SortMergeJoin.
cc @alamb @gabotechs : tiny but meaningful
Looks like there is a bunch more test updates that are needed here
@xavlee will you be able to finish this PR (resolve the conflicts and update the tests?)
I will complete this today, apologies for the delay.
@alamb I've rebased my changes and resolved conflicts 🙏 . You mentioned there were other tests that may also have to be updated–should I open a separate PR to address those?
@alamb I've rebased my changes and resolved conflicts 🙏 . You mentioned there were other tests that may also have to be updated–should I open a separate PR to address those?
I kicked CI so let's see if there are any tests that expect specific node names. Those would be tests that need updating. Thanks for your contribution so far!
Got it, I'll update those tests as well