Bug #35288 SEC_TO_TIME Does'nt return large hour format

• Submitted: 14 Mar 2008 11:47
• Modified: 14 Mar 2008 15:17
• Reporter: Alexander Wahl
• Status: Can't repeat
• Category: MySQL Server: Data Types
• Severity: S2 (Serious)
• Version: 5.0.32-Debian_7etch5-log
• OS: Linux (Debian 2.6.18-6-686)
• CPU Architecture: Any
• Tags: 838:59:59, HHH:MM:SS, SEC_TO_TIME, time, type

[14 Mar 2008 11:47] Alexander Wahl

Description:
SEC_TO_TIME function should return a TIME type.
Large hours format is ignored!

MySQL 5.0.32-Debian_7etch5-log
------------------------------
select sec_to_time(25*3600);
 -> 01:00:00

MySQL 4.1.22-standard
------------------------------
select sec_to_time(25*3600);
 -> 25:00:00

How to repeat:
select sec_to_time(25*3600);

[14 Mar 2008 15:17] MySQL Verification Team

Thank you for the bug report. I wasn't able to repeat with latest released
version on Windows and current source server on Linux. Could you please
upgrade to latest released version?. Thanks in advance.

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select sec_to_time(25*3600);
+----------------------+
| sec_to_time(25*3600) |
+----------------------+
| 25:00:00             |
+----------------------+
1 row in set (0.00 sec)

mysql>

[miguel@mira dbs]$ 5.0/bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.58-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select sec_to_time(25*3600);
+----------------------+
| sec_to_time(25*3600) |
+----------------------+
| 25:00:00             | 
+----------------------+
1 row in set (0.01 sec)

mysql>