SQLQuery in read() always sorts null values first
Hi,
When I run this query in the space browser of the GigaSpaces Management Center:
select uid,* from Unit where location = '01' and customer = '6031' order by unitModel desc
Rows with a null value in unitModel always display first regardless of the (desc/asc) in the order by clause.
Is there a way to control this behavior? I would like null values to always sort lowest (first if asc/ last if desc).
Thanks, Jackie
{quote}This thread was imported from the previous forum. For your reference, the original is [available here|http://forum.openspaces.org/thread.jspa?threadID=2743]{quote}