From d64673c8fe00539a5e5c21c334d92f689e916444 Mon Sep 17 00:00:00 2001
From: Yasuo Honda <yasuo.honda@gmail.com>
Date: Mon, 24 Feb 2014 22:33:43 +0900
Subject: Skip test_migrate_revert_add_index_with_name if databases do not
 allow to create duplicate indexes on the same columns

---
 .../test/cases/invertible_migration_test.rb        | 23 ++++++++++++----------
 1 file changed, 13 insertions(+), 10 deletions(-)

diff --git a/activerecord/test/cases/invertible_migration_test.rb b/activerecord/test/cases/invertible_migration_test.rb
index debacf815c..2b1749cf70 100644
--- a/activerecord/test/cases/invertible_migration_test.rb
+++ b/activerecord/test/cases/invertible_migration_test.rb
@@ -271,16 +271,19 @@ module ActiveRecord
       ActiveRecord::Base.table_name_prefix = ActiveRecord::Base.table_name_suffix = ''
     end
 
-    def test_migrate_revert_add_index_with_name
-      RevertNamedIndexMigration1.new.migrate(:up)
-      RevertNamedIndexMigration2.new.migrate(:up)
-      RevertNamedIndexMigration2.new.migrate(:down)
-
-      connection = ActiveRecord::Base.connection
-      assert connection.index_exists?(:horses, :content),
-             "index on content should exist"
-      assert !connection.index_exists?(:horses, :content, name: "horses_index_named"),
-             "horses_index_named index should not exist"
+    # MySQL 5.7 and Oracle do not allow to create duplicate indexes on the same columns
+    unless current_adapter?(:MysqlAdapter, :Mysql2Adapter, :OracleAdapter)
+      def test_migrate_revert_add_index_with_name
+        RevertNamedIndexMigration1.new.migrate(:up)
+        RevertNamedIndexMigration2.new.migrate(:up)
+        RevertNamedIndexMigration2.new.migrate(:down)
+
+        connection = ActiveRecord::Base.connection
+        assert connection.index_exists?(:horses, :content),
+               "index on content should exist"
+        assert !connection.index_exists?(:horses, :content, name: "horses_index_named"),
+              "horses_index_named index should not exist"
+      end
     end
 
   end
-- 
cgit v1.2.3