I added the question in Stack Overflow with some more details:
http://stackoverflow.com/questions/11888195/nhibernate-query-cache-bug-with-hyphens
On Monday, August 6, 2012 1:59:23 PM UTC-5, Abid Rahman wrote:
> Please excuse the misspelling of "Cacheable" in the title.
>
> On Monday, August 6, 2012 1:48:12 PM UTC-5, Abid Rahman wrote:
>
>> var query1 = session.Query<Content>().Cacheable().Where(c => c.Name ==
>> "test-test").ToList();
>>
>> var query2= session.CreateQuery("from Content c where c.Name = :name")
>>
>> .SetString("name", "test-test")
>> .SetCacheable(true);
>> var list = query.List<Content>();
>>
>> Either one of the above queries will produce the following query:
>>
>> select content0_.Id as Id6_,
>> content0_.Name as Name6_,
>> from Content content0_
>> where content0_.Name = ''
>>
>> Any parameter that is passed in and has a '-' (hyphen), doesn't not make
>> it to the actual SQL query
>> If I remove the .Cacheable or SetCacheable(), it works correctly.
>>
>>
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/Qk33TfqEmogJ.
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.
