> On 20 Apr 2016, at 22:09, Erik Cederstrand <[email protected]> wrote: > > In the meantime, is there any way I can rewrite queries like this dynamically > to remove the DISTINCT clause? MySQL 5.7 documentation mentions query rewrite > plugins, but I don't see that mentioned in MariaDB documentation. Any other > suggestions are welcome.
Query rewriting is not available in MariaDB Server up to 10.1 yet, and the current solution for this would be to use MariaDB MaxScale, which will sit between your app and the server. If you feel that query rewriting should also be in the server, I suggest you start watching this issue and even voting for it: https://jira.mariadb.org/browse/MDEV-5561 -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi
signature.asc
Description: Message signed with OpenPGP using GPGMail
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
