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
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.**ziphttps://www.dropbox.com/s/m02sqjl2y2cq4ky/sampledump1.zip
The query, and the results (and explains) in both MySQL and MariaDB:
https://gist.github.com/**jamiejackson/6829118https://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.jspahttps://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-**discusshttps://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.**net
Unsubscribe : https://launchpad.net/~maria-**discusshttps://launchpad.net/~maria-discuss More help : https://help.launchpad.net/**ListHelphttps://help.launchpad.net/ListHelp