Add mv case from fe ut

[BBB-source]

Proposed changes

add some mv case from fe ut MaterializedViewFunctionTest

Problem summary

Describe your changes.

Checklist(Required)

• [ ] Does it affect the original behavior
• [ ] Has unit tests been added
• [ ] Has document been added or modified
• [ ] Does it need to update dependencies
• [ ] Is this PR support rollback (If NO, please explain WHY)

Further comments

If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...