<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Yes, I think creating ilike: is the easiest solution.<br>
<br>
On 2010-11-19 12:08 PM, Mariano Martinez Peck wrote:
<blockquote
cite="mid:AANLkTimvRBq5P9yYiNmjo39A5pcdAnPGpt7QVxQX+hpW@mail.gmail.com"
type="cite"><br>
<br>
<div class="gmail_quote">On Thu, Nov 11, 2010 at 9:04 PM, Alan
Knight <span dir="ltr"><<a moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:knight@acm.org" target="_blank">knight@acm.org</a>
<a moz-do-not-send="true" href="mailto:aknight@cincom.com" target="_blank">aknight@cincom.com</a>
<a moz-do-not-send="true" href="http://www.cincom.com/smalltalk" target="_blank">http://www.cincom.com/smalltalk</a></pre>
</font></div>
<br>
_______________________________________________<br>
SqueakDBX mailing list<br>
<a moz-do-not-send="true"
href="mailto:SqueakDBX@lists.squeakfoundation.org">SqueakDBX@lists.squeakfoundation.org</a><br>
<a moz-do-not-send="true"
href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx"
target="_blank">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br>
<br>
</blockquote>
</div>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Alan Knight [|], Engineering Manager, Cincom Smalltalk
<a class="moz-txt-link-abbreviated" href="mailto:knight@acm.org">knight@acm.org</a>
<a class="moz-txt-link-abbreviated" href="mailto:aknight@cincom.com">aknight@cincom.com</a>
<a class="moz-txt-link-freetext" href="http://www.cincom.com/smalltalk">http://www.cincom.com/smalltalk</a></pre>
</body>
</html>