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 <ele...@montyprogram.com>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@lists.launchpad.net> >> Unsubscribe : >> https://launchpad.net/~maria-**discuss<https://launchpad.net/~maria-discuss> >> More help : >> https://help.launchpad.net/**ListHelp<https://help.launchpad.net/ListHelp> >> >>
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
