Re: [Maria-developers] [Commits] 55a4858fe6f: MDEV-12666: CURRENT_ROLE() does not work in a view

2017-05-23 Thread Alexander Barkov
Hi Vicentiu, It seems that Item_func_sysconst abuses const_charset_converter(). I have the following proposals: - Instead of adding a new code into Item::const_charset_converter(), can you please override Item_func_sysconst::safe_charset_converter()? The direction proposed by Sergei's looks go

Re: [Maria-developers] MDEV-10142 - Replace function

2017-05-23 Thread Alexander Barkov
Hello Jerome, On 05/18/2017 05:51 PM, jerome brauge wrote: 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 str

Re: [Maria-developers] MDEV-10142 - Replace function

2017-05-23 Thread jerome brauge
Hi Alexander, Our application logic is fully written in PL/SQL. We have near of 13 millions lines of PL/SQL code and if we want challenge Oracle , performance will be a critical point. >From my point of view, using UDF for low level function like these will cause >too big overhead. Regards, Jérô

Re: [Maria-developers] Oracle compatibility : Update with same source and target

2017-05-23 Thread Alexander Barkov
Hi Jerome, On 05/19/2017 07:04 PM, jerome brauge wrote: > Hi Alexander, > > Here is an example : > > use test; > set sql_mode=oracle; > DROP TABLE if exists t1; > CREATE TABLE t1 (c1 INT, c2 INT); > update t1 >set c1=1 > where c2 = (SELECT b.c2 FROM t1 b WHERE b.c1=0); > > --> ERROR 1093

[Maria-developers] 10.2 and merges (e.g. TokuDB)

2017-05-23 Thread Phil Sweeney
Hi there, It seems 10.2.6 is still shipping with TokuDB from PS 5.6.35-80 (Feb 8th 2017). I can't see a jira issue for a 10.2 merge since 10.2.4. Perhaps intentional to help stabilise 10.2 for release? 10.0.30 also shipped with the same Feb version (in March). 10.1.23 however was released in Ma

Re: [Maria-developers] 10.2 and merges (e.g. TokuDB)

2017-05-23 Thread Sergei Golubchik
Hi, Phil! On May 24, Phil Sweeney wrote: > > I'm waiting on a fairly important row count fix that should appear in > the next Percona Server release. > > When it does, if the current merging strategy continues, do I have to > first wait for 10.0.32 to get it in late July, then 10.1.26 in August,