diff options
| author | Stan Hu <stanhu@gmail.com> | 2017-12-27 03:22:46 -0800 |
|---|---|---|
| committer | Stan Hu <stanhu@gmail.com> | 2017-12-27 04:12:18 -0800 |
| commit | dfdf22c7d8a9e4776a0e3bfc130ef47aff911022 (patch) | |
| tree | c8f8a641f2da3a35417a0f147bec1bfcda9e3c68 /db | |
| parent | 5cacdc4ec1f63338fab923ddb657fdba0a7e6300 (diff) | |
| download | gitlab-ce-dfdf22c7d8a9e4776a0e3bfc130ef47aff911022.tar.gz | |
Fix PostgreSQL implementation of migrationsh-fix-mysql-migration-10-3
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20171106151218_issues_moved_to_id_foreign_key.rb | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/db/migrate/20171106151218_issues_moved_to_id_foreign_key.rb b/db/migrate/20171106151218_issues_moved_to_id_foreign_key.rb index 18c2b294c1e..6368e5bd9ce 100644 --- a/db/migrate/20171106151218_issues_moved_to_id_foreign_key.rb +++ b/db/migrate/20171106151218_issues_moved_to_id_foreign_key.rb @@ -15,7 +15,9 @@ class IssuesMovedToIdForeignKey < ActiveRecord::Migration self.table_name = 'issues' def self.with_orphaned_moved_to_issues - where('NOT EXISTS (SELECT true FROM issues WHERE issues.id = issues.moved_to_id)') + # Be careful to use a second table here for comparison otherwise we'll null + # out all rows that don't have id == moved_to_id! + where('NOT EXISTS (SELECT true FROM issues b WHERE issues.moved_to_id = b.id)') .where('moved_to_id IS NOT NULL') end end |