diff options
| author | Joas Schilling <coding@schilljs.com> | 2020-11-06 15:31:28 +0100 |
|---|---|---|
| committer | backportbot[bot] <backportbot[bot]@users.noreply.github.com> | 2020-11-06 21:29:48 +0000 |
| commit | 3a7e2fbff1998f73f68ce914124d53c1fbe4457f (patch) | |
| tree | 3e4479034758d08b7f5f25a03e33e980e1a076c1 | |
| parent | f8b550dab7ca32cfb29c7d83f3ad252330b9b265 (diff) | |
| download | nextcloud-server-3a7e2fbff1998f73f68ce914124d53c1fbe4457f.tar.gz nextcloud-server-3a7e2fbff1998f73f68ce914124d53c1fbe4457f.zip | |
Fix iLike() falsely turning escaped % and _ into wildcards
Signed-off-by: Joas Schilling <coding@schilljs.com>
| -rw-r--r-- | lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php b/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php index c3715074685..85a8deb53cb 100644 --- a/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php +++ b/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php @@ -189,8 +189,6 @@ class OCIExpressionBuilder extends ExpressionBuilder { * @inheritdoc */ public function iLike($x, $y, $type = null) { - $x = $this->helper->quoteColumnName($x); - $y = $this->helper->quoteColumnName($y); - return new QueryFunction('REGEXP_LIKE(' . $x . ', \'^\' || REPLACE(REPLACE(' . $y . ', \'%\', \'.*\'), \'_\', \'.\') || \'$\', \'i\')'); + return $this->like($this->functionBuilder->lower($x), $this->functionBuilder->lower($y)); } } |