Temporarily allow cross-db foreign keys to exist
What does this MR do and why?
For #421000 (closed)
Based on the discussion in !127719 (comment 1498774915).
Need for change
We can temporarily allow cross-database join queries to exist (without raising errors) by using the method allow_cross_joins_across_databases
.
However, no such method exists to currently allow cross-database foreign keys to exist temporarily, which needs to be converted to loose foreign keys.
While we are building out Cells, we will be moving tables from gitlab_main
schema
to either gitlab_main_clusterwide
schema or gitlab_main_cell
schema.
During this transition phase, cross-database foreign keys need
to be temporarily allowed to exist, until we can work on converting these columns to loose foreign keys.
Screenshots or screen recordings
Screenshots are required for UI changes, and strongly recommended for all other merge requests.
Before | After |
---|---|
How to set up and validate locally
Numbered steps to set up and validate the change are strongly suggested.
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.