diff options
| author | Roeland Jago Douma <rullzer@users.noreply.github.com> | 2020-11-11 23:53:28 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-11-11 23:53:28 +0300 |
| commit | 13f6dcfbf8c07c8b5d523573700deea739469abf (patch) | |
| tree | 7ce184295d8f574340db8838e6747cc7ccffad4e /lib | |
| parent | 414cd3bc5d1b817ff48f07de73667ead60f7fe92 (diff) | |
| parent | ddc94e44b76fdec2e52971fb1370e792d971885d (diff) | |
Merge pull request #24047 from nextcloud/backport/23943/stable18
[stable18] Fix iLike() falsely turning escaped % and _ into wildcards
Diffstat (limited to 'lib')
| -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 12719b2aaad..23afcbd9f96 100644 --- a/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php +++ b/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php @@ -186,8 +186,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)); } } |