Skip to content

Load correct iteration on iteration report

Simon Knox requested to merge psi-iteration-iid-fix into master

What does this MR do?

Found while unquarantining spec for #222915 (closed)

The following test previously failed (so one was quarantined:

bin/spring rspec ./ee/spec/features/issues/issue_sidebar_spec.rb ./ee/spec/features/groups/iterations/user_views_iteration_spec.rb

Database queries

Query:

SELECT "sprints".*
FROM (
        (SELECT "sprints".*
         FROM "sprints"
         WHERE "sprints"."iid" = 1
           AND 1=0)
      UNION ALL
        (SELECT "sprints".*
         FROM "sprints"
         WHERE "sprints"."iid" = 1
           AND "sprints"."group_id" = 9970)) sprints
WHERE "sprints"."iid" = 1
ORDER BY due_date ASC NULLS LAST,
                      "sprints"."title" ASC
LIMIT 100

Execution plan:

Limit  (cost=3.17..3.17 rows=1 width=186) (actual time=0.214..0.214 rows=0 loops=1)
   Buffers: shared hit=9 read=1
   I/O Timings: read=0.106
   ->  Sort  (cost=3.17..3.17 rows=1 width=186) (actual time=0.213..0.214 rows=0 loops=1)
         Sort Key: sprints.due_date, sprints.title
         Sort Method: quicksort  Memory: 25kB
         Buffers: shared hit=9 read=1
         I/O Timings: read=0.106
         ->  Append  (cost=0.12..3.16 rows=1 width=186) (actual time=0.126..0.126 rows=0 loops=1)
               Buffers: shared hit=3 read=1
               I/O Timings: read=0.106
               ->  Index Scan using index_sprints_on_group_id_and_title on public.sprints  (cost=0.12..3.15 rows=1 width=186) (actual time=0.124..0.124 rows=0 loops=1)
                     Index Cond: (sprints.group_id = 9970)
                     Filter: (sprints.iid = 1)
                     Rows Removed by Filter: 0
                     Buffers: shared hit=3 read=1
                     I/O Timings: read=0.106

Timings:

Time: 0.568 ms
  - planning: 0.303 ms
  - execution: 0.265 ms
    - I/O read: 0.106 ms
    - I/O write: 0.000 ms

Shared buffers:
  - hits: 9 (~72.00 KiB) from the buffer pool
  - reads: 1 (~8.00 KiB) from the OS file cache, including disk I/O
  - dirtied: 0
  - writes: 0
Edited by Toon Claes

Merge request reports