[Hibernate] Binary Expressions in Collections

[Christian B. <chr...@bl...>]

Gavin, the new dereferencing of Collections (my forum post) works great
in CVS. I had to comment out the new Calendar stuff to compile it, though.

But I found another query structure that is not possible currently:

I need to compare the values of a collection (a List of Strings) with a
binary operator (= > < like, and so on).

Foo has a List of Strings named Bar.

List bars = foo.getBar();

The query I need:

select foo from my.Foo
    where foo.bar.values like "baz%"

The 'values' special property doesn't exist (of course). We have the
'elements' and 'indices' special properties only (along with 'size' and
other collection related properties).

I had a look at the generated SQL queries when using 'elments' and
'indices' and doubt adding 'values' is an easy task. 

'in', 'some', 'all' and other subselect related expressions only allow
things like

select foo from my.Foo
    where "a_String" in foo.bar.elements

Of course, no substring searching is possible with this where clause.
The only solution I found is using the existing query facilities and do
substring search in memory/Java.

-- 
Christian Bauer
tu...@in...