Bug 364729 - JET XPath sort function sorts in ASCII order
Summary: JET XPath sort function sorts in ASCII order
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Jet (show other bugs)
Version: unspecified   Edit
Hardware: PC Linux
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-24 11:42 EST by Dave Nice CLA
Modified: 2020-05-01 16:11 EDT (History)
2 users (show)

See Also:

Attachments
I suggest using a Collator rather than String.compareTo (626 bytes, patch)
2011-11-24 11:43 EST, Dave Nice CLA 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dave Nice CLA 2011-11-24 11:42:22 EST 
Build Identifier: 3.6.1 M20110210-1200

When I use the xpath sort function within Jet, my users complain that the sort is not as expected.  Specifically, sort order is:

AA
AB
Aa

Rather than
AA
Aa
AB

I suggest that the sort defaults to using a natural sort order, rather than ASCII sort order

Reproducible: Always

Steps to Reproduce:
1. Create XML data including the items AB, AA, Aa
2. Sort using the XPath sort function in JET
3. Expected result is order AA, Aa, AB
Comment 1 Dave Nice CLA 2011-11-24 11:43:32 EST 
Created attachment 207487 [details]
I suggest using a Collator rather than String.compareTo