Merge pull request #9229 from owncloud/fix_search_on_oracle_stable5

replace % in pattern with .* and surround with ^$ to get a real regex pattern

1 files changed, 2 insertions, 1 deletions

diff --git a/lib/files/cache/cache.php b/lib/files/cache/cache.php
index 3bf0724143d..a2832296436 100644
--- a/lib/files/cache/cache.php
+++ b/lib/files/cache/cache.php
@@ -521,7 +521,8 @@ class Cache {
 				WHERE `storage` = ? AND ';
 		if(\OC_Config::getValue( 'dbtype', 'sqlite' ) === 'oci') {
 			//remove starting and ending % from the pattern
-			$pattern = trim($pattern, '%');
+			$pattern = preg_quote($pattern);
+			$pattern = '^'.str_replace('%', '.*', $pattern).'$';
 			$sql .= 'REGEXP_LIKE(`name`, ?, \'i\')';
 		} else {
 			$sql .= '`name` LIKE ?';