> -----Original Message-----
> From: Jim Starkey [mailto:jstarkey@stripped]
> Sent: Monday, February 02, 2009 5:14 PM
> To: Vladislav Vaintroub
> Cc: 'Lars-Erik Bjørk'; 'FalconDev'
> Subject: Re: NULLs and stuff
> Vlad, can you construct a scenario where someone needs to do a limit
> with an order on a field with both nulls and empty strings, and cares
> about the actual ordering of null strings and empty strings? Even
> constructing a scenario where someone cares about the difference
> between
> null string and empty strings is hard...
Jim, sorry, I cannot. But I'm sure there are enough people who will construct a non-empty
bug report that Falcon sorts against different to ANSI or rest of MySQL . But as we decide
to change how indexes are build anyway, why not to do it in a way that makes NULL special
and uniquely identifiable (for queries where x is NULL) and the sort would conform to
standards at least in some cases. That standard has some strange subtleties is yet another
question.