Hello Sergei,

I am getting one problem related to my_strcasecmp() function currently this function does not allow 

string comparison upto length l, is there any functon which can do comparison upto length l, or should i 

write mine.

Regards

sachin

On Fri, Jul 22, 2016 at 9:56 PM, Sachin Setia <sachinsetia1001@gmail.com> wrote:

Hello Sergei,

I have one problem my where optimization works for  query like

select * from t1 where abc=1;

but in query like 

select * from t1 where abc=(select xyz from t2 where xyz=1);

does not work because in these query the charset is different from what used in 

t1 for inserting data and hence generation different hash for same data

how i solve this problem. 

Regards 

sachin

On Tue, Jul 19, 2016 at 5:52 PM, Sachin Setia <sachinsetia1001@gmail.com> wrote:

Just give me 3 days after you can review. yes I already merged with 10.2.1 days ago.  
regards
Sachin

On Jul 19, 2016 17:28, "Sergei Golubchik" <serg@mariadb.org> wrote:

Hi, Sachin!

On Jul 19, Sachin Setia wrote:
> Weekly Report for 8 week of gsoc
>
> 1 Changed the key flags as suggested by you.

okay

> 2 Now update will use only one buffer as suggested by you but there was one
> problem some time offset can be
> negative so i changed the field cmp_offset parameter from uint to long

sure

> 3 Still working on coding conventions.
>
> 4 I have made prototype for optimizing where for keys like unique(a) , it
> is on branch
> https://github.com/SachinSetiya/server/tree/unique_index_where
>
> Currently I am working on muliple keys like unique(a,b,c) i think this
> should take 2-3 days  and edits suggested by you.

sounds good.
did you merge with 10.2.1?

tell me when you'd want me to do another review.

Regards,
Sergei
Chief Architect MariaDB
and security@mariadb.org