[Bug] udf not effected when materialized view is enabled

[MK-GAN]

Search before asking

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

Version

2.0.6

What's Wrong?

第一个图默认使用了物化视图，结果是错误的，我们定义的udf transfer_businessLine 没有生效，数据是 dim_businessline 的值 。
增加一个物化视图里没有的聚合指标 max( dim_businessline ) ，不走物化视图了， 结果就对了。

What You Expected?

correct result

How to Reproduce?

No response

Anything Else?

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

[Mryange]

may be this #32662
there were issues with the calculation order between materialized views and GROUPING SETS.

[BiteTheDDDDt]

Hi, can you test whether the query is correct when there is no grouping set?

[MK-GAN]

also incorrect without grouping set, @BiteTheDDDDt

[BiteTheDDDDt]

Can you provide a minimal reproduction method? so that we can troubleshoot the problem

[github-actions]

We're closing this issue because it hasn't been updated in a while.
If you'd like to revive this issue, please reopen it and feel free a maintainer to remove the Stale tag!