Skip to content

Temporarily allow cross-db foreign keys to exist

Manoj M J requested to merge mmj-temp-allow-cross-db-foreign-keys into master

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.

Edited by Manoj M J

Merge request reports