Skip to content

Remove pipeline_id column from requirements_management_test_reports

Felipe Cardozo requested to merge issue_225154 into master

What does this MR do?

Removes pipeline_id from requirements_management_test_reports. We realized that it was a mistake to add this column.

It is ignored since last release.

related to #225154 (closed)

Migration output

UP 

== 20200807143901 RemovePipelineIdFromTestReports: migrating ==================
-- remove_column(:requirements_management_test_reports, :pipeline_id, :integer)
   -> 0.0033s
== 20200807143901 RemovePipelineIdFromTestReports: migrated (0.0033s) =========

DOWN

== 20200810191256 RemovePipelineIdFromTestReports: reverting ==================
-- add_column(:requirements_management_test_reports, :pipeline_id, :integer)
   -> 0.0018s
-- add_foreign_key(:requirements_management_test_reports, :ci_pipelines, {:column=>:pipeline_id, :on_delete=>:nullify})
   -> 0.0032s
== 20200810191256 RemovePipelineIdFromTestReports: reverted (0.0111s) =========

Table size:

EXPLAIN SELECT id FROM requirements_management_test_reports;
 Index Only Scan using requirements_management_test_reports_pkey on public.requirements_management_test_reports  (cost=0.14..6.64 rows=233 width=8) (actual time=1.186..1.211 rows=233 loops=1)
Edited by Toon Claes

Merge request reports