summaryrefslogtreecommitdiff
path: root/db/migrate/20200609212701_add_incident_settings_to_all_existing_projects.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20200609212701_add_incident_settings_to_all_existing_projects.rb')
-rw-r--r--db/migrate/20200609212701_add_incident_settings_to_all_existing_projects.rb2
1 files changed, 1 insertions, 1 deletions
diff --git a/db/migrate/20200609212701_add_incident_settings_to_all_existing_projects.rb b/db/migrate/20200609212701_add_incident_settings_to_all_existing_projects.rb
index 60286e0dca6..a2931824ef5 100644
--- a/db/migrate/20200609212701_add_incident_settings_to_all_existing_projects.rb
+++ b/db/migrate/20200609212701_add_incident_settings_to_all_existing_projects.rb
@@ -8,7 +8,7 @@ class AddIncidentSettingsToAllExistingProjects < ActiveRecord::Migration[6.0]
# to preserve behavior for existing projects that
# are using the create issue functionality with the default setting of true
query = <<-SQL
- WITH project_ids AS (
+ WITH project_ids AS #{Gitlab::Database::AsWithMaterialized.materialized_if_supported}(
SELECT DISTINCT issues.project_id AS id
FROM issues
LEFT OUTER JOIN project_incident_management_settings