From b4f84b30361bdbd95fe64f1af7e8459bcc0d1eb2 Mon Sep 17 00:00:00 2001
From: "bugreport%peshkin.net" <>
Date: Wed, 21 Jan 2004 22:01:08 +0000
Subject: Bug 225075: Fix exact case search so it only selects bugs with
 matching case strings. r=bbaetz, a=justdave

---
 Bugzilla/Search.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'Bugzilla')

diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index 73774e82b..cf42e073f 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -674,7 +674,7 @@ sub init {
              $term = "$ff != $q";
          },
          ",casesubstring" => sub {
-             $term = "INSTR($ff, $q)";
+             $term = "INSTR(CAST($ff AS BINARY), CAST($q AS BINARY))";
          },
          ",substring" => sub {
              $term = "INSTR(LOWER($ff), " . lc($q) . ")";
-- 
cgit v1.2.3-24-g4f1b