[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6761) CollectionTable and OneToMany, collection elements duplicate.

CollectionTable and OneToMany, collection elements duplicate. -------------------------------------------------------------- Key: HHH-6761 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6761 Project: Hibernate Core Issue Type: Bug Components: core Environment: 3.6.4.Final Reporter: Evgeny Terentev @Entity @Table(name = "aaa") public class AAA implements Serializable { @Id @GeneratedValue(strategy = GenerationType.AUTO) private int id; @MapKey(name = "ccc") @OneToMany(orphanRemoval = true, cascade = {CascadeType.REMOVE}, fetch = FetchType.EAGER, mappedBy = "aaa") private Map<CCC, BBB> bbb = new HashMap<CCC, BBB>(); @Column(name = "bonus_id") @ElementCollection(targetClass = Long.class, fetch = FetchType.EAGER) @CollectionTable(name = "aaa_bonus", joinColumns = @JoinColumn(name = "advert_post_id")) public Collection<Long> bonusIds; } @Entity @Table(name = "bbb") public class BBB implements Serializable { @Id @GeneratedValue(strategy = GenerationType.AUTO) public int id; @ManyToOne(optional = false) @JoinColumn(name = "aaa_id", nullable = false) public AAA aaa; @Column public CCC ccc; @Column public int value; } public enum CCC { AAA, BBB, CCC, } first fill tables: AAA a = new AAA(); a.bonusIds = Arrays.asList(1L, 2L, 3L); // size = 3 em.persist(a); BBB b = new BBB(); b.aaa = a; b.ccc = CCC.AAA; b.value = 1; em.merge(b); em.merge(b); second get bonusIds and check size: AAA aaa = em.find(AAA.class, 6); if (aaa.bonusIds.size() != 3) throw new RuntimeException(); size will be 6! but must be 3. generate sql: select aaa0_.id as id1_1_, bbb1_.aaa_id as aaa4_1_3_, bbb1_.id as id3_, bbb1_.ccc as formula0_3_, bbb1_.id as id0_0_, bbb1_.aaa_id as aaa4_0_0_, bbb1_.ccc as ccc0_0_, bbb1_.value as value0_0_, bonusids2_.advert_post_id as advert1_1_4_, bonusids2_.bonus_id as bonus2_4_ from aaa aaa0_ left outer join bbb bbb1_ on aaa0_.id=bbb1_.aaa_id left outer join aaa_bonus bonusids2_ on aaa0_.id=bonusids2_.advert_post_id where aaa0_.id=?