Re: Oracle and Sorting Null Values - everyone thinks different - everyone is correct
Re: Oracle and Sorting Null Values - everyone thinks different - everyone is correct
- Subject: Re: Oracle and Sorting Null Values - everyone thinks different - everyone is correct
- From: David Avendasora <email@hidden>
- Date: Mon, 11 Jan 2010 12:23:28 -0500
Hi Aaron!In summary, it doesn't matter if you "fix" the DB or you fix the in-memory sorting as we have done. What matters is that you realize there can be differences and you have full control over how you want sorting to work no matter what DB you use.
I agree completely. Sorting nulls isn't technically valid in the first place but in practical terms you need to do something with them. Since we have conflicting needs, I think we should come up with a property that will define how nulls are sorted so that both your solution and a DB-specific one (if available) are triggered based on the preference.
something along the lines of: nullSortOrdering=first/last
What do you think?
Based on your email, I will update the Jira PATCH ticket I submitted to hold off on applying it so we can better address this.
Dave |
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden