diff options
| author | Roeland Jago Douma <roeland@famdouma.nl> | 2021-01-28 22:09:55 +0100 |
|---|---|---|
| committer | backportbot[bot] <backportbot[bot]@users.noreply.github.com> | 2021-01-29 07:15:16 +0000 |
| commit | b745acdc140a927de2c99bd03e3771b8585d286a (patch) | |
| tree | d42f4dc613747c2e49166aa33f9260388fd358d8 /lib | |
| parent | cde8b977a06b295d50727a23a8a10f32e4fb7744 (diff) | |
| download | nextcloud-server-b745acdc140a927de2c99bd03e3771b8585d286a.tar.gz nextcloud-server-b745acdc140a927de2c99bd03e3771b8585d286a.zip | |
The objectid is a string
This allows the query to use the index. Else it has to resort on
scanning all the rows.
Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/private/SystemTag/SystemTagObjectMapper.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/private/SystemTag/SystemTagObjectMapper.php b/lib/private/SystemTag/SystemTagObjectMapper.php index 5403321e582..a4d4ce910ca 100644 --- a/lib/private/SystemTag/SystemTagObjectMapper.php +++ b/lib/private/SystemTag/SystemTagObjectMapper.php @@ -78,7 +78,7 @@ class SystemTagObjectMapper implements ISystemTagObjectMapper { ->from(self::RELATION_TABLE) ->where($query->expr()->in('objectid', $query->createParameter('objectids'))) ->andWhere($query->expr()->eq('objecttype', $query->createParameter('objecttype'))) - ->setParameter('objectids', $objIds, IQueryBuilder::PARAM_INT_ARRAY) + ->setParameter('objectids', $objIds, IQueryBuilder::PARAM_STR_ARRAY) ->setParameter('objecttype', $objectType) ->addOrderBy('objectid', 'ASC') ->addOrderBy('systemtagid', 'ASC'); |