Message Title

Jones commented on

I would like to add that I’m facing the same issue with Oracle:

When I have an entity with multiple subclasses using a single table and discriminator, I get the same issue… The select has all properties from all sub-classes, but the group by is missing, which causes issues in oracle:

                              Hibernate: 
    select
        sum(m1_0.amount),
        r1_0.ID,
        r1_0.DISC_COL,
        r1_0.RELATED_VALUE,
        r1_0.ONLY_CHILD_ONE,
        r1_0.ONLY_CHILD_TWO 
    from
        MY_TABLE m1_0 
    join
        MY_TABLE r1_0 
            on r1_0.ID=m1_0.REL_ENTITY 
    where
        1=1 
    group by
        r1_0.ID,
        r1_0.DISC_COL,
        r1_0.RELATED_VALUE
                              

I’m attaching a test case for it just as a reference

HHH-16XX1.zip

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira