acf-weblog does not return results in specified order when running an ad-hoc query
Received this acf-weblog enhancement request from an end-user:
In ACF Weblog ->Ad-Hoc Query, we have seen that select-list items are not returned by the specified order.
For example, the statement below is one of the examples in the Ad-Hoc Query page.
SELECT extract(hour from date) AS hour, sum(numrequest) AS numrequest,sum(numblock) AS numblock FROM usagestat GROUP BY extract(hour from date) ORDER BY hour
When this statement is submitted, the select-list items are returned in the order of numrequest, hour and numblock, instead of hour, numrequest and numblock. Even if the order is changed in the statement, the result is still the same.
The version for some of the packages in our web proxy are as follows: alpine-base 2.2.3-r0, acf-postgresql 0.4.0-r0, acf-weblog 0.6.1-r0, postgresql 9.0.5-r0, postgresql-client 9.0.5-r0.
Thanks for taking a look.
(from redmine: issue id 997, created on 2012-02-06, closed on 2013-12-09)