[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1101) associations join fetched in HQL without owner being selected

associations join fetched in HQL without owner being selected ------------------------------------------------------------- Key: HHH-1101 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1101 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.0.5, 3.1 rc2 Reporter: Emmanuel Bernard Assignee: Steve Ebersole Priority: Minor Fix For: 3.1 Attachments: fetchselect.zip select parent from Child c left join *fetch* c.parent parent throw an exception similar to org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2150) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026) at org.hibernate.loader.Loader.list(Loader.java:2021) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1020) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at org.hibernate.test.annotations.emmanuel.SonicTest.testQuery(SonicTest.java:104) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.hibernate.test.annotations.TestCase.runTest(TestCase.java:61) at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at com.intellij.rt.execution.application.AppMain.main(AppMain.java:86) Caused by: java.sql.SQLException: Column not found: SONIC1_3_ at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcResultSet.findColumn(Unknown Source) at org.hsqldb.jdbc.jdbcResultSet.getInt(Unknown Source) at org.hibernate.type.IntegerType.get(IntegerType.java:28) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102) at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1088) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:553) at org.hibernate.loader.Loader.doQuery(Loader.java:689) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223) at org.hibernate.loader.Loader.doList(Loader.java:2147)