matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: Implicit conversion failed from BIGINT to DECIMAL

Open domingozhang opened this issue 3 years ago • 3 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):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

select cast(10000002383263201056 as decimal) mod 50 as result; Operator '%' with parameters [DECIMAL64 BIGINT] will be implemented in future version.

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

domingozhang avatar Jun 23 '22 09:06 domingozhang

int64 -> decimal.

problem:

  1. decimal % decimal , no implementation in type analysis
  2. cast error in execution ==========

refresh error message. move to 0.6 .

daviszhen avatar Jun 30 '22 03:06 daviszhen

?????

-- @bvt:issue#3283 update t1 set a=a+101; select a,b from t1 order by 1; update t1 set a=27 where a=125; select a,b from t1 order by 1; update t1 set a=a-1 where 1 > 2; select a,b from t1 order by 1; update t1 set a=a-1 where 3 > 2; select a,b from t1 order by 1; -- @bvt:issue

daviszhen avatar Jun 30 '22 03:06 daviszhen

will be provided error code in 0.6

domingozhang avatar Jul 01 '22 10:07 domingozhang

截屏2022-10-29 22 16 41

tianyahui-python avatar Oct 29 '22 14:10 tianyahui-python

@domingozhang can close issue.

tianyahui-python avatar Oct 29 '22 14:10 tianyahui-python