Re: [Maria-developers] MDEV-17359

2018-10-09 Thread jerome brauge
Hi Alexander, I've done a pull request . Regards. > -Message d'origine- > De : Alexander Barkov [mailto:b...@mariadb.com] > Envoyé : jeudi 4 octobre 2018 17:29 > À : jerome brauge > Cc : MariaDB Developers (maria-developers@lists.launchpad.net) > Objet : Re: MDEV-17359 > > Hi Jerome, > >

Re: [Maria-developers] MDEV-17359

2018-10-05 Thread Alexander Barkov
Hi Jerome, On 10/05/2018 01:21 PM, jerome brauge wrote: > Hi Alexander, > > I 've found another difference in behavior of "like" between Mariadb and > Oracle : > > Oracle : > select 'X' from dual where 1 like 10/10; > select 'X' from dual where 1 like 1.00; > select 'x' from dual where 1.000

Re: [Maria-developers] MDEV-17359

2018-10-05 Thread jerome brauge
Hi Alexander, I 've found another difference in behavior of "like" between Mariadb and Oracle : Oracle : select 'X' from dual where 1 like 10/10; select 'X' from dual where 1 like 1.00; select 'x' from dual where 1.000 like 1.00; returns 'X' and mariadb return empty result set. If numeric ty

Re: [Maria-developers] MDEV-17359

2018-10-04 Thread jerome brauge
Hi Alexander, Ok, I will do a new patch. Thanks. > -Message d'origine- > De : Alexander Barkov [mailto:b...@mariadb.com] > Envoyé : jeudi 4 octobre 2018 17:29 > À : jerome brauge > Cc : MariaDB Developers (maria-developers@lists.launchpad.net) > Objet : Re: MDEV-17359 > > Hi Jerome, > >

Re: [Maria-developers] MDEV-17359

2018-10-04 Thread Alexander Barkov
Hi Jerome, On 10/04/2018 06:11 PM, jerome brauge wrote: > Hi Alexander, > Thank you very much. > Do you think this these patches will be ready for 10.3.10 GA ? Unfortunately no. It's too late for 10.3.10. But they'll be in 10.3.11. I've pushed MDEV-17374. Now MDEV-17359 can be fixed without a

Re: [Maria-developers] MDEV-17359

2018-10-04 Thread jerome brauge
Hi Alexander, Thank you very much. Do you think this these patches will be ready for 10.3.10 GA ? Regards. > -Message d'origine- > De : Alexander Barkov [mailto:b...@mariadb.com] > Envoyé : jeudi 4 octobre 2018 16:05 > À : jerome brauge > Cc : MariaDB Developers (maria-developers@lists.la

Re: [Maria-developers] MDEV-17359

2018-10-04 Thread Alexander Barkov
Hi Jerome, Note, Oracle supports not only concatenation in the pattern, but also additive and multiplicative expressions, e.g.: SELECT 'x' FROM DUAL WHERE '100' LIKE 10*10; This kind of expressions currently also do not work. I think that in this rule: | bit_expr LIKE mysql_concatenati

Re: [Maria-developers] MDEV-17359

2018-10-03 Thread Alexander Barkov
Jerome, Can you please wait. I'll do some more analysis on the subject. On 10/04/2018 09:16 AM, Alexander Barkov wrote: > Hello Jerome, > > On 10/03/2018 05:33 PM, jerome brauge wrote: >> Hello Alexander, >> Can you review this patch for MDEV-17359 ? >> >> Best regards. >> > > > Thanks for

Re: [Maria-developers] MDEV-17359

2018-10-03 Thread Alexander Barkov
Hello Jerome, On 10/03/2018 05:33 PM, jerome brauge wrote: > Hello Alexander, > Can you review this patch for MDEV-17359 ? > > Best regards. > Thanks for you contribution! I noticed that Oracle also supports concatenation in the ESCAPE clause: SELECT 'x' FROM DUAL WHERE 'a' LIKE 'b' ESCAPE

[Maria-developers] MDEV-17359

2018-10-03 Thread jerome brauge
Hello Alexander, Can you review this patch for MDEV-17359 ? Best regards. Ce message et les pièces jointes sont confidentiels et établis à l'attention exclusive de ses destinataires. Toute utilisation ou diffusion, même partielle, non autorisée est interdite. Tout message électronique est susce