Revert unused code and re-using query annotation for `update_all` and `delete_all`

This partly reverts #35617.

#35617 includes unused code (for `InsertStatement`) and re-using query
annotation for `update_all` and `delete_all`, which has not been
discussed yet.

If a relation has any annotation, I think it is mostly for SELECT query,
so re-using annotation by default is not always desired behavior for me.

We should discuss about desired behavior before publishing the
implementation.

2 files changed, 0 insertions, 46 deletions

diff --git a/activerecord/test/cases/relation/delete_all_test.rb b/activerecord/test/cases/relation/delete_all_test.rb
index 9b76936b7e..d1c13fa1b5 100644
--- a/activerecord/test/cases/relation/delete_all_test.rb
+++ b/activerecord/test/cases/relation/delete_all_test.rb
@@ -99,23 +99,4 @@ class DeleteAllTest < ActiveRecord::TestCase
     assert_raise(ActiveRecord::RecordNotFound) { posts(:thinking) }
     assert posts(:welcome)
   end
-
-  def test_delete_all_with_annotation_includes_a_query_comment
-    davids = Author.where(name: "David").annotate("deleting all")
-
-    assert_sql(%r{/\* deleting all \*/}) do
-      assert_difference("Author.count", -1) { davids.delete_all }
-    end
-  end
-
-  def test_delete_all_without_annotation_does_not_include_an_empty_comment
-    davids = Author.where(name: "David")
-
-    log = capture_sql do
-      assert_difference("Author.count", -1) { davids.delete_all }
-    end
-
-    assert_not_predicate log, :empty?
-    assert_predicate log.select { |query| query.match?(%r{/\*}) }, :empty?
-  end
 end
diff --git a/activerecord/test/cases/relation/update_all_test.rb b/activerecord/test/cases/relation/update_all_test.rb
index 526f926841..0500574f28 100644
--- a/activerecord/test/cases/relation/update_all_test.rb
+++ b/activerecord/test/cases/relation/update_all_test.rb
@@ -241,33 +241,6 @@ class UpdateAllTest < ActiveRecord::TestCase
     end
   end
 
-  def test_update_all_with_annotation_includes_a_query_comment
-    tag = Tag.first
-
-    assert_sql(%r{/\* updating all \*/}) do
-      Post.tagged_with(tag.id).annotate("updating all").update_all(title: "rofl")
-    end
-
-    posts = Post.tagged_with(tag.id).all.to_a
-    assert_operator posts.length, :>, 0
-    posts.each { |post| assert_equal "rofl", post.title }
-  end
-
-  def test_update_all_without_annotation_does_not_include_an_empty_comment
-    tag = Tag.first
-
-    log = capture_sql do
-      Post.tagged_with(tag.id).update_all(title: "rofl")
-    end
-
-    assert_not_predicate log, :empty?
-    assert_predicate log.select { |query| query.match?(%r{/\*}) }, :empty?
-
-    posts = Post.tagged_with(tag.id).all.to_a
-    assert_operator posts.length, :>, 0
-    posts.each { |post| assert_equal "rofl", post.title }
-  end
-
   # Oracle UPDATE does not support ORDER BY
   unless current_adapter?(:OracleAdapter)
     def test_update_all_ignores_order_without_limit_from_association