[Bug]: DATETIME cannot be converted to BIGINT in CAST

[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 CAST(20220101 AS datetime(0)) BETWEEN 20220101 AND -1;
Operator 'cast' with parameters [BIGINT DATETIME] 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]

int to datetime is out of conversation table. error message will be provided in 0.6

[domingozhang]

from int to datetime/date/timestamp, will be discussed in future release

[matrix-meow]

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

[daviszhen]

BIGINT 不能转 DATETIME

[daviszhen]

MO do not support the conversion BIGINT=>DATETIME base on the doc : https://doc.weixin.qq.com/sheet/e3_AdIAkQb_AEYGT3QVZBJQXqJghCjYF?scode=AJsA6gc3AA840KbtsHAAgAkgYHABU&tab=s8bwcy

We can close the issue.

[matrix-meow]

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