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 <sachinsetia1...@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" <s...@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 secur...@mariadb.org >> >
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
