Unified sort order for null value
---------------------------------
Key: NXP-8003
URL: https://jira.nuxeo.com/browse/NXP-8003
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Components: Core SQL Storage
Affects Versions: 5.4.2
Reporter: Benoit Delbosc
The sort order for null value is database sensitive:
- Oracle and PostgreSQL will sort nulls first for DESC order, and nulls last
otherwise
- SQL Server, H2 and MySQL sort nulls last for DESC order
This problem impacts the suggestion ordering on PostgreSQL and Oracle.
PostgreSQL and Oracle support the "ORDER BY foo DESC NULLS LAST" syntax,
so we can have the same behavior on all database.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
