Setting the dialect to org.hibernate.community.dialect.MySQLLegacyDialect or to org.hibernate.community.dialect.MySQL55Dialect results in:
Caused by: java.lang.ClassCastException: class org.hibernate.community.dialect.MySQL55Dialect cannot be cast to class org.hibernate.dialect.MySQLDialect (org.hibernate.community.dialect.MySQL55Dialect and org.hibernate.dialect.MySQLDialect are in unnamed module of loader io.quarkus.bootstrap.classloading.QuarkusClassLoader @1abebef3)
at org.hibernate.community.dialect.MySQLLegacySqlAstTranslator.getDialect(MySQLLegacySqlAstTranslator.java:249)
at org.hibernate.community.dialect.MySQLLegacySqlAstTranslator.supportsWithClause(MySQLLegacySqlAstTranslator.java:234)
at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.needsCteInlining(AbstractSqlAstTranslator.java:1813)
at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.visitCteContainer(AbstractSqlAstTranslator.java:1509)
at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.visitSelectStatement(AbstractSqlAstTranslator.java:985)
at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.translateSelect(AbstractSqlAstTranslator.java:849)
at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.translate(AbstractSqlAstTranslator.java:799)
at org.hibernate.loader.ast.internal.EntityBatchLoaderInPredicate.prepare(EntityBatchLoaderInPredicate.java:332)
at org.hibernate.persister.entity.AbstractEntityPersister.prepareLoader(AbstractEntityPersister.java:3447)
at org.hibernate.persister.entity.AbstractEntityPersister.postInstantiate(AbstractEntityPersister.java:3441)
at org.hibernate.metamodel.model.domain.internal.MappingMetamodelImpl.finishInitialization(MappingMetamodelImpl.java:204)
at org.hibernate.internal.SessionFactoryImpl.initializeMappingModel(SessionFactoryImpl.java:320)
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:270)
at io.quarkus.hibernate.orm.runtime.boot.FastBootEntityManagerFactoryBuilder.build(FastBootEntityManagerFactoryBuilder.java:84)
... 6 more