matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: Aggregate function variance data type errors

Open dengn opened this issue 3 years ago • 2 comments

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

dengn avatar Jun 24 '22 15:06 dengn

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.

daviszhen avatar Jun 30 '22 09:06 daviszhen

@m-schen says that the implicit conversion will not happen in the aggregation function.

daviszhen avatar Jul 02 '22 06:07 daviszhen