Closed
Bug 574940
Opened 14 years ago
Closed 14 years ago
percentage_complete searches fail on PostgreSQL
Categories
(Bugzilla :: Query/Bug List, defect)
Tracking
()
RESOLVED
FIXED
Bugzilla 4.2
People
(Reporter: mkanat, Assigned: mkanat)
References
Details
(Whiteboard: [blocker will fix on trunk])
Trying to search on percentage_complete on PostgreSQL throws a Division By Zero error from the database.
Assignee | ||
Updated•14 years ago
|
Blocks: pg-xt-search
Comment 1•14 years ago
|
||
Testing 4.1 with Pg 8.4.4, I get: DBD::Pg::st execute failed: ERROR: missing FROM-clause entry for table "map_actual_time" LINE 16: HAVING ((CASE WHEN (SUM(map_actual_time.work_time) * COUNT(D... ^ [for Statement "SELECT bugs.bug_id AS bug_id, bugs.bug_severity AS bug_severity, bugs.priority AS priority, bugs.bug_status AS bug_status, bugs.resolution AS resolution, map_product.name AS product, bugs.op_sys AS op_sys, map_assigned_to.login_name AS assigned_to, bugs.short_desc AS short_desc, bugs.remaining_time AS remaining_time FROM bugs LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id AND NOT ( security_map.group_id IN (1,10,11,13,12,9,4,8,5,6,7,3,2,14) ) LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id AND security_cc.who = 1 INNER JOIN products AS map_product ON bugs.product_id = map_product.id INNER JOIN profiles AS map_assigned_to ON bugs.assigned_to = map_assigned_to.userid INNER JOIN priority AS map_priority ON bugs.priority = map_priority.value INNER JOIN bug_severity AS map_bug_severity ON bugs.bug_severity = map_bug_severity.value LEFT JOIN longdescs AS longdescs_0 ON bugs.bug_id = longdescs_0.bug_id WHERE bugs.creation_ts IS NOT NULL AND (security_map.group_id IS NULL OR (bugs.reporter_accessible = 1 AND bugs.reporter = 1) OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL) OR bugs.assigned_to = 1 OR bugs.qa_contact = 1) GROUP BY bugs.bug_id, bugs.bug_severity,bugs.priority,bugs.bug_status,bugs.resolution,map_product.name,bugs.op_sys,map_assigned_to.login_name,bugs.short_desc,bugs.remaining_time,map_priority.sortkey,map_priority.value,map_bug_severity.sortkey,map_bug_severity.value HAVING ((CASE WHEN (SUM(map_actual_time.work_time) * COUNT(DISTINCT map_actual_time.bug_when)/COUNT(bugs.bug_id)) + bugs.remaining_time = 0.0 THEN 0.0 ELSE 100 * ((SUM(map_actual_time.work_time) * COUNT(DISTINCT map_actual_time.bug_when)/COUNT(bugs.bug_id)) / ((SUM(map_actual_time.work_time) * COUNT(DISTINCT map_actual_time.bug_when)/COUNT(bugs.bug_id)) + bugs.remaining_time)) END)) = '50' ORDER BY map_priority.sortkey, map_priority.value, map_bug_severity.sortkey, map_bug_severity.value "] at /var/www/html/bugzilla-pg/buglist.cgi line 919
Assignee | ||
Comment 2•14 years ago
|
||
Fixed by blocker for 4.2. I'm not going to fix it on 3.6.
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Target Milestone: Bugzilla 3.6 → Bugzilla 4.2
Updated•14 years ago
|
Assignee: query-and-buglist → mkanat
You need to log in
before you can comment on or make changes to this bug.
Description
•