Re: [Maria-discuss] Dynamically rewrite query

2016-04-21 Thread Erik Cederstrand
> Den 20. apr. 2016 kl. 20.15 skrev Sergei Golubchik : > > On Apr 20, Erik Cederstrand wrote: >> >> CREATE TABLE `t1` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `l` >> int(11) NOT NULL, `m` int(11) DEFAULT NULL, PRIMARY KEY >> (`i`,`j`,`l`)); >> >> CREATE TABLE `t2` ( `i` int(11) NOT NULL, `

Re: [Maria-discuss] Dynamically rewrite query

2016-04-21 Thread Erik Cederstrand
> Den 20. apr. 2016 kl. 17.07 skrev Guillaume Lefranc : > > You can use MaxScale : > https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale/maxscale-regex-filter-overview/ Ok, thanks. I'll have a look at it. Erik signature.asc Description: Message signed with OpenPGP using GPGMail ___

Re: [Maria-discuss] Dynamically rewrite query

2016-04-20 Thread Sergei Golubchik
Hi, Erik! On Apr 20, Erik Cederstrand wrote: > > CREATE TABLE `t1` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `l` > int(11) NOT NULL, `m` int(11) DEFAULT NULL, PRIMARY KEY > (`i`,`j`,`l`)); > > CREATE TABLE `t2` ( `i` int(11) NOT NULL, `k` int(11) DEFAULT NULL, > PRIMARY KEY (`i`)) ENGINE=Inn

Re: [Maria-discuss] Dynamically rewrite query

2016-04-20 Thread Colin Charles
> On 20 Apr 2016, at 22:09, Erik Cederstrand 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 >

Re: [Maria-discuss] Dynamically rewrite query

2016-04-20 Thread Guillaume Lefranc
You can use MaxScale : https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale/maxscale-regex-filter-overview/ 2016-04-20 16:09 GMT+02:00 Erik Cederstrand : > Hello list, > > I'm administering a MariaDB (10.0.23) backend used by some proprietary > software. I'm having trouble with one speci