@@ -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, |