Anyway the quick guess is that the version of MariaDB you’re using doesn’t know of this system variable (REFERENTIAL_INTEGRITY). However it’s referenced here for all Spring tests:
if (useInMemoryDatabase()) {
constraintsOnSql = "SET REFERENTIAL_INTEGRITY TRUE";
}