Am 10.09.2013 16:55, schrieb Roberto Spadim: > Hi guys! > I posted the MDEV-5007 and it's a old problem from MDEV-3795 (the same > problem) > It (MDEV-3795) was closed as a not a bug, but i think it's a bug, but i > didn't explained well at the first time > > I changed from a mysql server to a mariadb server and the result order by > isn't executed, i tried > myisam,aria,innodb,memory engines and all of them return the same problem > (order by not executed) > > On the wrong query i don't see the "using filesort" at explain, and at the > right query (with right order by) it > show "using filesort" > > Could anyone help me? or at least EXPLAIN why the order by shouldn't be > executed on the first query, and maybe a > workaround using sql_optimizer variable or something like it? > > it's a closed software and i need to contact developer to change the query, > that's why i'm talking about the > sql_optimizer variable instead of rewrite the query
this is pretty clear the following and will be fixed in 5.5.33 https://mariadb.atlassian.net/browse/MDEV-4978
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
