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.


  1. [...] analyzes and Scaling. Proven Scaling is well known for contributing SHOW PROFILE patch and gets bug fixed for their [...]

  2. [...] 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