From 42a9eea79186c02f1fdccec886d1202adb33fcf6 Mon Sep 17 00:00:00 2001 From: Lin Jen-Shin Date: Tue, 27 Jun 2017 21:14:38 +0800 Subject: Better indent the SQL --- .../20170622135451_rename_duplicated_variable_key.rb | 17 ++++++++++------- 1 file changed, 10 insertions(+), 7 deletions(-) (limited to 'db/migrate/20170622135451_rename_duplicated_variable_key.rb') diff --git a/db/migrate/20170622135451_rename_duplicated_variable_key.rb b/db/migrate/20170622135451_rename_duplicated_variable_key.rb index b88e7d7ba81..1005a212131 100644 --- a/db/migrate/20170622135451_rename_duplicated_variable_key.rb +++ b/db/migrate/20170622135451_rename_duplicated_variable_key.rb @@ -7,15 +7,18 @@ class RenameDuplicatedVariableKey < ActiveRecord::Migration def up execute(<<~SQL) - UPDATE ci_variables SET #{key} = CONCAT(#{key}, #{underscore}, id) + UPDATE ci_variables + SET #{key} = CONCAT(#{key}, #{underscore}, id) WHERE id IN ( - SELECT * FROM ( -- MySQL requires an extra layer - SELECT dup.id FROM ci_variables dup - INNER JOIN (SELECT max(id) AS id, #{key}, project_id - FROM ci_variables tmp - GROUP BY #{key}, project_id) var + SELECT * + FROM ( -- MySQL requires an extra layer + SELECT dup.id + FROM ci_variables dup + INNER JOIN (SELECT max(id) AS id, #{key}, project_id + FROM ci_variables tmp + GROUP BY #{key}, project_id) var USING (#{key}, project_id) where dup.id <> var.id - ) dummy + ) dummy ) SQL end -- cgit v1.2.1