← Back to team overview

maria-discuss team mailing list archive

Left Join Bug?

 

Hi Folks,

I'm seeing a difference in a query result between MariaDB 5.5.32 and MySQL
5.1.69.

I've distilled things down as far as I can get them, while still being able
to reproduce the issue. Anything else I do to get the sample to make it
smaller or more focused seems to make the issue disappear.

The data: https://www.dropbox.com/s/m02sqjl2y2cq4ky/sampledump1.zip

The query, and the results (and explains) in both MySQL and MariaDB:

https://gist.github.com/jamiejackson/6829118

What's going on here? Is there an oustanding bug for this? Should I file a
bug?

Thanks,
Jamie

Follow ups