From 993f0b3529d4c708fcbaa3fc8efcdeee9e1775d5 Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Wed, 20 Apr 2005 06:44:03 +0000 Subject: Bug 284599: Use of REGEXP search is not consistent wrt case sensitivity Patch By Tomas Kopal r=mkanat, a=justdave --- Bugzilla/Search.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'Bugzilla/Search.pm') diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index bebbfd94a..b12d714f9 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -1000,10 +1000,10 @@ sub init { $term = $dbh->sql_position(lc($q), "LOWER($ff)") . " = 0"; }, ",regexp" => sub { - $term = "LOWER($ff) " . $dbh->sql_regexp() . " $q"; + $term = "$ff " . $dbh->sql_regexp() . " $q"; }, ",notregexp" => sub { - $term = "LOWER($ff) " . $dbh->sql_not_regexp() . " $q"; + $term = "$ff " . $dbh->sql_not_regexp() . " $q"; }, ",lessthan" => sub { $term = "$ff < $q"; @@ -1506,7 +1506,7 @@ sub GetByWordList { $word =~ s/^'//; $word =~ s/'$//; $word = '(^|[^a-z0-9])' . $word . '($|[^a-z0-9])'; - push(@list, "lower($field) " . $dbh->sql_regexp() . " '$word'"); + push(@list, "$field " . $dbh->sql_regexp() . " '$word'"); } } -- cgit v1.2.3-24-g4f1b