[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5546) @Where and eager @ManyToMany makes em.find return null with Oracle9iDialect

@Where and eager @ManyToMany makes em.find return null with Oracle9iDialect --------------------------------------------------------------------------- Key: HHH-5546 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5546 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.2.4.sp1 Reporter: Johan Andrén Attachments: wherebug.tar.gz A many-to-many relation between class A and class B is annotated with FetchType.EAGER and a @Where that limits what of the entries from table B that should be included depending on if property in B is null. For HSQL it generates something like this SELECT A.*, A_TO_B.*, B.* FROM A LEFT OUTER JOIN A_TO_B ON A.id=A_TO_B.a_id LEFT OUTER JOIN B ON A_TO_B.b_id=B.id AND (B.SOME_PROPERTY IS NULL) WHERE A.id = ? which works correctly, but for oracle9 we get this SELECT A.*, A_TO_B.*, B.* FROM A, A_TO_B, B WHERE A.id = A_TO_B.a_id(+) AND A_TO_B.b_id = B.id(+) AND ( B.SOME_PROPERTY IS NULL ) AND calendar_event.id = ? Which makes em.find(A.class, idForAnExistingA) return null if there only is Bs with someProperty=null in the database for the given A (no rows returned from the query). Not sure how to make a runnable testcase, attached a maven project with annotated classes and code that describes the steps to reproduce but is not runnable as is.