Bug in JQL results

[Ofek Ron]

project = PIC AND component = Portal AND status = Done AND ("Approved For" >= "Portal 2.1.23" OR "Approved For" is EMPTY) AND fixVersion >= "Portal 2.1.23" ORDER BY "Approved For" ASC, fixVersion ASC

Returns list containing fixVersion = "Portal 2.1.16". How come????

[Nic Brough -Adaptavist-]

It's a problem with the way versions are ordered and what we humans would use.  Versions are not ordered by their name, there's an order in the database that gets used.

It's explained a lot better than I can at https://jira.atlassian.com/browse/JRASERVER-22995

It's rather a frustrating one, because I'd like to see the order based on the release dates, not name or arbitrary order from the data I don't work with much.  But by name would work better for some.