Hello,

I have a one-to-many association between class A and class C, class C  is derived from class B. Class A is Audited, class C is not.

B and C are in one table (strategy = InheritanceType.SINGLE_TABLE), with a discrimator in a column named "type".  There are several  other classes derived from B.

Class A has a member "allMyC" of type Set<C>, which holds the association. As C is not audited, this member of  A is marked with @Audited(targetAuditMode = RelationTargetAuditMode.NOT_AUDITED). Furthermore, as I want only the Cs, no other subclasses of B, this member is also marked with @Where(clause = "TYPE = 'TypeC'").

The audit-table for the relation is @AuditJoinTable(name = "A_C_AUD")

So far so good.

Now when I have an older (audited) revision of class A and try to access allMyC of this revision, the generated sql reads like:

  select

<several columns>

   from

        A_C_AUD acaud0_,

        C c0_

    where

        (

            acaud0_.TYPE = 'TypeC'

        )

        and c0_.TYPE='TypeC'

        and acaud0_.id=c0_.id

        and acaud0_.A_ID=?

        and acaud0_.REV=(

            select

                max(acaud02_.REV)

            from

                A_C_AUD acaud02_

            where

                (

                   acaud2_.TYPE = 'TypeC'

                )

                and acaud2_.REV<=?

                and acaud0_.A_id=acaud2_.A_ID

                and acaud0_.id=acaud2_.id

        )

        and acaud0_.REVTYPE<>?

My problem is in the bold lines:

There the SQL tries to read a column "TYPE" in the auditing table of the association (which doesn't exist, there's only a "TYPE" column in the table of C), thus producing an sql Error .

When (for test purposes) I leave out the @Where(clause = "TYPE = 'TypeC'") annotation of allMyC, the generated SQl is correct (it's just the same as above, without the boldly marked lines).

What can I do when I want to keep the where-clause? I'm using hibernate envers 4.2.4.

Any hints appreciated.