bug: The data type of the field is time,when you insert a value,maybe return an incorrect value.

[haitaoguan]

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

create table ttt(c1 time);
insert into ttt values('-838:59:59');
insert into ttt values('838:59:59');

mysql> select * from ttt;
+------------+
| c1         |
+------------+
| -838:59:59 |
| 838:59:59  |
+------------+
2 rows in set (0.01 sec)

mysql> insert into ttt values('-839:00:00');
ERROR 1292 (22007): Incorrect time value: '-839:00:00' for column 'c1' at row 1
mysql> insert into ttt values('839:00:00');
ERROR 1292 (22007): Incorrect time value: '839:00:00' for column 'c1' at row 1

The value range is [-838:59:59,838:59:59].

insert into ttt values('31:59:59');
insert into ttt values('-31:59:59');

mysql> select * from ttt;
+------------+
| c1         |
+------------+
| -838:59:59 |
| 838:59:59  |
| 31:59:59   |
| -31:59:59  |
+------------+
4 rows in set (0.00 sec)

mysql> insert into ttt values('-32:00:00');
Query OK, 1 row affected (0.00 sec)

mysql> insert into ttt values('32:00:00');
Query OK, 1 row affected (0.00 sec)

mysql> select * from ttt;
+------------+
| c1         |
+------------+
| -838:59:59 |
| 838:59:59  |
| 31:59:59   |
| -31:59:59  |
| -56:00:00  |
| 56:00:00   |
+------------+
6 rows in set (0.00 sec)

If you insert a time value greater than '31:59:59' or less than '-31:59:59',then return an incorrect value.

Expected behavior

No response

How To Reproduce

No response

Environment

./mysqld Ver 5.7.36-StoneDB-debug 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: 562afcb
Last commit time: Date: Mon Jan 9 07:11:42 2023 +0000
Build time: Date: Mon Jan 9 17:33:31 CST 2023

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

• Yes, I will!