[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4912) testManyToManyWithFormula induces error with Ingres dialect

[Ray Fan (JIRA)]

testManyToManyWithFormula induces error with Ingres dialect
-----------------------------------------------------------

                 Key: HHH-4912
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4912
             Project: Hibernate Core
          Issue Type: Bug
          Components: query-hql
    Affects Versions: 3.5.0-Beta-4
         Environment: Hibernate 3.5.0-Beta-4, Ingres 9.3.1
            Reporter: Ray Fan
         Attachments: manytomany-logs.zip

During test org.hibernate.test.manytomany.ManyToManyTest an error is encountered when using the Ingres dialect.
{noformat}
testcase time="0.806" classname="org.hibernate.test.manytomany.ManyToManyTest" name="testManyToManyWithFormula">
    <error message="could not execute query" type="org.hibernate.exception.GenericJDBCException">org.hibernate.exception.GenericJDBCException: could not execute query
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:132)
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:120)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.loader.Loader.doList(Loader.java:2257)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2151)
    at org.hibernate.loader.Loader.list(Loader.java:2146)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:448)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:859)
    at org.hibernate.test.manytomany.ManyToManyTest.testManyToManyWithFormula(ManyToManyTest.java:92)
Caused by: com.ingres.gcf.util.SqlEx: line 1, Column &apos;username&apos; found in more than one FROM list table.
    at com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source)
    at com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source)
    at com.ingres.gcf.jdbc.DrvPrep.prepare(Unknown Source)
    at com.ingres.gcf.jdbc.DrvConn.createPrepStmt(Unknown Source)
    at com.ingres.gcf.jdbc.JdbcPrep.&lt;init&gt;(Unknown Source)
    at com.ingres.gcf.jdbc.JdbcConn.createPrep(Unknown Source)
    at com.ingres.gcf.jdbc.JdbcConn.prepareStatement(Unknown Source)
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
    at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1597)
    at org.hibernate.loader.Loader.doQuery(Loader.java:718)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:271)
    at org.hibernate.loader.Loader.doList(Loader.java:2254)
    ... 39 more
{noformat}

The generated SQL query from HQL: from org.hibernate.test.manytomany.User u join fetch u.groups g join fetch g.users
{noformat}
    select
        user0_.name as name3854_0_,
        user0_.org as org3854_0_,
        group2_.name as name3856_1_,
        group2_.org as org3856_1_,
        user4_.name as name3854_2_,
        user4_.org as org3854_2_,
        group2_.description as descript3_3856_1_,
        groups1_.userName as userName0__,
        groups1_.org as org0__,
        groups1_.groupName as groupName0__,
        groups1_.org as formula31_0__,
        users3_.groupName as groupName1__,
        users3_.org as org1__,
        userName as userName1__,
        users3_.org as formula32_1__ 
    from
        'User' user0_ 
    inner join
        UserGroup groups1_ 
            on user0_.name=groups1_.userName 
            and user0_.org=groups1_.org 
    inner join
        'Group' group2_ 
            on groups1_.groupName=group2_.name 
            and groups1_.org=group2_.org 
    inner join
        UserGroup users3_ 
            on group2_.name=users3_.groupName 
            and group2_.org=users3_.org 
    inner join
        'User' user4_ 
            on users3_.userName=user4_.name 
            and users3_.org=user4_.org

{noformat}
seems to includes userName as userName1__ in the select list without table qualification.  Ingres is unable to disambiguate the column from groups1_ or users3_ and raises the error.

Attaching test logs.

-- 
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