Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
10.0.3, 5.5.32, 5.3.12
-
None
-
None
Description
There is some inconsistency between
MAKETIME(0,0, negative_integer_number) and
MAKETIME(0,0, negative_decimal_number)
SELECT MAKETIME(0,0,-1), MAKETIME(0, 0, -0.1);
|
+------------------+----------------------+
|
| MAKETIME(0,0,-1) | MAKETIME(0, 0, -0.1) |
|
+------------------+----------------------+
|
| NULL | 00:00:00 |
|
+------------------+----------------------+
|
The expression with the negative decimal number should also return NULL.
MySQL-5.5 exhibits the same behaviour.
MySQL-5.6 returns NULL for both expressions.