1 files changed, 24 insertions, 0 deletions
diff --git a/activerecord/test/cases/migration/table_and_index_test.rb b/activerecord/test/cases/migration/table_and_index_test.rb
new file mode 100644
index 0000000000..8fd770abd1
--- /dev/null
+++ b/activerecord/test/cases/migration/table_and_index_test.rb
@@ -0,0 +1,24 @@
+require "cases/helper"
+
+module ActiveRecord
+  class Migration
+    class TableAndIndexTest < ActiveRecord::TestCase
+      def test_add_schema_info_respects_prefix_and_suffix
+        conn = ActiveRecord::Base.connection
+
+        conn.drop_table(ActiveRecord::Migrator.schema_migrations_table_name) if conn.table_exists?(ActiveRecord::Migrator.schema_migrations_table_name)
+        # Use shorter prefix and suffix as in Oracle database identifier cannot be larger than 30 characters
+        ActiveRecord::Base.table_name_prefix = 'p_'
+        ActiveRecord::Base.table_name_suffix = '_s'
+        conn.drop_table(ActiveRecord::Migrator.schema_migrations_table_name) if conn.table_exists?(ActiveRecord::Migrator.schema_migrations_table_name)
+
+        conn.initialize_schema_migrations_table
+
+        assert_equal "p_unique_schema_migrations_s", conn.indexes(ActiveRecord::Migrator.schema_migrations_table_name)[0][:name]
+      ensure
+        ActiveRecord::Base.table_name_prefix = ""
+        ActiveRecord::Base.table_name_suffix = ""
+      end
+    end
+  end
+end