[Enhancement] refactor `Nereids Unit Test` by match-pattern

[jackwener]

Search before asking

• I had searched in the issues and found no similar issues.

Description

Currently, EliminateFilterTest directly check PlanTree by checking Memo.

Use MemoPatternMatchSupported to match result.

A example is ExtractFilterFromCrossJoinTest

• MergeFiltersTest
• EliminateLimitTest
• EliminateFilterTest
• SplitLimitTest
• FindHashConditionForJoinTest

Solution

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[reswqa]

Thanks @jackwener for creating this, I would like to try EliminateLimitTest and EliminateFilterTest.

[jackwener]

Thanks @jackwener for creating this, I would like to try EliminateLimitTest and EliminateFilterTest.

Thanks @reswqa , assigned to you

[reswqa]

Since no one else claimed remaining tasks, I'm willing to continue to close this issue completely.

BTW, I have refactored all unit tests under org.apache.doris.nereids.rules by match-pattern, not only the remaining parts in the list.