maria-developers team mailing list archive

[Sachin Setia <sachinsetia1001@xxxxxxxxx>]

Actually  i find that my_strnncoll  wil work :)
Regards
sachin

On Mon, Jul 25, 2016 at 1:17 AM, Sachin Setia <sachinsetia1001@xxxxxxxxx>
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 <sachinsetia1001@xxxxxxxxx>
> 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@xxxxxxxxx>
>> 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@xxxxxxxxxxx> 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@xxxxxxxxxxx
>>>>
>>>
>>
>