1 files changed, 27 insertions, 0 deletions
diff --git a/spec/requests/projects/notes_controller_spec.rb b/spec/requests/projects/notes_controller_spec.rb
new file mode 100644
index 00000000000..9cd8ba364ea
--- /dev/null
+++ b/spec/requests/projects/notes_controller_spec.rb
@@ -0,0 +1,27 @@
+# frozen_string_literal: true
+
+require 'spec_helper'
+
+RSpec.describe Projects::NotesController, feature_category: :team_planning do
+  let_it_be(:project) { create(:project, :public) }
+  let_it_be(:issue) { create(:issue, project: project) }
+
+  describe '#index' do
+    def get_notes
+      get project_noteable_notes_path(project, target_type: 'issue', target_id: issue.id, format: :json),
+        headers: { 'X-Last-Fetched-At': 0 }
+    end
+
+    it 'does not execute N+1 queries' do
+      get_notes
+
+      create(:note_on_issue, project: project, noteable: issue)
+
+      control = ActiveRecord::QueryRecorder.new { get_notes }
+
+      create(:note_on_issue, project: project, noteable: issue)
+
+      expect { get_notes }.not_to exceed_query_limit(control)
+    end
+  end
+end