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/archive%40mail-archive.com
This email sent to [email protected]
