hi!

i found the follow error:

i try to iterate a query:

s.iterate("SELECT sum(hours.time*employee_faktor.faktor) FROM hours IN CLASS com.comp.sql.dbo.Hours, employee_faktor IN CLASS com.comp.sql.dbo.Employee_faktor WHERE hours.phase.id=? and hours.userid=employee_faktor.employee.userid and employee_faktor.datefrom<=hours.activitydate and employee_faktor.dateto>hours.activitydate", phase.getId(), Hibernate.LONG);


and i get the follow exception:

SCHWERWIEGEND: Spaltenname

As per the documentation, expressions are not supported in the SELECT clause.

but it looks like hibernate accept the query, it translate it into sql and send
it to the database.
only the col name is not right (x0_0_/x1_0_)

if it is not supportet why hibernate doesnt send a execption that
it is not supportet?