Skip to content

Add NOT NULL on sharding key for packages_debian_group_architectures

What does this MR do and why?

Add NOT NULL constraint on the packages_debian_group_architectures sharding key. The sharding key will be used to determine what Organization the row belongs to.

Also updates the desired_sharding_key entry to sharding_key in the table's dictionary as adding the constraint is the final requirement for it to be a fully qualified sharding key.

  • Backfill has been finalized
  • No presence: true check is added in the model because we're also populating the column with a "BEFORE INSERT OR UPDATE" trigger.
    • We have no well-defined plan yet on the removal of triggers but we will make sure that the application code is setting a the value on the column BEFORE removing the trigger.

References

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

N/A

How to set up and validate locally

N/A

Edited by Shane Maglangit

Merge request reports

Loading