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