Re: [Maria-developers] Sachin weekly report

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 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" 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