diff options
| author | Joas Schilling <coding@schilljs.com> | 2017-07-24 11:39:53 +0200 |
|---|---|---|
| committer | Joas Schilling <coding@schilljs.com> | 2017-08-02 09:48:16 +0200 |
| commit | bb58667511b79c2da47be0c08f82527b4088e9fb (patch) | |
| tree | 91d09b533fd632508192d13783e3a4d377aa57c6 /lib | |
| parent | fc22a2cb0746a36efdbfe79993263ee3f9e6d11a (diff) | |
| download | nextcloud-server-bb58667511b79c2da47be0c08f82527b4088e9fb.tar.gz nextcloud-server-bb58667511b79c2da47be0c08f82527b4088e9fb.zip | |
Fix ILIKE regex for oracle
Signed-off-by: Joas Schilling <coding@schilljs.com>
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php b/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php index 179ce72e8e1..dc5c8bccbca 100644 --- a/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php +++ b/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php @@ -166,6 +166,6 @@ class OCIExpressionBuilder extends ExpressionBuilder { public function iLike($x, $y, $type = null) { $x = $this->helper->quoteColumnName($x); $y = $this->helper->quoteColumnName($y); - return new QueryFunction('REGEXP_LIKE('.$x.', \'^\' || REPLACE('.$y.', \'%\', \'.*\') || \'$\', \'i\')'); + return new QueryFunction('REGEXP_LIKE(' . $x . ', \'^\' || REPLACE(REPLACE(' . $y . ', \'%\', \'.*\'), \'_\', \'.\') || \'$\', \'i\')'); } } |