openstack/nova — pull request #13 by judu (2012-06-28 14:23:00+00:00)
Title: Order by 'coalesced' value

The _service_get_all_topic_subquery function orders by `label` and coalesce
`label` (with default 0). On Postgresql, is geater than any number.
So we need to order by the coalesced value, not the (maybe empty) `label`.

I encountered the problem when I saw that with postgres, when we query the hosts with their use. the already used one is always on top of the result, because empty fields are not sorted the right way.

I will talk to the postgres crowd about that behaviour.