FOSS master failure: spec/finders/joined_groups_finder_spec.rb

https://gitlab.com/gitlab-org/gitlab-foss/-/jobs/842201878

  1) JoinedGroupsFinder#execute with a user when the profile visitor is in the private group only shows groups where both users are authorized to see
     Failure/Error: expect(finder.execute(profile_visitor)).to eq([public_group, internal_group, private_group])
     ActiveRecord::StatementInvalid:
       PG::DuplicateAlias: ERROR:  WITH query name "direct_groups" specified more than once
       LINE 7: ... namespaces WHERE "namespaces"."type" = 'Group'), "direct_gr...

Possibly caused by !46412 (merged)