<!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">
On 2010-11-10 11:35 PM, Mariano Martinez Peck wrote:
<blockquote
cite="mid:AANLkTikOqtptWkF6RseBqXsTB5zrpykNt9M1XE62vUT4@mail.gmail.com"
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">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">marianopeck@gmail.com</a>>:<br>
<div class="im">> 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>
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>
<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>