diff options
| author | Morris Jobke <hey@morrisjobke.de> | 2020-11-06 22:27:30 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-11-06 22:27:30 +0100 |
| commit | fb5d1b40e48a1185710c6102f07b11dab95054c1 (patch) | |
| tree | 3bb7cf10289de37018ae3a22fc9f2286041c0b6d /lib | |
| parent | 9981ffd7840ce6492664fb08e0ea8459bd279531 (diff) | |
| parent | cb8bef1f37d6216c0f7905f6e46500e8352fb5c8 (diff) | |
| download | nextcloud-server-fb5d1b40e48a1185710c6102f07b11dab95054c1.tar.gz nextcloud-server-fb5d1b40e48a1185710c6102f07b11dab95054c1.zip | |
Merge pull request #23943 from nextcloud/bugfix/oci/fix-ilike-on-oracle
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 e8e436ba5bd..f41242fdc60 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)); } } |