There is an ugly bug in MySQL 5.0.67.
I don’t know if this bug occurs in newer versions of MySQL, older versions are not affected!
When the following code is executed, the complete MySQL Server crashes with an error code 11:
SELECT DATE_FORMAT("0000-01-01",'%W %d %M %Y') AS `currentdate`;
SELECT DATE_FORMAT("0000-02-28",'%W %d %M %Y') AS `currentdatafull`;
You can replace the date used in the DATE_FORMAT() function with any date between 0000-01-01 and 0000-02-28.
MySQL is working on a solution right now, the bug has been labeled as critical so a fix should be on the way fast.
The bug report itself cannot be viewed be everyone, because of the severity of the bug!
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
Hey Buddy,
I tested it on Mysql 5.0.32-Debian_7etch8 as root and nothing happened
Regards,
Benjamin
Hi Benjamin,
Earlier versions of MySQL are not affected, so it is correct that nothing happens
MySQL: Crash your complete server with DATE_FORMAT()…
Nasty bug that makes your MySQL server crash!…