Bug 75976
Summary: | error running query by owner/component | ||
---|---|---|---|
Product: | [Community] Bugzilla | Reporter: | David Lehman <dlehman> |
Component: | Test | Assignee: | David Lawrence <dkl> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | David Lawrence <dkl> |
Severity: | high | Docs Contact: | |
Priority: | high | ||
Version: | 2.17 | ||
Target Milestone: | --- | ||
Target Release: | --- | ||
Hardware: | All | ||
OS: | Linux | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2002-10-15 21:25:00 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: |
Description
David Lehman
2002-10-15 14:03:00 UTC
I get a similar error with the following query: http://bugzilla.redhat.com/rh-bugzilla-beta1/buglist.cgi?query_format=&short_desc_type=allwordssubstr&short_desc=&long_desc_type=allwordssubstr&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&qa_whiteboard_type=allwordssubstr&qa_whiteboard=&devel_whiteboard_type=allwordssubstr&devel_whiteboard=&emailreporter1=1&emaillongdesc1=1&emailtype1=substring&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emaillongdesc2=1&emailtype2=substring&email2=mamclean&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= 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, longdescs AS ldtime, longdescs longdescs_, profiles longdescnames_, profiles AS map_reporter, LEFT JOIN cc cc_ ON bugs.bug_id = cc_.bug_id, LEFT JOIN profiles map_cc_ ON cc_.who = map_cc_.userid, LEFT JOIN profiles map_qa_contact ON bugs.qa_contact = map_qa_contact.userid,bugs LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND bug_group_map.group_id NOT IN (12,11,15) LEFT JOIN cc ON cc.bug_id = bugs.bug_id WHERE bugs.assigned_to = map_assigned_to.userid AND ldtime.bug_id = bugs.bug_id AND longdescs_.bug_id = bugs.bug_id AND longdescs_.who = longdescnames_.userid AND bugs.assigned_to = map_assigned_to.userid AND bugs.reporter = map_reporter.userid AND (POSITION('mamclean' IN LOWER(map_assigned_to.login_name)) != 0 OR POSITION('mamclean' IN LOWER(map_reporter.login_name)) != 0 OR POSITION('mamclean' IN LOWER(map_cc_.login_name)) != 0 OR POSITION('mamclean' IN LOWER(map_qa_contact.login_name)) != 0 OR POSITION('mamclean' IN LOWER(longdescnames_.login_name)) != 0) AND ((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND bugs.reporter = 84357) OR (bugs.cclist_accessible = 1 AND cc.who = 84357) OR (bugs.assigned_to = 84357)) 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 bugs.bug_id : ERROR: parser: parse error at or near "LEFT" at globals.pl line 280. Queries are currently known broken when using searches based on user names such as CC, qa_contact, etc. I am working on this. Should be fixed in latest cut. http://bugzilla.redhat.com/rh-bugzilla-beta3 |