Skip to content

WIP: Change state to integer for issuables

Felipe Cardozo requested to merge ee-issue_51789 into master

What does this MR do?

Convert merge requests and issues state column to integer.

Warning!

This merge requests adds a migration which updates two big tables merge_requests and issues

  • Before migration state column values: "opened" "closed" "merged" "locked"
  • After migration state column values: 1 2 3 4

How is the migration working:

  1. Creates a temporary column called new_state on each table
  2. Migrates the new converted to integer values to the new column
  3. Removes state column
  4. Renames new_state to state
  5. Rebuild related indexes with the new column

What are the relevant issue numbers?

closes https://gitlab.com/gitlab-org/gitlab-ce/issues/51789

Does this MR meet the acceptance criteria?

Edited by Coung Ngo

Merge request reports