Re: [Maria-developers] Sachin weekly report
Actually i find that my_strnncoll wil work :) Regards sachin On Mon, Jul 25, 2016 at 1:17 AM, Sachin Setia wrote: > 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 > 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 >> 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 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
Re: [Maria-developers] Sachin weekly report
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 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 > 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 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