Basically a case insensative boolean search on the alias field works, however a
case sensative search doesn't.

https://bugzilla.redhat.com/beta/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&component_text=&query_format=advanced&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&fixed_in_type=allwordssubstr&fixed_in=&qa_whiteboard_type=allwordssubstr&qa_whiteboard=&devel_whiteboard_type=allwordssubstr&devel_whiteboard=&keywords_type=allwords&keywords=&cust_facing=&cust_facing_type=substring&emailreporter1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=alias&type0-0-0=casesubstring&value0-0-0=RHEL4

results in:

Software error:

DBD::Pg::st execute failed: ERROR:  parser: parse error at or near "BINARY" at
character 490 [for Statement "SELECT bugs.bug_id, bugs.bug_severity,
bugs.priority, bugs.bug_status, bugs.resolution, bugs.alias, bugs.delta_ts,
bugs.bug_severity, bugs.priority, bugs.rep_platform, map_assigned_to.login_name,
bugs.bug_status, bugs.resolution, bugs.short_desc FROM bugs LEFT JOIN
bug_group_map  ON bug_group_map.bug_id = bugs.bug_id  LEFT JOIN cc ON cc.bug_id
= bugs.bug_id AND cc.who = 141215  , profiles AS map_assigned_to WHERE
bugs.assigned_to = map_assigned_to.userid AND (POSITION(CAST('RHEL4' AS BINARY)
IN CAST(bugs.alias AS BINARY)) != 0) AND ((bug_group_map.group_id IS NULL)  OR
bug_group_map.group_id IN
(33,34,22,4,78,75,68,44,2,12,67,76,3,41,25,15,58,21,35,7,62,61,17,11,72,50,71,5,38,39)
 OR (bugs.reporter_accessible = 1 AND bugs.reporter = 141215)  OR
(bugs.cclist_accessible = 1 AND cc.who IS NOT NULL)  OR (bugs.assigned_to =
141215)  OR (bugs.qa_contact = 141215) ) GROUP BY bugs.bug_id,
bugs.bug_id,bugs.bug_severity,bugs.priority,bugs.bug_status,bugs.resolution,bugs.alias,bugs.delta_ts,bugs.bug_severity,bugs.priority,bugs.rep_platform,map_assigned_to.login_name,bugs.bug_status,bugs.resolution,bugs.short_desc
ORDER BY
bugs.delta_ts,bugs.delta_ts,bugs.bug_status,bugs.priority,map_assigned_to.login_name,bugs.bug_id"]
at Bugzilla/DB.pm line 74
	Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity, bugs.priority,
bugs.bu...') called at /var/www/bugzilla/beta/buglist.cgi line 614

For help, please send mail to the webmaster (bugzilla), giving this
error message and the time and date of the error.