Support for order by nulls first/last
-------------------------------------
Key: OFBIZ-3740
URL: https://issues.apache.org/jira/browse/OFBIZ-3740
Project: OFBiz
Issue Type: Bug
Components: framework
Affects Versions: SVN trunk
Reporter: Bob Morley
Priority: Minor
Fix For: SVN trunk
Attachments: OFBIZ-3740_SupportOrderByNulls.patch
This patch provides the fundamentals to resolve an issue where the sorting of
null values were inconsistent (sometimes sorting first and other times sorting
last). Specifically, this patch allows one to create an order-by clause via
any of the order-by elements of "-myField NULLS LAST" where this text parses
out the - (as descending) and the "nulls last".
Since not all databases support the "nulls" argument on an order by clause (it
was introduced as part of the OLAP support specification) , our
entity-engine.xml file allows each data source to indicate if it has this
support. If the support does not exist and nulls first/last is specified, the
sql that is generated uses native sql to simulate the nulls first/last intent.
At this time, the derby, postgres, and oracle databases are marked to use the
nulls first grammar.
Right now, if you do not specify "NULLS XXX" in the field-name for the order-by
it makes no change whatsever (naturally this assumption could be changed to
have a default).
It should be noted, that my intent here was ultimately to "properly" model the
order by into something whose xml representation could look something like ...
<entity-order-by field-name="fieldName" ascending="true" nulls-first="true" />
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
