Drop merge_requests_closing_issues.closes_work_item column
What does this MR do and why?
The column was never used and now can be safely removed as described in #465389 (closed)
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
Console output
UP
bin/rails db:migrate
main: == [advisory_lock_connection] object_id: 127920, pg_backend_pid: 69673
main: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: migrating
main: -- remove_column(:merge_requests_closing_issues, :closes_work_item)
main: -> 0.0028s
main: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: migrated (0.0060s)
main: == [advisory_lock_connection] object_id: 127920, pg_backend_pid: 69673
ci: == [advisory_lock_connection] object_id: 128300, pg_backend_pid: 69675
ci: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: migrating
ci: -- remove_column(:merge_requests_closing_issues, :closes_work_item)
ci: -> 0.0040s
ci: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: migrated (0.0096s)
ci: == [advisory_lock_connection] object_id: 128300, pg_backend_pid: 69675
DOWN
bin/rails db:rollback:main db:rollback:ci
main: == [advisory_lock_connection] object_id: 127580, pg_backend_pid: 71922
main: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: reverting
main: -- add_column(:merge_requests_closing_issues, :closes_work_item, :boolean, {:default=>true, :null=>false})
main: -> 0.0037s
main: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: reverted (0.0065s)
main: == [advisory_lock_connection] object_id: 127580, pg_backend_pid: 71922
ci: == [advisory_lock_connection] object_id: 128780, pg_backend_pid: 72170
ci: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: reverting
ci: -- add_column(:merge_requests_closing_issues, :closes_work_item, :boolean, {:default=>true, :null=>false})
ci: -> 0.0034s
ci: == 20240618174204 RemoveMergeRequestsClosingIssuesClosesWorkItemColumn: reverted (0.0113s)
ci: == [advisory_lock_connection] object_id: 128780, pg_backend_pid: 72170
Related to #465389 (closed)
Edited by Mario Celi