ref or null join type crash and patch
While working with a client we found a query that can crash MySQL. It has to do with ref_or_null outer joins where the table contains a null value. MySQL fails to tell the storage engine to initialize the index before reading from it. It crashes when used with MyISAM tables but it could result in an incorrect key file for table error with other storage engines. You can find the test case and patch in bug #34945. I’ve waited to blog about it until MySQL approved my patch. As of this writing my patch has been approved and committed for release in 5.0.60.
2 Responses to “ref or null join type crash and patch”
MySQL and Sun - Oportunity for smaller companies ? | MySQL Performance Blog - March 26, 2008
[...] analyzes and Scaling. Proven Scaling is well known for contributing SHOW PROFILE patch and gets bug fixed for their [...]
Eric Bergen » Innodb handler_delete and handler_update status - March 26, 2008
[...] Eric Bergen You will probably want some waders, a pick axe, and one of those hats with a light on it before you go in here. « ref or null join type crash and patch [...]
Leave a Reply