For example, enabling org.hibernate.test.subselect.CompositeIdTypeBindingTest for SQL-Server by removing the corresponding annotation @SkipForDialect and running the matrix-test on an SQL-Server would produce the following exception.
This is due to execution of this SQL-statement which is invalid for SQL-Server:
After applying the attached patch-file the test will pass. The SQL-statement (for SQL-Server only) 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.
I can confirm this is still happening in Hibernate 5.2.10.Final