Bug #46726 DAYNAME() kills the database connection if the year is 0000
Submitted: 14 Aug 2009 15:44 Modified: 14 Sep 2009 16:50
Reporter: Michael Boyd Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.0.67 OS:Any
Assigned to: CPU Architecture:Any
Tags: dayname, year 0000

[14 Aug 2009 15:44] Michael Boyd
DAYNAME kills the database connection if the year is 0000

How to repeat:
SELECT DAYNAME( '0000-01-01' ) AS `day`
[14 Aug 2009 16:00] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior. Please indicate accurate version of MySQL package you use and operating system.
[14 Aug 2009 16:32] Michael Boyd
Added accurate version (5.0.67). I have this problem on both Linux and Windows Vista.
[14 Aug 2009 16:50] Sveta Smirnova
Thank you for the feedback.

But version 5.0.67 is old and many bugs were fixed since. Please try with current version 5.0.84 and inform us about results.
[14 Sep 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".