diff options
| author | Roeland Jago Douma <rullzer@users.noreply.github.com> | 2020-11-11 21:53:24 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-11-11 21:53:24 +0100 |
| commit | 0f5ac14f43904495259758b6e3bdd2f7fa392884 (patch) | |
| tree | 54d4084ffd0fcda19db38f3aa8d2d4a1c97c4728 | |
| parent | e6dbc714de7c93e0ae7ce6e45c37bfce05ac7344 (diff) | |
| parent | d5dfaf42a8238faa098499613c33160de122bb1c (diff) | |
| download | nextcloud-server-0f5ac14f43904495259758b6e3bdd2f7fa392884.tar.gz nextcloud-server-0f5ac14f43904495259758b6e3bdd2f7fa392884.zip | |
Merge pull request #24048 from nextcloud/backport/23943/stable19
[stable19] Fix iLike() falsely turning escaped % and _ into wildcards
| -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 2aa007dba04..7079e5bd53a 100644 --- a/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php +++ b/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php @@ -185,8 +185,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)); } } |