#654: Rows in ticket query result set not sorted by column
---------------------------+-----------------------------------
Reporter: olemis | Owner: gjm
Type: defect | Status: accepted
Priority: blocker | Milestone: Release 8
Component: multiproduct | Version:
Resolution: | Keywords: ticket query, sorting
---------------------------+-----------------------------------
Comment (by olemis):
Replying to [comment:11 gjm]:
> OK, I think I am finally getting to the bottom of this. The issue
appears to be that in SQL you cannot rely on the ordering of a subquery to
maintain order in the outer query.
>
> If we don't wish to adjust the sql within {{{trac.ticket.query.Query}}}
then the only ways I can think of to fix this at the moment involve
capturing and editing the sql produced by that module rather than wrapping
changes around it
This issue is only happening in that particular instance in production
code . I will create a backup with relevant data so as to test your
suggestion in my local working copy . I'll report my findings soon after
that .
[...]
--
Ticket URL: <https://issues.apache.org/bloodhound/ticket/654#comment:12>
Apache Bloodhound <https://issues.apache.org/bloodhound/>
The Apache Bloodhound issue tracker
