[Bug]: Aggregate function variance data type errors
Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
Environment
- Version or commit-id (e.g. v0.1.0 or 8b23a93): 6dedae20180c9e7ad4159ef0c7ad0f8e8c358dee
- Hardware parameters: MAC M1 ARM 16GB
- OS type: OSX
- Others:
Actual Behavior
Function 'variance' with parameters [unexpected type: 0] will be implemented in future version. Function 'variance' with parameters [DECIMAL128] will be implemented in future version. Function 'variance' with parameters [DATE] will be implemented in future version. Function 'variance' with parameters [DATETIME] will be implemented in future version. Function 'variance' with parameters [TIMESTAMP] will be implemented in future version. Function 'variance' with parameters [VARCHAR] will be implemented in future version.
Expected Behavior
No response
Steps to Reproduce
No response
Additional information
No response
Do not support date,datetime,timestamp in: Function 'variance' with parameters [DATE] will be implemented in future version. Function 'variance' with parameters [DATETIME] will be implemented in future version. Function 'variance' with parameters [TIMESTAMP] will be implemented in future version.
Do not support implicit conversion decimal => float,varchar => float in aggregation: Function 'variance' with parameters [DECIMAL128] will be implemented in future version. Function 'variance' with parameters [VARCHAR] will be implemented in future version.
should solve: Function 'variance' with parameters [unexpected type: 0] will be implemented in future version.
@m-schen says that the implicit conversion will not happen in the aggregation function.