On Jan 8, 2010, at 2:57 PM, David Avendasora wrote:
> Is there general consensus that the way sorting _should_ work is that null is
> considered to be less-than non-null?
In terms of making Oracle match WO.
Dave
>
> Dave
>
> On Jan 8, 2010, at 2:42 PM, Chuck Hill wrote:
>
>> I'd guess that few of us use Oracle. And few of those use
>> ERXBatchingDisplayGroup with a column containing nulls. IOW, you are just
>> lucky.
>>
>>
>> Chuck
>>
>>
>>
>> On Jan 8, 2010, at 10:37 AM, David Avendasora wrote:
>>
>>> Before I submit the patch, am I really the only one to have run into this
>>> with Oracle? Am I missing something fundamental?
>>>
>>> Dave
>>>
>>> On Jan 8, 2010, at 12:28 PM, David Avendasora wrote:
>>>
>>>> Hi Mike,
>>>>
>>>> Almost perfect. Following your example, here's what I came up with: (patch
>>>> to follow in Jira)
>>>>
>>>> @Override
>>>> public void addOrderByAttributeOrdering(EOSortOrdering sortOrdering) {
>>>> super.addOrderByAttributeOrdering(sortOrdering);
>>>> if (sortOrdering.selector() ==
>>>> EOSortOrdering.CompareCaseInsensitiveDescending
>>>> || sortOrdering.selector() ==
>>>> EOSortOrdering.CompareDescending) {
>>>> _orderByString().append(" NULLS LAST"); // Oracle's Default
>>>> } else {
>>>> _orderByString().append(" NULLS FIRST");
>>>> }
>>>> }
>>>>
>>>> Dave
>>>>
>>>> On Jan 8, 2010, at 10:36 AM, Mike Schrag wrote:
>>>>
>>>>> maybe try something like (completely untested):
>>>>>
>>>>> public void addOrderByAttributeOrdering(EOSortOrdering
>>>>> sortOrdering) {
>>>>> super. addOrderByAttributeOrdering(sortOrdering);
>>>>> _orderByString().append(" NULLS FIRST");
>>>>> }
>>>>>
>>>>> On Jan 8, 2010, at 10:20 AM, David Avendasora wrote:
>>>>>
>>>>>> Hi all,
>>>>>>
>>>>>> This has taken me a while to track down, and I just want to make sure
>>>>>> I've figured it out correctly, and if so, what the possible solutions
>>>>>> are.
>>>>>>
>>>>>> Oracle sorts null values to the end, so ORDER BY FIRST_NAME returns:
>>>>>>
>>>>>> Anjo
>>>>>> Chunk
>>>>>> Mike
>>>>>> Null
>>>>>>
>>>>>> EOSortOrdering sorts null values to the begining, so NAME.ascs() returns:
>>>>>> Null
>>>>>> Anjo
>>>>>> Chunk
>>>>>> Mike
>>>>>>
>>>>>> Which does some really crazy things to ERXBatchingDisplayGroup.
>>>>>>
>>>>>> Let's say I have 100 rows in the DG. All the Name attributes are null,
>>>>>> except for those three.
>>>>>>
>>>>>> First the DB selects all the records and sorts them with nulls last,
>>>>>> then gets the first 10 ids :
>>>>>>
>>>>>> select * from (select NAME, rownum eo_rownum from (SELECT t0.NAME FROM
>>>>>> PEOPLE t0 ORDER BY t0.NAME ASC)) where eo_rownum between 1 and 10
>>>>>>
>>>>>> The results will be: Anjo, Chunk, Mike, null, null, null, null, null,
>>>>>> null, null.
>>>>>>
>>>>>> Then EOF sorts the array again, so the DG displays: null, null, null,
>>>>>> null, null, null, null, Anjo, Chunk, Mike and all the subsequent batches
>>>>>> will be full of nulls.
>>>>>>
>>>>>> If this interpretation is correct, am I the first to run into this with
>>>>>> Oracle?
>>>>>>
>>>>>> I've been digging through the EROraclePlugin, and I figured adding this
>>>>>> to the EROracleExpression class would fix it, but it doesn't:
>>>>>>
>>>>>> @Override
>>>>>> protected void appendItemToOrderByString(String sqlString) {
>>>>>> appendItemToListString(sqlString + " NULLS FIRST",
>>>>>> _orderByString());
>>>>>> }
>>>>>>
>>>>>> Anyone have any other suggestions?
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Dave
>>>>>> _______________________________________________
>>>>>> Do not post admin requests to the list. They will be ignored.
>>>>>> Webobjects-dev mailing list ([email protected])
>>>>>> Help/Unsubscribe/Update your Subscription:
>>>>>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com
>>>>>>
>>>>>> This email sent to [email protected]
>>>>>
>>>>
>>>> _______________________________________________
>>>> Do not post admin requests to the list. They will be ignored.
>>>> Webobjects-dev mailing list ([email protected])
>>>> Help/Unsubscribe/Update your Subscription:
>>>> http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com
>>>>
>>>> This email sent to [email protected]
>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list ([email protected])
>>> Help/Unsubscribe/Update your Subscription:
>>> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>>>
>>> This email sent to [email protected]
>>
>> --
>> Chuck Hill Senior Consultant / VP Development
>>
>> Practical WebObjects - for developers who want to increase their overall
>> knowledge of WebObjects or who are trying to solve specific problems.
>> http://www.global-village.net/products/practical_webobjects
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com
>
> This email sent to [email protected]
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
