MySQL Bugs: #37441: Bad return result in function maketime or sec_to

Bug #37441	Bad return result in function maketime or sec_to_time
Submitted:	17 Jun 2008 7:27	Modified:	17 Jun 2008 14:02
Reporter:	Stanislav Mozola	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.66, 5.1.22-rc-community; 6.0.4 -alpha	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	maketime, SEC_TO_TIME

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Wrong time is returning from selects. There is a Maximum time limit .

I refer to Bug #11655.

How to repeat:
SELECT MAKETIME(916,0,0);
return: 838:59:59

select sec_to_time(3020400);
return: 838:59:59

In version 5.0.22 debian this selects are correct.
SELECT MAKETIME(916,0,0);
return: 916:00:00

Many thanks for writing a bug report.

This is not a bug. Please read: http://dev.mysql.com/doc/refman/5.0/en/time.html

Consider here, that the bug was that in older versions sometimes time could get higher then 838:59:59.