Multiple errors reported during legacy FooBarTest with Ingres ------------------------------------------------------------- Key: HHH-4938 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4938 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Beta-4 Environment: 3.5.0-Beta-4, Ingres 9.3.1 Reporter: Ray Fan Attachments: IngresAmbiguousColumnTest.java, legacy.zip During test org.hibernate.test.legacy.FooBarTest multiple tests fail with ambiguous column defined in the select list. {noformat} <error message="could not initialize a collection: [org.hibernate.test.legacy.Abstract.abstracts#ff80808126e244920126e246eeb10001]" type="org.hibernate.exception.GenericJDBCException">org.hibernate.exception.GenericJDBCException: could not initialize a collection: [org.hibernate.test.legacy.Abstract.abstracts#ff80808126e244920126e246eeb10001] 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.loadCollection(Loader.java:2048) at org.hibernate.loader.collection.BatchingCollectionInitializer.initialize(BatchingCollectionInitializer.java:86) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:628) at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83) at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1853) at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:476) at org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:899) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:276) at org.hibernate.loader.Loader.loadEntity(Loader.java:1907) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3212) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:997) at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:386) at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:234) at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:84) at org.hibernate.impl.SessionImpl.fireSaveOrUpdateCopy(SessionImpl.java:914) at org.hibernate.impl.SessionImpl.saveOrUpdateCopy(SessionImpl.java:878) at org.hibernate.impl.SessionImpl.saveOrUpdateCopy(SessionImpl.java:882) at org.hibernate.test.legacy.FooBarTest.testSaveOrUpdateCopyAny(FooBarTest.java:126) Caused by: com.ingres.gcf.util.SqlEx: line 1, Column &apos;str&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) {noformat} The generate SQL query select list contains multiple columns named 'str'. -- 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