diff options
| author | Morris Jobke <hey@morrisjobke.de> | 2020-09-09 14:58:50 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-09-09 14:58:50 +0200 |
| commit | 3e6c0defeb23fc41cfc88695f749e9c9a0c9ab4a (patch) | |
| tree | 8adb5169466b4130a99e56a68f55861b95dc7e21 | |
| parent | 02a6cac39ddd619b2a0710e3fba703f3d72ee13d (diff) | |
| parent | 30db37bbf2d897572f8dbbabc2e4aca96b760818 (diff) | |
| download | nextcloud-server-3e6c0defeb23fc41cfc88695f749e9c9a0c9ab4a.tar.gz nextcloud-server-3e6c0defeb23fc41cfc88695f749e9c9a0c9ab4a.zip | |
Merge pull request #22720 from nextcloud/backport/22469/stable19
[stable19] Don't use SELECT DISTINCT when to_char() is used in a WHERE statement
| -rw-r--r-- | apps/workflowengine/lib/Manager.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/apps/workflowengine/lib/Manager.php b/apps/workflowengine/lib/Manager.php index b583b190070..fefeb9230e6 100644 --- a/apps/workflowengine/lib/Manager.php +++ b/apps/workflowengine/lib/Manager.php @@ -147,10 +147,10 @@ class Manager implements IManager { public function getAllConfiguredEvents() { $query = $this->connection->getQueryBuilder(); - $query->selectDistinct('class') - ->addSelect('entity', 'events') + $query->select('class', 'entity', $query->expr()->castColumn('events', IQueryBuilder::PARAM_STR)) ->from('flow_operations') - ->where($query->expr()->neq('events', $query->createNamedParameter('[]'), IQueryBuilder::PARAM_STR)); + ->where($query->expr()->neq('events', $query->createNamedParameter('[]'), IQueryBuilder::PARAM_STR)) + ->groupBy('class', 'entity', $query->expr()->castColumn('events', IQueryBuilder::PARAM_STR)); $result = $query->execute(); $operations = []; |