I’m sorry for mystification beikov, it is indeed working correctly. It was an error on my side - I used com.mariadb.jdbc instead of org.mariadb.jdbc - it failed - and defaulted to MySQL connector (which is default fallback driver in our project).
Now everything works correctly and Hibernate is indeed very capable of detecting correct dialect.
Thanks for your help!