Re: [hibernate-dev] MySQL versus MariaDB

As I have developed the matrix tests against MariaDB I have had in the back of my head whether we might want to develop a Dialect for MariaDB. As I understand it, MariaDB does strive to remain compatible with MySQL but it does offer some enhancements. And it might have some minor deviations. Today I think I found one such deviation, in their respective support for casting decimal/floating-point values. I came across this because of some failed tests. There are quite a few resolved issues in Jira wrt MySQL and casting. So I have to assume these tests work on MySQL which tells me there is a deviation in their behavior... The tests in question (more or less) do: "select ... cast( x as big_decimal ) ...". We understand big_decimal as java.sql.Types#NUMERIC for which the MySQL Dialect says to use "decimal" for casting purposes. On MariaDB at least "decimal" (no precision) leads to a data trunction. We are expecting a value like "12.399999618530273" but get back "12.0". Because for MariaDB DECIMAL is equivalent to DECIMAL(10,0). So as it is, for this minor case at least the MySQL dialects work against MySQL databases (we assume) but fail against MariaDB databases. The other difficulty with a dialect specific for MariaDB is auto-detection. The MariaDB JDBC drivers report the underlying database as mysql.