MySQL Bugs: #31589: Fatigued student finds SEC_TO

Bug #31589	Fatigued student finds SEC_TO_TIME flaw that does not exist.
Submitted:	14 Oct 2007 17:31	Modified:	14 Oct 2007 18:02
Reporter:	Chris Beck	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Websites: bugs.mysql.com	Severity:	S5 (Performance)
Version:	Ver 14.14 Distrib 5.1.21-beta	OS:	MacOS
Assigned to:		CPU Architecture:	Any
Tags:	Invalid response, LIES, SEC_TO_TIME

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
SELECT SEC_TO_TIME(506)

returns 08:26, should be 08:43

How to repeat:
mysql> select sec_to_time(506);
+------------------+
| sec_to_time(506) |
+------------------+
| 00:08:26         | 
+------------------+

Sorry, but why do you think it should be 8:43? 506 = 60*8 + 26, so it is 8 minutes and 26 seconds...

Appologies.