Hibernate version: 2

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: MySQL 4.0.20A

The generated SQL (show_sql=true): SELECT countryDefinition.ID as ID0_, countryDefinition.PERSISTENCEVERSION as PERSISTE2_0_, countryDefinition.STARTDATE as STARTDATE0_, countryDefinition.ENDDATE as ENDDATE0_, countryDefinition.COUNTRYCODE as COUNTRYC5_0_, countryDefinition.COUNTRYNAME as COUNTRYN6_0_, countryDefinition.CREATED as CREATED0_, countryDefinition.CREATEDBY as CREATEDBY0_, countryDefinition.UPDATED as UPDATED0_, countryDefinition.UPDATEDBY as UPDATEDBY0_ FROM PO_CountryDefinition countryDefinition LEFT JOIN PO_PersonIdentifierType personIdentifierType ON ID0_=COUNTRYD5_1_ WHERE COUNTRYN6_0_ LIKE ?

Debug level Hibernate log excerpt:

Hi

Im using SQLQuery, and hibernate generates aliases for all selected fields, see attached hibernate SQL dump. It then uses the field alias in the where clause. But MySQL does not support this.

Do anyone know what to do?

Help appreciated

Thanks