When using annotation based ORM, once LazyCollectionOption.EXTRA is used, the @Where annotation gets completely ignored, for instance:
@OneToMany @Where(clause = "state != 3") @LazyCollection(LazyCollectionOption.EXTRA) private List<Entity> tickets = new ArrayList<>();
I have noticed, this issue has been seen already in 2007 (with no response):
https://forum.hibernate.org/viewtopic.php?f=1&t=981143&sid=6242214298ef7a1390492f641bb8e7c1
|