I've got a problem using HQL with join using composite-id on Oracle 9i.
When I joint classes like:

... where idfklient=idfklientucet.klient ....

and then generated sql:

... where (klu.idklient,klu.dotaz_id,klu.sablona_id)=(k.idklient,k.dotaz_id,k.sablona_id) ...

This should join by composite-id, but generated SQL fails on Oracle (Postgres 8.1 is fine).
Is this a dialect implementation problem or HQL processor problem?

I can use workaround providing full list of columns in HQL.
(idfklinet.idKlient=idfklientucet=idKlient and idfklinet.dotazID=idfklientucet.dotazID and idfklient.tabulkaVSabloneID=idfklientucet.tabulkaVSabloneID)

But it is not comfortable and could cause some migration problems (developing under Postgres and then trying to migrate under Oracle).

Is this a bug? Shall I post it into JIRA?

Hibernate version:
3.1.2

Mapping documents:
<class name="IdfKlient" table="idfklient" node="cz.aegis.idf.db.model.idf.IdfKlient">
<composite-id name="id"
class="cz.aegis.idf.db.model.idf.base.IdfKlientPK">
<key-property name="idKlient" column="idklient" type="string" length="25" />
<key-property name="dotazID" column="dotaz_id" type="long" />
<key-property name="tabulkaVSabloneID" column="sablona_id" type="long" />
</composite-id>
</class>



<class name="IdfKlientUcet" table="idfklientucet" node="cz.aegis.idf.db.model.idf.IdfKlientUcet">
<composite-id name="id" class="cz.aegis.idf.db.model.idf.base.IdfKlientUcetPK">
<key-property name="idKlient" column="idklient" type="string" length="25"/>
<key-property name="idUcet" column="iducet" type="string" length="42"/>
<key-property name="dotazID" column="dotaz_id" type="long" />
<key-property name="tabulkaVSabloneID" column="sablona_id" type="long" />
</composite-id>
<many-to-one name="klient" embed-xml="false" class="IdfKlient"
not-null="false" insert="false" update="false">
<column name="idklient" />
<column name="dotaz_id" />
<column name="sablona_id" />
</many-to-one>
</class>


Name and version of the database you are using:
Oracle 9i with org.hibernate.dialect.Oracle9Dialect

The generated SQL (show_sql=true):
... where (klu.idklient,klu.dotaz_id,klu.sablona_id)=(k.idklient,k.dotaz_id,k.sablona_id)

Take a look on this one. It allowes a lot of flexibility when using joins.