diff options
| author | Joas Schilling <213943+nickvergessen@users.noreply.github.com> | 2020-09-08 09:40:11 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-09-08 09:40:11 +0200 |
| commit | 6540c397aa3e60d75dcb4aa22bd10437b496cd5d (patch) | |
| tree | 41fc0aea868442b4cb9eef23620f8805efa45c40 | |
| parent | c436e5db16e0d09da36fc7b10ede397a00c01e16 (diff) | |
| parent | aa5e4aacc1c7a8ec318454298bbbd11e44b33962 (diff) | |
| download | nextcloud-server-6540c397aa3e60d75dcb4aa22bd10437b496cd5d.tar.gz nextcloud-server-6540c397aa3e60d75dcb4aa22bd10437b496cd5d.zip | |
Merge pull request #22469 from nextcloud/bugfix/noid/oracle-casting-select-distinct
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 = []; |