Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.5
-
None
-
None
-
None
-
debian buster
Description
If the difference between two datetime values is too large TIMEDIFF() returns the wrong value.
Example:
SELECT TIMEDIFF('2022:01:01 00:00:00', '2022:07:01 01:35:00');
This appears to be because there is an upper limit on a time value. It would be better if calling TIMEDIFF() on two datetimes that overflows this value caused an error so the wrong values are not accidently used.