Improve readability of build stage id migration query

1 files changed, 7 insertions, 6 deletions

diff --git a/lib/gitlab/background_migration/migrate_build_stage_id_reference.rb b/lib/gitlab/background_migration/migrate_build_stage_id_reference.rb
index 711126ea0d3..c8669ca3272 100644
--- a/lib/gitlab/background_migration/migrate_build_stage_id_reference.rb
+++ b/lib/gitlab/background_migration/migrate_build_stage_id_reference.rb
@@ -5,12 +5,13 @@ module Gitlab
         raise ArgumentError unless id.present?
 
         sql = <<-SQL.strip_heredoc
-          UPDATE "ci_builds" SET "stage_id" = (
-            SELECT id FROM ci_stages
-              WHERE ci_stages.pipeline_id = ci_builds.commit_id
-              AND ci_stages.name = ci_builds.stage
-            )
-          WHERE "ci_builds"."id" = #{id} AND "ci_builds"."stage_id" IS NULL
+          UPDATE "ci_builds"
+            SET "stage_id" =
+              (SELECT id FROM ci_stages
+                WHERE ci_stages.pipeline_id = ci_builds.commit_id
+                AND ci_stages.name = ci_builds.stage)
+          WHERE "ci_builds"."id" = #{id}
+            AND "ci_builds"."stage_id" IS NULL
         SQL
 
         ActiveRecord::Base.connection.execute(sql)