Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmZjNjQ1MTEx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-17016?atlOrigin=eyJpIjoiNmZjNj... ) HHH-17016 ( https://hibernate.atlassian.net/browse/HHH-17016?atlOrigin=eyJpIjoiNmZjNj... ) Using a legacy MySQL dialect leads to an error ( https://hibernate.atlassian.net/browse/HHH-17016?atlOrigin=eyJpIjoiNmZjNj... ) Issue Type: Bug Affects Versions: 6.3.0.CR1, 6.2.7 Assignee: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Created: 31/Jul/2023 09:53 AM Fix Versions: 6.3.0, 6.2.8 Priority: Major Reporter: Marko Bekhta ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) 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 ( https://hibernate.atlassian.net/browse/HHH-17016#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-17016#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100233- sha1:da16c62 )