<br><br><div class="gmail_quote">On Thu, Nov 11, 2010 at 9:04 PM, Alan Knight <span dir="ltr"><<a href="mailto:knight@acm.org">knight@acm.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000"><div class="im">
On 2010-11-10 11:35 PM, Mariano Martinez Peck wrote:
<blockquote type="cite"><br>
<br>
<div class="gmail_quote">On Thu, Nov 11, 2010 at 1:24 AM, Panu
Suominen <span dir="ltr"><<a href="mailto:panu.suominen@iki.fi" target="_blank">panu.suominen@iki.fi</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
2010/11/11 Mariano Martinez Peck <<a href="mailto:marianopeck@gmail.com" target="_blank">marianopeck@gmail.com</a>>:<br>
<div>> Hi Panu. Thanks for finding this bug. It
seems a typo. Can you try chaning<br>
> it to #like: instead of #ilike: and see if the test
works?<br>
<br>
</div>
But that changes semantics. readManyOf: Something where: [:a |
a name<br>
like: '%bob%']<br>
probably does not return any "Bob". However [:a | a name
ilike:<br>
'%bob%'] should return.<br>
<font color="#888888"><br>
</font></blockquote>
<div>Sorry. I was not aware of the ILIKE SQL keyboard. Seems to
be used only in PostgreSQL.<br>
And now I read the method RelationExpression >>
operationFor: aSymbol<br>
<br>
So....you are right. We should implement #ilike: similar to
#like: but being case insensitive.<br>
<br>
However, if you check #ilike: it is case insensitive too.
Read the comment of method String >> match:<br>
<br>
I am confused what we should do.<br>
<br>
mariano<br>
</div>
</div>
</blockquote></div>
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.<br><font color="#888888">
ç<br></font></div></blockquote><div><br>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.<br>
<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div bgcolor="#ffffff" text="#000000"><font color="#888888">
<pre cols="72">--
Alan Knight [|], Engineering Manager, Cincom Smalltalk
<a href="mailto:knight@acm.org" target="_blank">knight@acm.org</a>
<a href="mailto:aknight@cincom.com" target="_blank">aknight@cincom.com</a>
<a href="http://www.cincom.com/smalltalk" target="_blank">http://www.cincom.com/smalltalk</a></pre>
</font></div>
<br>_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org">SqueakDBX@lists.squeakfoundation.org</a><br>
<a href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx" target="_blank">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br>
<br></blockquote></div><br>