matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: set BIGINT UNSIGNED max value, select result abnormal.

Open tianyahui-python opened this issue 3 years ago • 0 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

set @maxint=18446744073709551615;

select @maxint;

+---------+ | @maxint | +---------+ | -1 | +---------+

Expected Behavior

set @maxint=18446744073709551615;

select @maxint;

mysql> select @maxint; +----------------------+ | @maxint | +----------------------+ | 18446744073709551615 | +----------------------+

Steps to Reproduce

No response

Additional information

No response

tianyahui-python avatar Aug 15 '22 08:08 tianyahui-python