TestFkUpdating use "Role", which is a keyword on Sybase.

Fixed in master and 5.0 branches.

EncapsulatedCompositeAttributeResultSetProcessorTest#testNestedCompositeElementCollectionProcessing has a property "date". I've mapped the column name as "`date`".

Fixed in master and 5.0 branches.

org.hibernate.test.map.MapIndexFormulaTest fails because it uses a column "`password`", and a custom query:

{{ select
lower(u.name) as {u.name}, lower(u."password") as {u.password},
lower(s.userName) as {s.key}, lower(s.name) as {s.index}, s.id as {s.element},
{s.element.*}
from users u}}

The back-tics used for quotes in the column mapping work for creating tables, but for custom native queries, the quotes need to be appropriate to the dialect. Using double-quotes in the custom query does not work. The quotes used in the custom query need to be correct for the dialect. MySQL requires back-tics; other dialects (e.g., H2) require double-quotes.

I've changed the column mapping to "pw", which is not a reserved word so does not need quotes.

Fixed in master and 5.0 branches.

org.hibernate.test.converter.elementCollection.CollectionElementConversionTest.testElementCollectionConversion
uses a collection attribute "set", which is a reserved word for MySQL 5.5.

Fixed in master and 5.0 branches.

JavassistInstrumentationTest#testEagerFetchLazyToOne uses an attribute, "number", which is a reserved word for Oracle.

Fixed in 5.0 only; tests were deleted from master by HHH-10280.