After applying the attached patch-file the test will pass. The SQL-statement then looks like:
The attached patch-file also introduces a new test-case org.hibernate.test.subselectfetch.compositeid.SubselectFetchCompositeIdTest derived from org.hibernate.test.subselectfetch.SubselectFetchTest and a test-case org.hibernate.test.subselectfetch.multilevel.MultiLevelTest that would fail on SQL-Server without applying the patch. |