[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2642) InformixDialect generates invalid Aliases for Informix 7

[Thom Hehl (JIRA)]

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira