[
https://jira.nuxeo.com/browse/NXP-8003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benoit Delbosc resolved NXP-8003.
---------------------------------
Resolution: Fixed
Fix Version/s: 5.5
Fixed http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/71d849a48d54
> 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
> Fix For: 5.5
>
>
> 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
