Convert `ci_pipeline_variables.pipeline_id` to bigint
Problem
This column references the ci_pipelines
table and its column type is not bigint.
Process
Following the process outlined here, we must:
Step | MR | Workflow Status | Milestone |
---|---|---|---|
Initialize the conversion and ignore column | !123132 (merged) | workflowcomplete | %16.2 |
Confirm backfill is finished and Async Create index |
!125188 (merged) !128719 (merged) |
workflowcomplete workflowcomplete |
%16.3 |
Sync Create index | !127449 (merged) | workflowcomplete | %16.3 |
Add not valid foreign key constraint Async validate foreign key constraint |
!127445 (merged) | workflowverification | %16.3 |
Sync validate foreign key constraint | !129199 (merged) | workflowin dev | %16.4 |
Swap the columns | %16.4 | ||
Remove the trigger and old integer columns | %16.5 | ||
Remove ignore rules | %16.6 |
Edited by Tianwen Chen