From ad88fd07e3fb3c64a9919047932008876e79ac7a Mon Sep 17 00:00:00 2001 From: Robin Appelman Date: Wed, 10 Jul 2024 20:19:15 +0200 Subject: fix: make joining on tags in search queries work with sharding Signed-off-by: Robin Appelman --- lib/private/Files/Cache/QuerySearchHelper.php | 1 - 1 file changed, 1 deletion(-) (limited to 'lib/private') diff --git a/lib/private/Files/Cache/QuerySearchHelper.php b/lib/private/Files/Cache/QuerySearchHelper.php index 5af43455ea3..0b164912301 100644 --- a/lib/private/Files/Cache/QuerySearchHelper.php +++ b/lib/private/Files/Cache/QuerySearchHelper.php @@ -110,7 +110,6 @@ class QuerySearchHelper { $query ->leftJoin('file', 'vcategory_to_object', 'tagmap', $query->expr()->eq('file.fileid', 'tagmap.objid')) ->leftJoin('tagmap', 'vcategory', 'tag', $query->expr()->andX( - $query->expr()->eq('tagmap.type', 'tag.type'), $query->expr()->eq('tagmap.categoryid', 'tag.id'), $query->expr()->eq('tag.type', $query->createNamedParameter('files')), $query->expr()->eq('tag.uid', $query->createNamedParameter($user->getUID())) -- cgit v1.2.3