Order.ignoreCase() doesn't work

Description

This is my My User.hbm.xml:
<class name="User"
table="USERS" schema="TEST" dynamic-insert="true"
dynamic-update="true" lazy="true">
<id name="id" type="long">......</id>

<property name="title" type="string">
<column name="TITLE" />
</property>

<property name="keyword" type="string">
<column name="KEYWORD" />
</property>

<component name="auditInfo"
class="AuditInfo">
<property name="auditStatus"
type="string">
<column name="AUDITSTATUS" />
</property>

<property name="auditTime" type="timestamp">
<column name="AUDITTIME" />
</property>

<many-to-one name="auditUser" column="AUDITMEMBER"
class="Member." lazy="proxy" />
</component>
... ... ...
</class>

AuditInfo.java is a value type, Member.java is another entity

my code fragment as follow:
....
DetachedCriteria detachedCrit = DetachedCriteria.forClass(persistentClass);
Example example = Example.create(exampleInstance);

detachedCrit.add(example) .addOrder(Order.asc("title").ignoreCase())
.addOrder(Order.asc("keyword").ignoreCase())
.addOrder(Order.asc("auditInfo.auditStatus").ignoreCase());
...

the sql on the console as follow :
select .... from
USERS this_,
...
where
...
order by
lower(this_.TITLE) asc,
lower(this_.KEYWORD) asc,
this_.AUDITSTATUS asc

all code run well except the last ignoreCase() !

Environment

oracle10g

Activity

Show:
Brett Meyer
December 14, 2013, 6:05 AM

If this is still an issue on ORM 4.2.x or 4.3, anyone have a test case to attach?

Brett Meyer
December 20, 2013, 9:31 AM

Note: In an attempt to clean up the HHH JIRA, we will be rejecting any ticket that sits in the "Awaiting Test Case" state for 2-3 months with no response. So, if this issue is critical to you, please attach a reproducing test case ASAP. Thanks!

Brett Meyer
March 4, 2014, 2:40 AM

Bulk rejecting issues lacking a test case or recent response.

Rejected

Assignee

Unassigned

Reporter

Weipeng Wang

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major