db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Trivial Update of "OLAPNullOrdering" by BryanPendleton
Date Fri, 20 Jul 2007 03:37:23 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by BryanPendleton:
http://wiki.apache.org/db-derby/OLAPNullOrdering

------------------------------------------------------------------------------
  }
  }}}
  
- (As an aside, I wonder if there once was a time when NULL values sorted low in Derby, rather
than sorting HIGH. The reason I think this might have been true is that the JavaDoc for {{{DataValueDescriptor.compare()}}}
is incorrect, and says that null will be treated as '''less''' than all other values, and
also the code comment in NumberDataType.java is backward. Thirdly, the code in SQLBoolean.java
seems backward, which might be an un-noticed bug because the boolean data type is not surfaced
to users in current Derby?)
+ (As an aside, I wonder if there once was a time when NULL values sorted low in Derby, rather
than sorting HIGH. The reason I think this might have been true is that the JavaDoc for {{{DataValueDescriptor.compare()}}}
is incorrect, and says that null will be treated as '''less''' than all other values, and
also the code comment in NumberDataType.java is backward. Thirdly, the code in SQLBoolean.java
and in XML.java seems backward, which might be an un-noticed bug because the boolean data
type is not surfaced to users in current Derby, and the XML type is now and not much used
yet?)
  
  == Proposed Changes ==
  

Mime
View raw message