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-1249500903|https://github.com/cockroachdb/cockroach/issues/26925#issuecomment-1249500903|smart-link] the 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/cockroach/issues/87993|smart-link] 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-policies|https://www.cockroachlabs.com/docs/stable/select-for-update.html#wait-policies|smart-link] * 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 |
|