From: Ann W. Harrison
Date: January 30 2009 9:33pm
Subject: Re: NULLs and stuff
List-Archive: http://lists.mysql.com/falcon/470
Message-Id: <49837233.2000901@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=ISO-8859-1
Content-Transfer-Encoding: 7BIT


> 
> The problem is that NULL values sort together with numeric zero. 

I may have been carried away with the compatibility issue and
missed something more important.  NULL is supposed to sort first -
meaning that nulls come before all values, not just before zero.
How does extending the zeros help the case where some of the
stored values are negative?

Best,

Ann