Merge pull request #1929 from sobrinho/master

Create a test case for disable_referential_integrity

1 files changed, 14 insertions, 0 deletions

diff --git a/activerecord/test/cases/adapter_test.rb b/activerecord/test/cases/adapter_test.rb
index 07de544868..4c65193d75 100644
--- a/activerecord/test/cases/adapter_test.rb
+++ b/activerecord/test/cases/adapter_test.rb
@@ -146,4 +146,18 @@ class AdapterTest < ActiveRecord::TestCase
       end
     end
   end
+
+  def test_disable_referential_integrity
+    assert_nothing_raised do
+      @connection.disable_referential_integrity do
+        # Oracle adapter uses prefetched primary key values from sequence and passes them to connection adapter insert method
+        if @connection.prefetch_primary_key?
+          id_value = @connection.next_sequence_value(@connection.default_sequence_name("fk_test_has_fk", "id"))
+          @connection.execute "INSERT INTO fk_test_has_fk (id, fk_id) VALUES (#{id_value},0)"
+        else
+          @connection.execute "INSERT INTO fk_test_has_fk (fk_id) VALUES (0)"
+        end
+      end
+    end
+  end
 end