Hi,
I am using NHibernate 1.2.0GA and have come up against this problem with the generated sql:
NpgsqlException - ERROR: 42601: syntax error at or near "x0_"
Code:
SELECT
45x0_.bugid as bugid__1_,
45x0_.personresourceid as personre2_1_,
resource1_.id as id24_0_,
resource1_.name as name24_0_,
resource1_.description as descript3_24_0_,
resource1_.displayname as displayn4_24_0_
FROM bugs.bugs_col_45_resources 45x0_
left outer join shared.resources resource1_ on 45x0_.personresourceid=resource1_.id
WHERE 45x0_.bugid=276
This is because 45x0_ is an invalid alias name.
Is there any way to change how NHibernate will generate this sql so that it will be valid?
Many thanks,
Chris