103344 - Software error when trying to do a query of "ready for checkin" bugs.

Status: VERIFIED DUPLICATE of bug 99716

(Bugzilla :: Query/Bug List, defect)

Description

[Jacob Steenhagen]

I tried to put a query together that would find bugs that were ready for checkin.

Attachment is patch => is equal to => 1
Attachment Status => is equal to => first-review
Attachment Status => is equal to => second-review
Attachment Status => is not equal to => need-work

Results in a Software error:
SELECT bugs.bug_id, bugs.groupset, substring(bugs.bug_severity, 1, 3),
substring(bugs.priority, 1, 3), substring(bugs.rep_platform, 1, 3),
map_assigned_to.login_name, substring(bugs.bug_status,1,4),
substring(bugs.resolution,1,4), substring(bugs.short_desc, 1, 60) FROM bugs,
profiles map_assigned_to, profiles map_reporter LEFT JOIN profiles
map_qa_contact ON bugs.qa_contact = map_qa_contact.userid LEFT JOIN attachments
attachments_0 ON bugs.bug_id = attachments_0.bug_id, attachments attachments_0,
attachstatuses attachstatuses_0, attachstatusdefs attachstatusdefs_0 WHERE
bugs.assigned_to = map_assigned_to.userid AND bugs.reporter =
map_reporter.userid AND bugs.groupset & 192 = bugs.groupset AND bugs.bug_id =
attachments_0.bug_id AND attachments_0.attach_id = attachstatuses_0.attach_id
AND attachstatuses_0.statusid = attachstatusdefs_0.id AND bugs.bug_id =
attachments_0.bug_id AND attachments_0.attach_id = attachstatuses_0.attach_id
AND attachstatuses_0.statusid = attachstatusdefs_0.id AND bugs.bug_id =
attachments_0.bug_id AND attachments_0.attach_id = attachstatuses_0.attach_id
AND attachstatuses_0.statusid = attachstatusdefs_0.id AND (bugs.product =
'Bugzilla') AND (bugs.bug_status = 'NEW' OR bugs.bug_status = 'ASSIGNED' OR
bugs.bug_status = 'REOPENED') AND (attachments_0.ispatch = '1') AND
(attachstatusdefs_0.name = 'first-review') AND (attachstatusdefs_0.name =
'second-review') AND (attachstatusdefs_0.name != 'needs-work') GROUP BY
bugs.bug_id ORDER BY bugs.priority, bugs.bug_severity: Not unique table/alias:
'attachments_0' at globals.pl line 214.


It seems to be caused by having both Attachment is patch and Attachment Status
in the same chart as once that is removed I don't get the error (although I also
don't get the results I'm expecting :)

Comment 1

[Jacob Steenhagen]

I knew there was a reason this looked familar :)

*** This bug has been marked as a duplicate of 99716 ***

Comment 2

[timeless]

.