summaryrefslogtreecommitdiffstats
path: root/Bugzilla/Search.pm
diff options
context:
space:
mode:
authormkanat%kerio.com <>2005-04-20 08:44:03 +0200
committermkanat%kerio.com <>2005-04-20 08:44:03 +0200
commit993f0b3529d4c708fcbaa3fc8efcdeee9e1775d5 (patch)
treeb05db095d5f2997818dab6db84b32d80890876ba /Bugzilla/Search.pm
parent57394ff026769d28ef6b5d077cb4655adf032936 (diff)
downloadbugzilla-993f0b3529d4c708fcbaa3fc8efcdeee9e1775d5.tar.gz
bugzilla-993f0b3529d4c708fcbaa3fc8efcdeee9e1775d5.tar.xz
Bug 284599: Use of REGEXP search is not consistent wrt case sensitivity
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave
Diffstat (limited to 'Bugzilla/Search.pm')
-rw-r--r--Bugzilla/Search.pm6
1 files changed, 3 insertions, 3 deletions
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'");
}
}