cherry-pick fix(optimizer): fix split now or rule (#25626) to branch release-2.8

Cherry picking #25626 onto branch release-2.8, This PR/issue was created by cherry-pick action from commit 10d97e0e72f854142a29c5d43311856eb53db34f.,