From 81500bf83700a0faaa514e73df97d7fe67c98829 Mon Sep 17 00:00:00 2001
From: Carl Schwan <carl@carlschwan.eu>
Date: Wed, 27 Apr 2022 14:46:28 +0200
Subject: [PATCH] Fix getting shares in a folder on Orache

Signed-off-by: Carl Schwan <carl@carlschwan.eu>
---
 lib/private/Share20/DefaultShareProvider.php | 25 ++++++++++++++------
 1 file changed, 18 insertions(+), 7 deletions(-)

diff --git a/lib/private/Share20/DefaultShareProvider.php b/lib/private/Share20/DefaultShareProvider.php
index 9638706025b..520bd17d3cf 100644
--- a/lib/private/Share20/DefaultShareProvider.php
+++ b/lib/private/Share20/DefaultShareProvider.php
@@ -671,10 +671,10 @@ class DefaultShareProvider implements IShareProvider {
 		}
 
 		// todo? maybe get these from the oc_mounts table
-		$childMountNodes = array_filter($node->getDirectoryListing(), function (Node $node) {
+		$childMountNodes = array_filter($node->getDirectoryListing(), function (Node $node): bool {
 			return $node->getInternalPath() === '';
 		});
-		$childMountRootIds = array_map(function (Node $node) {
+		$childMountRootIds = array_map(function (Node $node): int {
 			return $node->getId();
 		}, $childMountNodes);
 
@@ -682,18 +682,29 @@ class DefaultShareProvider implements IShareProvider {
 		$qb->andWhere(
 			$qb->expr()->orX(
 				$qb->expr()->eq('f.parent', $qb->createNamedParameter($node->getId())),
-				$qb->expr()->in('f.fileid', $qb->createNamedParameter($childMountRootIds, IQueryBuilder::PARAM_INT_ARRAY))
+				$qb->expr()->in('f.fileid', $qb->createParameter('chunk'))
 			)
 		);
 
 		$qb->orderBy('id');
 
-		$cursor = $qb->execute();
 		$shares = [];
-		while ($data = $cursor->fetch()) {
-			$shares[$data['fileid']][] = $this->createShare($data);
+
+		$chunks = array_chunk($childMountRootIds, 1000);
+
+		// Force the request to be run when there is 0 mount.
+		if (count($chunks) === 0) {
+			$chunks = [[]];
+		}
+
+		foreach ($chunks as $chunk) {
+			$qb->setParameter('chunk', $chunk, IQueryBuilder::PARAM_INT_ARRAY);
+			$cursor = $qb->executeQuery();
+			while ($data = $cursor->fetch()) {
+				$shares[$data['fileid']][] = $this->createShare($data);
+			}
+			$cursor->closeCursor();
 		}
-		$cursor->closeCursor();
 
 		return $shares;
 	}
-- 
2.39.5