Revert "fix unnecessary merge scope in broadcast join (#17778)" #14833

Job	Run time
CHECK PR VALID	3s
Matrixone CI / UT Test on Ubuntu/x86	31m 46s
Matrixone Standlone CI / e2e BVT Test on Linux/x64(LAUNCH,Optimistic)	36m 17s
Matrixone Standlone CI / e2e BVT Test on Linux/x64(LAUNCH, PESSIMISTIC)	20m 31s
Matrixone Standlone CI / Multi-CN e2e BVT Test on Linux/x64(LAUNCH, PROXY)	22m 48s
Matrixone CI / SCA Test on Ubuntu/x86	9m 8s
Matrixone CI / UT Test on Darwin/x86	40m 40s
Matrixone Upgrade CI / Compatibility Test With Release on Linux/x64(LAUNCH)	46m 18s
Matrixone Upgrade CI / Compatibility Test With Target on Linux/x64(LAUNCH)	50m 29s
Matrixone Utils CI / check_organization_user	4s
Matrixone Compose CI / multi cn e2e bvt test docker compose(Optimistic/PUSH)	17m 56s
Matrixone Compose CI / multi cn e2e bvt test docker compose(PESSIMISTIC)	24m 41s
Matrixone Utils CI / pr-size-label	4s
Matrixone Utils CI / PR Unit Test Coverage	3m 58s
Matrixone Utils CI / docu_issue_check	0s
	5h 4m 43s

Provide feedback