Convert `ci_pipeline_chat_data.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 | !125965 (merged) | workflowcomplete | %16.3 |
Confirm backfill is finished and Async Create index similar to index_ci_pipeline_chat_data_on_pipeline_id
|
!128716 (merged) | workflowin dev | %16.4 |
Sync Create index and add foreign key constraint | %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