24792 - Software error

Status: VERIFIED FIXED

(Bugzilla :: Bugzilla-General, defect, P3)

Description

[Mats Palmgren (inactive)]

Searching in Description using "all words" is broken:

Software error:

select bugs.bug_id, bugs.groupset, substring(bugs.bug_severity, 1, 3), 
assign.login_name, bugs.short_desc
from bugs, profiles assign, profiles report left join profiles qacont on 
bugs.qa_contact = qacont.userid,
versions projector , longdescs where bugs.assigned_to = assign.userid and 
bugs.reporter = report.userid and
bugs.product = projector.program and bugs.version = projector.value and 
bugs.groupset & 0 = bugs.groupset
and ( bugs.product = 'Browser' ) and ( bugs.bug_status = 'NEW' or 
bugs.bug_status = 'ASSIGNED' or
bugs.bug_status = 'REOPENED' ) and longdescs.bug_id = bugs.bug_id and 
(lower(long_desc) regexp
'(^|[^a-z0-9])mats\\@symsoft\\.se($|[^a-z0-9])' and lower(long_desc) regexp
'(^|[^a-z0-9])alink($|[^a-z0-9])') group by bugs.bug_id order by bugs.bug_id: at 
globals.pl line 72.

Comment 1

[Terry Weissman]

Um, I believe I fixed this bug a half-hour *before* it was submitted.

Comment 2

[Mats Palmgren (inactive)]

I confess! I waited an hour or so before reporting it ;-)
Verifying that it works now.

Comment 3

[Dave Miller [:justdave]]

Moving to Bugzilla product