Collection loading is case sensitive with case insensitive db platform

Description

A fragment of my persistent POJO class:

@Entity
@Table(name = "USER_INFO")
public class HibernateUserInfo
{
@EmbeddedId
private HibernateUserIdImpl userId;
@CollectionOfElements
private List<Role> roles;
}

My database contains only one HibernateUserInfo object and its userId is [username=sadmin, domain=LOCAL].

When I load the object using userId [username=sadmin, domain=LOCAL] roles gets populated correctly.
When I load the object using userid [username=SADmin, domain=LOCAL] roles is always empty.

The log traces from both cases are attached.

The traces show that when using the mixed case username 2 collections are built internally but only one of them gets used. org.hibernate.engine.loading.LoadContexts.locateLoadingCollectionEntry(org.hibernate.engine.CollectionKey) locates 2 different entries for sadmin and SADmin and that leads to the 2 collections.

Environment

Hibernate 3.2.4.sp1, Hibernate Annotations 3.2.1.GA, MySQL 5.0.45

Activity

Show:
Brett Meyer
April 7, 2014, 5:41 PM

In an effort to clean up, in bulk, tickets that are most likely out of date, we're transitioning all ORM 3 tickets to an "Awaiting Test Case" state. Please see http://in.relation.to/Bloggers/HibernateORMJIRAPoliciesAndCleanUpTactics for more information.

If this is still a legitimate bug in ORM 4, please provide either a test case that reproduces it or enough detail (entities, mappings, snippets, etc.) to show that it still fails on 4. If nothing is received within 3 months or so, we'll be automatically closing them.

Thank you!

Brett Meyer
July 8, 2014, 3:11 PM

Bulk rejecting stale issues. If this is still a legitimate issue on ORM 4, feel free to comment and attach a test case. I'll address responses case-by-case. Thanks!

Assignee

Unassigned

Reporter

Jozef Saniga

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

Priority

Major
Configure