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