Hye,

I'm a newbie and have a trouble with the following query :

List list = session.find("from Pelftvllotpn A where timestamp(A.ddlanpn,A.dhlanpn) in (select timestamp(X.ddlanpn,X.dhlanpn) from Pelftvllotpn X)");

An exception is thrown about the second timestamp : select timestamp(X.ddlanpn,X.dhlanpn) from Pelftvllotpn X.
It is : "undefined alias: timestamp ..."

However, the following query works :
List list = session.find("from Pelftvllotpn A where timestamp(A.ddlanpn,A.dhlanpn) in ('1970-01-01-00.00.00', '1970-02-01-00.00.00')");

Does anyboy have an idea ?

Thank's a lot !

(Great framework, We wish it a long life)

Is there a function / procedure "timestamp" declared at your database?

The second select statement uses a timestamp dialect function which does not exist. The select clause has limited fucntions that can be applied here. This is a function that currently cannot be applied here. The where clause is fine as its passed directly through without hibernate (possibly) needing to manipulate it.