From 6b71b225f66f9240df6e0cd7519fbac3028b96fc Mon Sep 17 00:00:00 2001 From: Oswaldo Ferreira Date: Tue, 19 Dec 2017 00:09:02 +0000 Subject: Merge branch 'sh-fix-milestone-id-migration' into 'master' Fix missing WHERE clause in 20171106135924_issues_milestone_id_foreign_key migration Closes gitlab-com/infrastructure#3416 See merge request gitlab-org/gitlab-ce!15997 --- db/migrate/20171106135924_issues_milestone_id_foreign_key.rb | 1 + 1 file changed, 1 insertion(+) diff --git a/db/migrate/20171106135924_issues_milestone_id_foreign_key.rb b/db/migrate/20171106135924_issues_milestone_id_foreign_key.rb index e6a780d0964..bfb3dcae511 100644 --- a/db/migrate/20171106135924_issues_milestone_id_foreign_key.rb +++ b/db/migrate/20171106135924_issues_milestone_id_foreign_key.rb @@ -16,6 +16,7 @@ class IssuesMilestoneIdForeignKey < ActiveRecord::Migration def self.with_orphaned_milestones where('NOT EXISTS (SELECT true FROM milestones WHERE milestones.id = issues.milestone_id)') + .where('milestone_id IS NOT NULL') end end -- cgit v1.2.1