hibernate-reactive: delete queries and union subclass inheritance fails with MySQL 8.0.29

If we upgrade to MySQL 8.0.29 (without chaniging anything else) the test org.hibernate.reactive.UnionSubclassInheritanceTest will fail because the delete of the entity doesn’t occurs:

Expected null
java.lang.AssertionError: Expected null
	at io.vertx.ext.unit.impl.TestContextImpl.reportAssertionError(TestContextImpl.java:362)

Something doesn’t work quite right when running these queries:

create temporary table if not exists ht_BookUS (id integer not null) 
insert into ht_BookUS select unionsubcl0_.id as id from ( select id, published, title, null as forbidden, 0 as clazz_ from BookUS union all select id, published, title, forbidden, 1 as clazz_ from SpellBookUS ) unionsubcl0_ where unionsubcl0_.title=?
delete from BookUS where (id) in (select id from ht_BookUS)
delete from SpellBookUS where (id) in (select id from ht_BookUS)
drop temporary table ht_BookUS

This seems to be a bug with MySQL 8.0.29: https://bugs.mysql.com/bug.php?id=107447