Description of problem: In bug list, flags are not ordered correctly Version-Release number of selected component (if applicable): 4.4-3.5 How reproducible: always Steps to Reproduce: 1. Do a query 2. Change columns to include flags Actual results: Flags seem to be ordered alphabetically. (eg bugzilla-4.4?, hss_devel_ack+, hss_pm_ack?, hss_qa_ack? ) Expected results: Flags should be ordered according to the flag sort order (eg bugzilla-4.4?, hss_pm_ack?, hss_devel_ack+, hss_qa_ack? Additional info:
Changing the estimate to five hours, since the solution needs to be database agnostic.
SQLite: https://www.sqlite.org/lang_aggfunc.html "The order of the concatenated elements is arbitrary." Oracle: Someone can work on changing the PL/SQL if they wish Postgres: http://mssql-to-postgresql.blogspot.com.au/2007/12/cool-groupconcat.html http://explainextended.com/2009/05/02/group_concat-in-postgresql-without-aggregate-functions/ (maybe others) Original upstream bug: https://bugzilla.mozilla.org/show_bug.cgi?id=552919
It's easy for Postgres 9+ see http://stackoverflow.com/questions/2560946/postgresql-group-concat-equivalent So I've written the change for Mysql and Pg 9+ and will test it tomorrow and submit it upstream. If someone wants to work on it for earlier versions of Pg or Oracle or Sqlite, they can. Otherwise the code will still work (just not be ordered).
This change is now live. If there are any issues, do not reopen this bug. Instead, you should create a new bug and reference this bug. -- simon