From 6e628390e5751e6fcbd91ed32031297f761104f3 Mon Sep 17 00:00:00 2001
From: Pavel Shutsin <pshutsin@gitlab.com>
Date: Thu, 15 Dec 2022 18:30:29 +0100
Subject: [PATCH] Change approach to filter out hidden issues

In some rare cases postgres query
planner picked very inneficient plan.
So we revert to old more stable behaviour
---
 app/models/issue.rb | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/app/models/issue.rb b/app/models/issue.rb
index b338ecfce88e7f..cc9c362c1f1155 100644
--- a/app/models/issue.rb
+++ b/app/models/issue.rb
@@ -180,7 +180,7 @@ def most_recent
 
   scope :without_hidden, -> {
     if Feature.enabled?(:ban_user_feature_flag)
-      where.not(author_id: Users::BannedUser.all.select(:user_id))
+      where('NOT EXISTS (?)', Users::BannedUser.select(1).where('issues.author_id = banned_users.user_id'))
     else
       all
     end
-- 
GitLab