[Bug]: Function 'avg' with parameters DATE failed

[domingozhang]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

select min(big),avg(big),count(big)+1 from t1 group by big;
Function 'avg' with parameters [DATE] will be implemented in future version.

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

[JinHai-CN]

A proper error message should be given.

[domingozhang]

need an error code in 0.6

[domingozhang]

avg will not support date because int cannot be converted from date in mo.

[matrix-meow]

Hello @domingozhang. The bug issue in the BVT test code has not been removed,issues automatically open.

[daviszhen]

MO do not support the conversion DATE in the function AVG base on the doc : https://doc.weixin.qq.com/doc/w3_AAgAkgYHABUU6Y7hl0PQEuM6Tjv31?scode=AJsA6gc3AA8SOwl4g8AAgAkgYHABU

We can close the issue.