matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: non existent implicit conversion rules

Open daviszhen 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):5bc46ebe8cb3ade55d562bcb68e00d3cfc5a7889
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

there are no such implicit conversion: decimal,DATE,datetime,timestamp => double Function 'from_unixtime' with parameters [DECIMAL128] will be implemented in future version.

Function 'sin' with parameters [TIMESTAMP] will be implemented in future version. Function 'sin' with parameters [DATETIME] will be implemented in future version. Function 'sin' with parameters [DATE] will be implemented in future version. Function 'sin' with parameters [DECIMAL128] will be implemented in future version. Function 'log' with parameters [DECIMAL128] will be implemented in future version. Function 'log' with parameters [BIGINT BIGINT] will be implemented in future version. Operator 'cast' with parameters [DOUBLE DATE] will be implemented in future version. Function 'abs' with parameters [BOOL] will be implemented in future version. Function 'if' with parameters [BIGINT unexpected type: 0 VARCHAR] will be implemented in future version. Function 'if' with parameters [BIGINT unexpected type: 0 VARCHAR] will be implemented in future version. Function 'if' with parameters [BIGINT VARCHAR unexpected type: 0] will be implemented in future version. Function 'if' with parameters [BIGINT VARCHAR unexpected type: 0] will be implemented in future version. Function 'if' with parameters [BIGINT BIGINT UNSIGNED BIGINT] will be implemented in future version. Function 'if' with parameters [BIGINT BIGINT UNSIGNED BIGINT UNSIGNED] will be implemented in future version. Function 'if' with parameters [INT DOUBLE DOUBLE] will be implemented in future version. Function 'if' with parameters [BIGINT VARCHAR VARCHAR] will be implemented in future version. Function 'if' with parameters [INT BIGINT INT] will be implemented in future version. Function 'if' with parameters [BIGINT BIGINT UNSIGNED BIGINT] will be implemented in future version. Operator 'and' with parameters [BOOL INT] will be implemented in future version. Operator 'and' with parameters [INT BOOL] will be implemented in future version. Function 'weekday' with parameters [TINYINT] will be implemented in future version. Function 'weekday' with parameters [DOUBLE] will be implemented in future version. Function 'weekday' with parameters [BIGINT] will be implemented in future version. Function 'weekday' with parameters [BIGINT] will be implemented in future version. Function 'weekday' with parameters [DOUBLE] will be implemented in future version. Function 'weekday' with parameters [BIGINT] will be implemented in future version. Function 'weekday' with parameters [BOOL] will be implemented in future version.

Function 'weekday' with parameters [BOOL] will be implemented in future version. Function 'weekday' with parameters [BIGINT] will be implemented in future version. Function 'weekday' with parameters [DOUBLE] will be implemented in future version. Function 'weekday' with parameters [BIGINT] will be implemented in future version. Function 'weekday' with parameters [BIGINT] will be implemented in future version. Function 'weekday' with parameters [DOUBLE] will be implemented in future version. Function 'weekday' with parameters [TINYINT] will be implemented in future version.

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

daviszhen avatar Jul 01 '22 01:07 daviszhen

same as #3614

daviszhen avatar Jul 01 '22 09:07 daviszhen

ok for 0.6. Needs a consistent error message for those conversions we will never support.

dengn avatar Jul 04 '22 04:07 dengn

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

matrix-meow avatar Oct 24 '22 12:10 matrix-meow

some tags need to cleaned.

daviszhen avatar Nov 09 '22 12:11 daviszhen

need to confirm this issue next week

aressu1985 avatar Dec 03 '22 08:12 aressu1985

fixed, all the bvt issue tag has been removed

aressu1985 avatar Dec 16 '22 02:12 aressu1985