Backfill issues.correct_work_item_type_id with correct value

What does this MR do and why?

We need to backfill all issue records as we want to use this new column to filter by work item type temporarily

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

DB review

DB plans

https://console.postgres.ai/gitlab/gitlab-production-main/sessions/32262/commands/99684

SELECT 
  issues.id 
FROM 
  issues 
WHERE 
  issues.id BETWEEN 4 
  AND 14366 
  AND issues.id >= 4 
ORDER BY 
  issues.id ASC 
LIMIT 
  1 OFFSET 50

https://console.postgres.ai/gitlab/gitlab-production-main/sessions/32262/commands/99685

SELECT 
  min(id), 
  max(id) 
FROM 
  issues 
WHERE 
  issues.id BETWEEN 4 
  AND 14366 
  AND issues.id >= 4 
  AND issues.id < 108 
LIMIT 
  1

https://console.postgres.ai/gitlab/gitlab-production-main/sessions/32262/commands/99686

UPDATE 
  issues 
SET 
  correct_work_item_type_id = work_item_types.correct_id 
FROM 
  work_item_types 
WHERE 
  issues.work_item_type_id = work_item_types.id 
  AND issues.id BETWEEN 4 
  AND 107

Migration output

UP

main: == [advisory_lock_connection] object_id: 129180, pg_backend_pid: 71173
main: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: migrating =========
main: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: migrated (0.0530s) 

main: == [advisory_lock_connection] object_id: 129180, pg_backend_pid: 71173
ci: == [advisory_lock_connection] object_id: 129600, pg_backend_pid: 71175
ci: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: migrating =========
ci: -- The migration is skipped since it modifies the schemas: [:gitlab_main].
ci: -- This database can only apply migrations in one of the following schemas: [:gitlab_ci, :gitlab_internal, :gitlab_shared].
ci: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: migrated (0.0073s) 

ci: == [advisory_lock_connection] object_id: 129600, pg_backend_pid: 71175

DOWN

main: == [advisory_lock_connection] object_id: 128740, pg_backend_pid: 69358
main: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: reverting =========
main: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: reverted (0.0454s) 

main: == [advisory_lock_connection] object_id: 128740, pg_backend_pid: 69358
ci: == [advisory_lock_connection] object_id: 138500, pg_backend_pid: 69620
ci: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: reverting =========
ci: -- The migration is skipped since it modifies the schemas: [:gitlab_main].
ci: -- This database can only apply migrations in one of the following schemas: [:gitlab_ci, :gitlab_internal, :gitlab_shared].
ci: == 20241002185804 QueueBackfillIssuesCorrectWorkItemTypeId: reverted (0.0159s) 

ci: == [advisory_lock_connection] object_id: 138500, pg_backend_pid: 69620

Related to #493975 (closed)