Now I'm really confused. There is an InsensitiveLikeExpression which allways
calls lower.
But it calls 'ilike' for Postgres. But in LikeExpression there is no special
call for postgresql.
And the lowercase call for paramters are missing too.
Is this a Bug too?
> It matters on Oracle database:
>
> select 'X' from dual where lower('ABCDE') like 'A%'
>
> Does not return a row, the like comparison fails.
>
>
>
>
> On Aug 21, 2:31 pm, armin-landscheidt <[email protected]> wrote:
>
>> If I remember right, it doesn't matter if you write 'C%' or 'c%' but I will
>> check it.
>>
>>
>>
>>
>>> Based on your tests for NH-1902, then this test should pass, too.
>>>
>>> I can't seem to get NHibernate to build and test on my machine. Is
>>> this something you can run??
>>>
>>> [Test]
>>> public void
>>> TestEnableLikeAndCaseInsensitiveWithMatchmodeAnywhere()
>>> {
>>> using (ISession s = OpenSession())
>>> using (ITransaction t = s.BeginTransaction()) {
>>> Componentizable master = GetMaster("BERN", null,
>>> null);
>>> ICriteria crit =
>>> s.CreateCriteria(typeof(Componentizable));
>>> Example ex = Example.Create(master).EnableLike
>>> (MatchMode.Anywhere).IgnoreCase();
>>> crit.Add(ex);
>>> IList result = crit.List();
>>> Assert.IsNotNull(result);
>>> Assert.AreEqual(3, result.Count);
>>> t.Commit();
>>> }
>>> }
>>>
>>> On Aug 21, 11:52 am, Joe <[email protected]> wrote:
>>>
>>>> Oops, I celebrated too soon!
>>>> I grabbed the latest build from NH TeamCity and at first it seemed
>>>> fixed.
>>>>
>>>> But, there is a problem still with case.
>>>>
>>>> If I set a string property to "C", the parameter generated is "C%",
>>>> but it should be "c%" because the where clause is: "WHERE (lower
>>>> (this_.description) like ?)"
>>>>
>>>> "C%" is not going to match anything returned by a lower() function.
>>>>
>>>> Armin, did you have this problem??
>>>>
>>>> On Aug 21, 10:26 am, Joe <[email protected]> wrote:
>>>>
>>>>> Thanks you guys, I was pulling my hair out!
>>>>>
>>>>> On Aug 21, 4:15 am, Armin Landscheidt <[email protected]> wrote:
>>>>>
>>>>>> http://nhjira.koah.net/browse/NH-1902
>>>>>>
>>>>>> On Aug 21, 1:02 pm, Saijado <[email protected]> wrote:
>>>>>>
>>>>>>> This Bug should be fixed in Version 2.1.1 I've send a patch to JIRA
>>>>>>> some weeks ago. Search in JIRA for "Example" and you should find my
>>>>>>> post.
>>>>>>>
>>>>>>> -- Armin
>>>>>>>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
