[MDEV-4844] Redundant warning in SELECT TIME('00:00:00.'); Created: 2013-08-06  Updated: 2013-08-06  Resolved: 2013-08-06

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.3
Fix Version/s: 10.0.4

Type: Bug Priority: Minor
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: 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.



 Comments   
Comment by Alexander Barkov [ 2013-08-06 ]

The patch merging SQL standard temporal literals (from MySQL-5.6) fixed this problem.

Generated at Thu Feb 08 06:59:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.