Incompatible query results by CAST('-787360724' AS TIME)

[sayJason]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (c1 TINYINT(1) UNSIGNED NOT NULL );
INSERT INTO t1 VALUES (0);
SELECT c1>=CAST('-787360724' AS TIME) FROM t1; -- actual: {0}, expected: {1}

2. What did you expect to see? (Required)

SELECT returns {1}

3. What did you see instead (Required)

SELECT returns {0}

4. What is your TiDB version? (Required)

Release Version: v7.2.0
Edition: Community
Git Commit Hash: 9fd5f4a
Git Branch: heads/refs/tags/v7.2.0
UTC Build Time: 2023-06-27 15:04:42
GoVersion: go1.20.5
Race Enabled: false
Check Table Before Drop: false
Store: tikv

[hawkingrei]

@sayJason Hello! I noticed that you have recently discovered many bugs in TiDB. Have you developed a fuzzing tool to find these issues?

[sayJason]

@sayJason Hello! I noticed that you have recently discovered many bugs in TiDB. Have you developed a fuzzing tool to find these issues?

Yes. Our work is still under research and unpublished. Once it is released, I'll be very pleased to share all details.

[hawkingrei]

@sayJason Hello! I noticed that you have recently discovered many bugs in TiDB. Have you developed a fuzzing tool to find these issues?

Yes. Our work is still under research and unpublished. Once it is released, I'll be very pleased to share all details.

We are looking forward to your paper. If it gets published, please let us know as soon as possible. If you have any questions, feel free to ask us.

[sayJason]

@sayJason Hello! I noticed that you have recently discovered many bugs in TiDB. Have you developed a fuzzing tool to find these issues?

Yes. Our work is still under research and unpublished. Once it is released, I'll be very pleased to share all details.

We are looking forward to your paper. If it gets published, please let us know as soon as possible. If you have any questions, feel free to ask us.

Thanks for your attention.