[SqueakDBX] Link complains about ilike:

[Alan Knight]

Yes, I think creating ilike: is the easiest solution.

On 2010-11-19 12:08 PM, Mariano Martinez Peck wrote:
>
>
> On Thu, Nov 11, 2010 at 9:04 PM, Alan Knight <knight at acm.org 
> <mailto:knight at acm.org>> wrote:
>
>     On 2010-11-10 11:35 PM, Mariano Martinez Peck wrote:
>>
>>
>>     On Thu, Nov 11, 2010 at 1:24 AM, Panu Suominen
>>     <panu.suominen at iki.fi <mailto:panu.suominen at iki.fi>> wrote:
>>
>>         2010/11/11 Mariano Martinez Peck <marianopeck at gmail.com
>>         <mailto:marianopeck at gmail.com>>:
>>         > Hi Panu. Thanks for finding this bug. It seems a typo. Can
>>         you try chaning
>>         > it to #like:  instead of #ilike:  and see if the test works?
>>
>>         But that changes semantics. readManyOf: Something where: [:a
>>         | a name
>>         like: '%bob%']
>>         probably does not return any "Bob". However  [:a | a name ilike:
>>         '%bob%'] should return.
>>
>>     Sorry. I was not aware of the ILIKE SQL keyboard. Seems to be
>>     used only in PostgreSQL.
>>     And now I read the method  RelationExpression >> operationFor:
>>     aSymbol
>>
>>     So....you are right. We should implement #ilike:   similar to
>>     #like:  but  being case insensitive.
>>
>>     However, if you check #ilike:  it is case insensitive too. Read
>>     the comment of method String >> match:
>>
>>     I am confused what we should do.
>>
>>     mariano
>     I have an idea that whether or not LIKE is case sensitive will
>     vary by database, so there's no way we could match that in
>     Smalltalk. I'd be inclined to have the Smalltalk implementation of
>     both just be case insensitive and if someone really wants a case
>     sensitive match then they won't have exact polymorphism between
>     the image code and the database, but they wouldn't anyway if it
>     varies by database.
>     ç
>
>
> Alan: I agree, the problem is that right now, it is mapped to #ilike:  
> wich doesn't exist in Pharo. So....we need to implement #ilike:  or 
> change the mapping to other method.
>
>     -- 
>     Alan Knight [|], Engineering Manager, Cincom Smalltalk
>     knight at acm.org  <mailto:knight at acm.org>
>     aknight at cincom.com  <mailto:aknight at cincom.com>
>     http://www.cincom.com/smalltalk
>
>
>     _______________________________________________
>     SqueakDBX mailing list
>     SqueakDBX at lists.squeakfoundation.org
>     <mailto:SqueakDBX at lists.squeakfoundation.org>
>     http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>
>

-- 
Alan Knight [|], Engineering Manager, Cincom Smalltalk
knight at acm.org
aknight at cincom.com
http://www.cincom.com/smalltalk

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20101119/a42d03a2/attachment.htm