[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5072) Invalid SQL produced when using FetchMode.SUBSELECT with SQLServerDialect

Invalid SQL produced when using FetchMode.SUBSELECT with SQLServerDialect ------------------------------------------------------------------------- Key: HHH-5072 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5072 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5.0-Final Environment: Hibernate core 3.5, JPA 2.0, SQL Server 2005, JDK 1.6 Reporter: kabram Priority: Blocker I have a parent entity with child entities being loaded using SubSelect and eager fetching. I execute a query to retrieve all parents and get the following query which SQL Server 2005 does not support: select childtab0_.CONFIG_KEY as CONFIG5_23_1_, childtab0_.QUALIFIER as QUALIFIER23_1_, childtab0_.CONFIG_VALUE_ID as CONFIG1_1_, childtab0_.CONFIG_VALUE_ID as CONFIG1_24_0_, childtab0_.CONFIG_KEY as CONFIG5_24_0_, childtab0_.QUALIFIER as QUALIFIER24_0_, childtab0_.CONFIG_VALUE as CONFIG2_24_0_, childtab0_.IS_ENCRYPTED as IS3_24_0_, childtab0_.LIST_ORDER as LIST4_24_0_ from TEST_CHILD_TABLE childtab0_ where (childtab0_.CONFIG_KEY, childtab0_.QUALIFIER) in (select parenttab0_.CONFIG_KEY, parenttab0_.QUALIFIER from RSS_NEO_CANYON_CONFIG_KEY parenttab0_ ) order by childtab0_.LIST_ORDER asc SQL Server does not like the tuple in the where clause.