Re: AW: [Hibernate-devel] Find doesnt return all elements

[Gavin_King/Cirrus%<CI...@ci...>]

>With the latest cvs i have a different problem:
>My query
>        "from vtrm in class " + Vtrm.class.getName() + ", shop in
>vtrm.shops.elements where vtrm.status=5 and vtrm.iskind=0 and
>shop.shopkz='WAP'";
>
>Now returns an array of vtrm and shop elements, with the old version it
>just returned vtrm(what i actually wanted it to do). Is that a new
>feature? How should I write the query to just return vtrm objects?

oh. ouch. now I'm really embarrassed. I don't *remember* what the correct
functionality is.....

I know what I *want* it to be: exactly what it is in the latest CVS. But
I think somewhere back in the dim, dark past I deliberately chose something
different for backward compatibility with a *very* early version. And my
damn test suite doesn't cover this case!!*@

Notice that the documentation doesn't have anything to say on the subject
of
multipart from clause w/o a select clause, probably because this was a case
I was uncomfortable with earlier.

geez this is bad - but I think we need to stick with whats in CVS its the
only choice that makes proper sense. Better to fix it now than later.
Unfortunately it *will* break existing applications. Damn.

Use:

   select vtrm from vtrm in class Vtrm, shop in vtrm.shops.elements
      where vtrm.status=5 and vtrm.iskind=0 and shop.shopkz='WAP'

I'm really sorry about this its most slack and untidy of me....