Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.3
-
None
-
None
Description
A warning is returned in this query:
mysql> SELECT TIME('00:00:00.'); |
+-------------------+ |
| TIME('00:00:00.') | |
+-------------------+ |
| 00:00:00 |
|
+-------------------+ |
1 row in set, 1 warning (1.38 sec) |
 |
mysql> show warnings;
|
+---------+------+---------------------------------------------+ |
| Level | Code | Message | |
+---------+------+---------------------------------------------+ |
| Warning | 1292 | Truncated incorrect time value: '00:00:00.' | |
+---------+------+---------------------------------------------+ |
1 row in set (0.00 sec) |
No significant information gets lost in this case, so the warning looks unnecessary.