@@ -856,7 +856,7 @@ |
||
856 | 856 | return $this; |
857 | 857 | } |
858 | 858 | |
859 | - /** |
|
859 | + /** |
|
860 | 860 | * Check if the current sql language is based on oracle syntax. |
861 | 861 | * |
862 | 862 | * @return bool |
@@ -270,22 +270,22 @@ |
||
270 | 270 | $column = $this->castColumn($column); |
271 | 271 | if ($this->isCaseInsensitive()) { |
272 | 272 | if ($this->request->isRegex($i)) { |
273 | - if($this->isOracleSql()){ |
|
274 | - $this->query->whereRaw(' REGEXP_LIKE( LOWER('.$column.') , ?, \'i\' )', [$keyword]); |
|
275 | - }else{ |
|
276 | - $this->query->whereRaw('LOWER(' . $column . ') REGEXP ?', [Str::lower($keyword)]); |
|
277 | - } |
|
273 | + if($this->isOracleSql()){ |
|
274 | + $this->query->whereRaw(' REGEXP_LIKE( LOWER('.$column.') , ?, \'i\' )', [$keyword]); |
|
275 | + }else{ |
|
276 | + $this->query->whereRaw('LOWER(' . $column . ') REGEXP ?', [Str::lower($keyword)]); |
|
277 | + } |
|
278 | 278 | } else { |
279 | 279 | $this->query->whereRaw('LOWER(' . $column . ') LIKE ?', [Str::lower($keyword)]); |
280 | 280 | } |
281 | 281 | } else { |
282 | 282 | $col = strstr($column, '(') ? $this->connection->raw($column) : $column; |
283 | 283 | if ($this->request->isRegex($i)) { |
284 | - if($this->isOracleSql()){ |
|
285 | - $this->query->whereRaw(' REGEXP_LIKE( '.$col.' , ? )', [$keyword]); |
|
286 | - }else{ |
|
287 | - $this->query->whereRaw($col . ' REGEXP ?', [$keyword]); |
|
288 | - } |
|
284 | + if($this->isOracleSql()){ |
|
285 | + $this->query->whereRaw(' REGEXP_LIKE( '.$col.' , ? )', [$keyword]); |
|
286 | + }else{ |
|
287 | + $this->query->whereRaw($col . ' REGEXP ?', [$keyword]); |
|
288 | + } |
|
289 | 289 | } else { |
290 | 290 | $this->query->whereRaw($col . ' LIKE ?', [$keyword]); |
291 | 291 | } |
@@ -2,7 +2,7 @@ |
||
2 | 2 | |
3 | 3 | return [ |
4 | 4 | |
5 | - 'oracle_sql' => false, |
|
5 | + 'oracle_sql' => false, |
|
6 | 6 | |
7 | 7 | 'search' => [ |
8 | 8 | 'case_insensitive' => true, |