bug: insert into UNSIGNED data out of range return error, but can be quried

[davidshiz]

Have you read the Contributing Guidelines on issues?

• I have read the Contributing Guidelines on issues.

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Describe the problem

mysql> create table int_test (id int unsigned);
Query OK, 0 rows affected (0.00 sec)

mysql> insert into int_test values(2147483648);
ERROR 1264 (22003): Out of range[0, 2147483647] for column 'id' value: 2147483648

mysql> select * from int_test;
+------------+
| id         |
+------------+
| 2147483648 |
+------------+
1 row in set (0.00 sec)

tinyint smallint mediumint bigint also have this problem.

Expected behavior

No response

How To Reproduce

create table int_test (id int unsigned);
insert into int_test values(2147483648);
select * from int_test;

Environment

root@ub01:~# /stonedb57/install/bin/mysqld --version
/stonedb57/install/bin/mysqld  Ver 5.7.36-StoneDB for Linux on x86_64 (build-)
build information as follow:
        Repository address: https://github.com/stoneatom/stonedb.git:stonedb-5.7-dev
        Branch name: stonedb-5.7-dev
        Last commit ID: 1fa9d3346
        Last commit time: Date:   Fri Jan 13 07:03:20 2023 +0000
        Build time: Date: Fri Jan 13 17:22:15 CST 2023
root@ub01:~# cat /etc/issue
Ubuntu 20.04.5 LTS \n \l

Are you interested in submitting a PR to solve the problem?

• Yes, I will!