maria-discuss team mailing list archive

[Elena Stepanova <elenst@xxxxxxxxxxxxxxxx>]

Hi Jamie,

On 10/4/2013 9:39 PM, Jamie Jackson wrote:
> 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?

Yes, please file a bug at 
https://mariadb.atlassian.net/secure/Dashboard.jspa. We have a few bugs 
with wrong results currently in work, but I can't find right away any 
that matches your scenario.

As a workaround, please try
set optimizer_switch='derived_merge=off';

Regards,
Elena

> Thanks,
> Jamie
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp