Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMDNjZjJjMzEy... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-15528?atlOrigin=eyJpIjoiMDNjZj... ) HHH-15528 ( https://hibernate.atlassian.net/browse/HHH-15528?atlOrigin=eyJpIjoiMDNjZj... ) Add Cockroach to GitHub actions test matrix and fix issues ( https://hibernate.atlassian.net/browse/HHH-15528?atlOrigin=eyJpIjoiMDNjZj... ) Change By: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) After some reports about issues with CockroachDB I ran the testsuite and found quite a few issues with the current dialect. * According to [https://github.com/cockroachdb/cockroach/issues/26925#issuecomment-124950... default interpretation of {{integer}} is {{int8}}, so we should use {{int4}} as DDL type for a {{java.lang.Integer}} * Due to [https://github. com/cockroachdb/cockroach/issues/87993|https://github.com/cockroachdb/coc...] we should rather use {{varchar}} instead of {{string}} as DDL type names so that array support works properly *  Wrong {{JdbcType}} registered for NCLOB * {{JdbcType}} resolving for native queries doesn't consider CockroachDB native type names * Some operators and functions aren’t correctly registered * Second extraction uses a wrong pattern * {{SKIP LOCKED}} is actually not supported according to [https://www.cockroachlabs.com/docs/stable/select-for-update.html#wait-pol...] * Constraint violation extraction and exception conversion isn’t implemented * Mutations in CTEs aren’t allowed by default and depend on a config parameter {{sql.multiple_modifications_of_table.enabled}} which says that enablement can lead to data inconsistencies ( https://hibernate.atlassian.net/browse/HHH-15528#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15528#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:4756b15 )