diff options
| author | Arthur Schiwon <blizzz@arthur-schiwon.de> | 2019-12-05 14:43:58 +0100 |
|---|---|---|
| committer | Roeland Jago Douma <roeland@famdouma.nl> | 2019-12-06 11:37:31 +0100 |
| commit | 43efa40864c106c84b95b49d0e25168d7e715b5a (patch) | |
| tree | 246466df4b621464b3a94078d55bc3853fe397c7 /apps/files_external/lib | |
| parent | 6caec491c134f99584c8877c1ebc13acdbfbb057 (diff) | |
| download | nextcloud-server-43efa40864c106c84b95b49d0e25168d7e715b5a.tar.gz nextcloud-server-43efa40864c106c84b95b49d0e25168d7e715b5a.zip | |
rejig right to left join for sqlite's satisfaction
Signed-off-by: Arthur Schiwon <blizzz@arthur-schiwon.de>
Diffstat (limited to 'apps/files_external/lib')
| -rw-r--r-- | apps/files_external/lib/Service/DBConfigService.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/apps/files_external/lib/Service/DBConfigService.php b/apps/files_external/lib/Service/DBConfigService.php index 7a818a41da6..265848289f3 100644 --- a/apps/files_external/lib/Service/DBConfigService.php +++ b/apps/files_external/lib/Service/DBConfigService.php @@ -128,10 +128,10 @@ class DBConfigService { $builder = $this->connection->getQueryBuilder(); $query = $builder->select(['a.mount_id', $builder->func()->count('a.mount_id', 'count')]) ->from('external_applicable', 'a') - ->rightJoin('a', 'external_applicable', 'b', $builder->expr()->eq('a.mount_id', 'b.mount_id')) + ->leftJoin('a', 'external_applicable', 'b', $builder->expr()->eq('a.mount_id', 'b.mount_id')) ->where($builder->expr()->andX( - $builder->expr()->eq('a.type', $builder->createNamedParameter($applicableType, IQueryBuilder::PARAM_INT)), - $builder->expr()->eq('a.value', $builder->createNamedParameter($applicableId)) + $builder->expr()->eq('b.type', $builder->createNamedParameter($applicableType, IQueryBuilder::PARAM_INT)), + $builder->expr()->eq('b.value', $builder->createNamedParameter($applicableId)) ) ) ->groupBy(['a.mount_id']); |