Bug 76054

Summary: Couldn't query for 'bash' bugs
Product: [Community] Bugzilla Reporter: Tim Waugh <twaugh>
Component: TestAssignee: David Lawrence <dkl>
Status: CLOSED CURRENTRELEASE QA Contact: David Lawrence <dkl>
Severity: medium Docs Contact:
Priority: medium    
Version: 2.17   
Target Milestone: ---   
Target Release: ---   
Hardware: i386   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2002-10-17 09:18:40 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Screenshot showing working query none

Description Tim Waugh 2002-10-16 10:06:37 UTC 
Description of Problem:
Software error while querying for open bash bugs.  I'd performed a query with
'bash' selected.

SELECT DISTINCT bugs.bug_id, bugs.remaining_time,
(SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) AS
actual_time, bugs.bug_severity, bugs.priority, bugs.rep_platform,
map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc
FROM profiles AS map_assigned_to, components components_, longdescs AS
ldtime,bugs LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND
bug_group_map.group_id IS NULL LEFT JOIN cc ON cc.bug_id = bugs.bug_id WHERE
bugs.assigned_to = map_assigned_to.userid AND components_.id = bugs.component_id
AND ldtime.bug_id = bugs.bug_id AND bugs.component_id = components_.id AND
(components_.name = 'bash') AND (bugs.bug_status = 'NEW' OR bugs.bug_status =
'ASSIGNED' OR bugs.bug_status = 'REOPENED') AND (components_.name = 'bash') AND
((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND
bugs.reporter = 0) OR (bugs.cclist_accessible = 1 AND cc.who = 0) OR
(bugs.assigned_to = 0)) GROUP BY
bugs.bug_id,bugs.remaining_time,bugs.bug_severity,bugs.priority,bugs.rep_platform,map_assigned_to.login_name,bugs.bug_status,bugs.resolution,bugs.short_desc
ORDER BY map_components.name,bugs.bug_id : ERROR: Relation "map_components" does
not exist at globals.pl line 280.
Comment 1 David Lawrence 2002-10-16 18:57:19 UTC 
Can you post the resulting URL string that is in the address window after
hitting the Search button on the query page? Is this a stored query that you are
executing? I cannot get this to fail on stock query.
Comment 2 Tim Waugh 2002-10-16 22:45:53 UTC 
http://bugzilla.redhat.com/rh-bugzilla-beta1/buglist.cgi?query_format=&short_desc_type=allwordssubstr&short_desc=&component=bash&component_text=&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&long_desc_type=allwordssubstr&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&emailassigned_to1=1&emailtype1=substring&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emailtype2=substring&email2=&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=noop&type0-0-0=noop&value0-0-0=
Comment 3 David Lawrence 2002-10-16 23:21:28 UTC 
I cannot seem to get this to fail for me. I have attached a screenshot showing
the resultant bug set.
Comment 4 David Lawrence 2002-10-16 23:22:31 UTC 
Created attachment 80744 [details]
Screenshot showing working query
Comment 5 Tim Waugh 2002-10-17 09:18:34 UTC 
Try it in galeon.  It works for me in mozilla and konqueror, now that I try them.
Comment 6 David Lawrence 2002-10-23 21:40:21 UTC 
Should be fixed now. 

http://bugzilla.redhat.com/rh-bugzilla-beta3

Thanks