InformixDialect generates invalid Aliases for Informix 7 -------------------------------------------------------- Key: HHH-2642 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2642 Project: Hibernate3 Issue Type: Bug Components: query-sql Affects Versions: 3.0 final Environment: Informix 7.31 Reporter: Thom Hehl With Informix JDBC drivers and InformixDialect, Hibernate 3 builds the following query: select participan0_.PART_NO as PART1_12_0_, participan0_.FNAME as FNAME12_0_, participan0_.LNAME as LNAME12_0_, participan0_.ADDRESS as ADDRESS12_0_, participan0_.city as city12_0_, participan0_.state as state12_0_, participan0_.zip as zip12_0_, participan0_.DOB as DOB12_0_, participan0_.DATE_SELECTED1 as DATE9_12_0_, participan0_.h_phone as h10_12_0_, participan0_.SIN as SIN12_0_, participan0_.SEX as SEX12_0_, participan0_.citizen as citizen12_0_, participan0_.race as race12_0_, participan0_.hispanic as hispanic12_0_, participan0_.NOTES as NOTES12_0_, participan0_.STATUS as STATUS12_0_ from INFORMIX.VOTERS participan0_ where participan0_.PART_NO='100025595' and ADDRESS12_0_ = 'PO BOX 20 ' The problem is that Informix 7.3.1 doesn't see the ADDRESS12_0_ as a valid alias and throws a SQL exception. This works under Informix 9. We need an Informix 7 dialect that will support this query without throwing an exception. Thanks. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira