maria-developers team mailing list archive

[jerome brauge <j.brauge@xxxxxxxxxxx>]

Hello Alexander,

We have a long history of porting our application on different database providers and each time, string functions behavior is critical to success (essentially managing nulls and empty strings).

For us, mandatory string functions that require a patch are:
 - CONCAT
 - SUBSTR
 - LENGTH
 - xTRIM
 - empty strings as nulls
 -TO_CHAR / TO_DATE

Some others can be easily translated/substituted (CHR, xPAD, REPLACE, INSTR with 3 args) and they are here only to facilitate porting task.

I can't be exhaustive because we only use a subset of oracle functions but it's the core.
With all patches that I provided, I can connect to our application and it's already a challenge !

Regards,
Jérôme.

> -----Message d'origine-----
> De : Alexander Barkov [mailto:bar@xxxxxxxxxxx]
> Envoyé : jeudi 18 mai 2017 14:32
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@xxxxxxxxxxxxxxxxxxx); Sergei
> Golubchik
> Objet : Re: MDEV-10142 - Replace function
> 
> Hello Jerome,
> 
> We're slightly worried that we can end up with creating XXX_ORACLE
> duplicates all MariaDB functions.
> 
> 
> Why did you choose a limited number of functions: REPLACE, TRIM, SUBSTR?
> What about other functions? Will you need changes in some other functions
> as well?
> 
> Thanks.
> 
> 
> On 05/12/2017 12:31 PM, jerome brauge wrote:
> > Hello Alexander,
> > Here is patch for replace function in oracle mode.
> > Do I have to add a test for replication ?
> >
> > Regards,
> > Jérôme.
> >