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] Update of "OLAPNullOrdering" by BryanPendleton
Date Fri, 20 Jul 2007 16:55:07 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

------------------------------------------------------------------------------
   * The sorter must pass the user's choice to the DataValueDescriptor.compare() method call.
   * The DataValueDescriptor.compare(DataValueDescriptor other) method must be changed to
allow the null ordering choice to be passed in
   * All of the types which implement the compare method must be changed to use the specified
null ordering.
-  * A variety of new test cases must be added to the test suites, and the existing test cases
should all be run to verify that they still pass.
+  * A variety of new test cases must be added to the test suites, including:
+    * There should be tests of ORDER BY clauses with NULLS FIRST specified, insuring that
null values indeed come first.
+    * There should be tests of ORDER BY clauses with NULLS LAST specified, insuring that
null values indeed come last.
+    * There should be tests of ORDER BY clauses with no null ordering clause, insuring that
null values indeed come last.
+    * The tests should include a variety of different data types:
+       * numeric data types
+       * character data types
+       * date/time data types
+       * XML data types?
+    * There should be tests with queries involving UNION / EXCEPT / INTERSECT operators,
ensuring that the NULLS FIRST / NULLS LAST setting is correctly "pushed down" through the
set operation.
+  * The existing test cases should all be run to verify that they still pass.
  

Mime
View raw message