Skip to content
  • Douwe Maan's avatar
    Merge branch... · 3c04c89ee61a
    Douwe Maan authored
    Merge branch '17227-upcoming-milestone-is-confusing-when-projects-have-different-milestones' into 'master'
    
    Make upcoming milestone work across projects
    
    Before: we took the next milestone due across all projects in the
    search and found issues whose milestone title matched that
    one. Problems:
    
    1. The milestone could be closed.
    2. Different projects have milestones with different schedules.
    3. Different projects have milestones with different titles.
    4. Different projects can have milestones with different schedules, but
       the _same_ title. That means we could show issues from a past
       milestone, or one that's far in the future.
    
    After: gather the ID of the next milestone on each project we're looking
    at, and find issues with those milestone IDs. Problems:
    
    1. For a lot of projects, this can return a lot of IDs.
    2. The SQL query has to be different between Postgres and MySQL, because
       MySQL is much more lenient with HAVING: as well as the columns
       appearing in GROUP BY or in aggregate clauses, MySQL allows them to
       appear in the SELECT list (un-aggregated).
    
    Closes #17227.
    
    See merge request !4125
    3c04c89ee61a
To find the state of this project's repository at the time of any of these versions, check out the tags.