maria-discuss team mailing list archive

[Jamie Jackson <jamiejaxon@xxxxxxxxx>]

Hi Elena,

That switch does yield the correct results.

I've filed a bug: https://mariadb.atlassian.net/browse/MDEV-5107

Thanks,
Jamie


On Fri, Oct 4, 2013 at 4:45 PM, Elena Stepanova <elenst@xxxxxxxxxxxxxxxx>wrote:

> 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<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<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<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<https://launchpad.net/~maria-discuss>
>> Post to     : maria-discuss@lists.launchpad.**net<maria-discuss@xxxxxxxxxxxxxxxxxxx>
>> Unsubscribe : https://launchpad.net/~maria-**discuss<https://launchpad.net/~maria-discuss>
>> More help   : https://help.launchpad.net/**ListHelp<https://help.launchpad.net/ListHelp>
>>
>>