Step 1: Prepare `ci_build_needs` for bigint conversion
What does this MR do and why?
Prepares ci_build_needs.id
conversion to bigint. This is step 1/4.
Related to:
Up
ci: == 20230130104819 InitializeConversionOfCiBuildNeedsToBigint: migrating =======
ci: -- table_exists?(:ci_build_needs)
ci: -> 0.0451s
ci: -- column_exists?(:ci_build_needs, :id)
ci: -> 0.0025s
ci: -- column_exists?(:ci_build_needs, :id)
ci: -> 0.0010s
ci: -- transaction_open?()
ci: -> 0.0000s
ci: -- columns(:ci_build_needs)
ci: -> 0.0010s
ci: -- add_column(:ci_build_needs, "id_convert_to_bigint", :bigint, {:default=>0, :null=>false})
ci: -> 0.0010s
ci: == 20230130104819 InitializeConversionOfCiBuildNeedsToBigint: migrated (0.0602s)
ci: == 20230130110855 BackfillCiBuildNeedsForBigIntConversion: migrating ==========
ci: -- table_exists?(:ci_build_needs)
ci: -> 0.0007s
ci: -- column_exists?(:ci_build_needs, :id)
ci: -> 0.0014s
ci: -- column_exists?(:ci_build_needs, :id)
ci: -> 0.0011s
ci: -- column_exists?(:ci_build_needs, "id_convert_to_bigint")
ci: -> 0.0011s
ci: == 20230130110855 BackfillCiBuildNeedsForBigIntConversion: migrated (0.0334s) =
Down
ci: == 20230130110855 BackfillCiBuildNeedsForBigIntConversion: reverting ==========
ci: -- execute("DELETE FROM batched_background_migrations WHERE job_class_name = 'CopyColumnUsingBackgroundMigrationJob' AND table_name = 'ci_build_needs' AND column_name = 'id' AND job_arguments = '[[\"id\"],[\"id_convert_to_bigint\"]]'")
ci: -> 0.0031s
ci: == 20230130110855 BackfillCiBuildNeedsForBigIntConversion: reverted (0.0085s) =
ci: == 20230130104819 InitializeConversionOfCiBuildNeedsToBigint: reverting =======
ci: -- remove_column(:ci_build_needs, "id_convert_to_bigint")
ci: -> 0.0005s
ci: == 20230130104819 InitializeConversionOfCiBuildNeedsToBigint: reverted (0.0081s)
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Laura Montemayor