Message Title

The following test case can be added to HHH13670Test and demonstrates the problem:


    @Test
    public void testSubTypePropertyReferencedFromEntityJoinInSyntheticSubquery() {
        doInJPA(this::sessionFactory, em -> {
            List<Tuple> resultList = em.createQuery(
                    "SELECT  subB_0.id, subA_0.id, subB_0.id, subA_0.id FROM SubB subB_0 INNER JOIN SubA subA_0 ON 1=1 WHERE (EXISTS (SELECT 1 FROM subB_0.parent _synth_subquery_0 WHERE subA_0.id = _synth_subquery_0.id)) ORDER BY subB_0.id ASC, subA_0.id ASC", Tuple.class)
                    .getResultList();

            assertEquals(1, resultList.size());
        });
    }

org.hibernate.exception.SQLGrammarException: could not prepare statement
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
Caused by: org.h2.jdbc.JdbcSQLException: Column "HHH13670TE0_1_.PARENT_ID" not found; SQL statement:
select hhh13670te0_.id as col_0_0_, hhh13670te1_.id as col_1_0_, hhh13670te0_.id as col_2_0_, hhh13670te1_.id as col_3_0_ from SubB hhh13670te0_ inner join SubA hhh13670te1_ on 1=1 inner join Super hhh13670te1_1_ on hhh13670te1_.id=hhh13670te1_1_.id where (1=1) and (exists (select 1 from Super hhh13670te2_ where hhh13670te0_1_.parent_id=hhh13670te2_.id and hhh13670te1_.id=hhh13670te2_.id)) order by hhh13670te0_.id ASC, hhh13670te1_.id ASC [42122-196]

Disabling AvailableSettings.OMIT_JOIN_OF_SUPERCLASS_TABLES solves the problem.