Issue Details (XML | Word | Printable)

Key: DERBY-134
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Tomohito Nakayama
Reporter: Navin Melville
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Derby

Sorted string columns are sorted in a case sensitive way

Created: 01/Feb/05 04:09 AM   Updated: 03/Mar/07 03:20 AM
Return to search
Component/s: JDBC
Affects Version/s: None
Fix Version/s: 10.1.1.0

Time Tracking:
Issue & Sub-Tasks
Issue Only
Not Specified

File Attachments:
  Size
Text File Licensed for inclusion in ASF works DERBY-134.20050328_2.patch 2005-03-30 08:13 PM Tomohito Nakayama 29 kB
HTML File lesb3w.html 2007-03-03 03:20 AM 0.0 kB
Environment: Windows (XP & 2000)

Resolution Date: 29/Apr/05 04:26 PM

Sub-Tasks  All   Open   
No sub-tasks match this view.

 Description  « Hide
Sorted string columns are sorted in a case sensitive way. In other databases we achieve case insensitive search by calling the lower() function in order by. However, in Derby lower function cannot be called on parameters specified in order by. You can do select lower(name) … but not order by lower(name).

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Tomohito Nakayama added a comment - 30/Mar/05 08:13 PM
Please see series of mails "About improvement of DERBY-134" for detail.

Satheesh Bandaram added a comment - 29/Apr/05 04:26 PM
Fix provided by Tomohito Nakayama. Submitted by Satheesh.

Satheesh Bandaram added a comment - 29/Apr/05 04:27 PM
This issue has been addressed. Thanks much to Tomohito.