This bug is to track some SQL execution requests for bugzilla.mozilla.org - initially, to help with triaging old reviews. Rather than opening a new bug for each one, I'll paste them in here and assign the bug; whoever does it can attach the results and assign the bug back to me. Gerv
Request 1. Please execute this request using the -H (HTML output) switch to the mysql client. SELECT modification_date, flags.bug_id, flags.attach_id, requestee.login_name AS current_requestee, component_owner.login_name AS component_owner, products.name, components.name, bugs.bug_status, bugs.resolution FROM flags LEFT OUTER JOIN profiles AS requestee ON flags.requestee_id = requestee.userid, components LEFT OUTER JOIN profiles AS component_owner ON components.initialowner = component_owner.userid, products, flagtypes, bugs WHERE flags.type_id = flagtypes.id AND flags.bug_id = bugs.bug_id AND bugs.component_id = components.id AND products.id = components.product_id AND flagtypes.name IN ('review', 'first-review', 'second-review') AND flags.status = '?' AND modification_date < "2007-01-01" ORDER BY modification_date; Thanks :-) Gerv
Attached query output.
Justin's not going to like that this is still in our component (even though it's assigned to someone else) since it'll show up in our triage list ;) Also, this bug seems to be public, keep that in mind when composing/running the queries, make sure we aren't circumventing any Bugzilla group permissions with the data we're returning.
I'm pretty sure this specific query that he already ran was meant to be publicly viewed. It's review triage on public bugs. My note was mainly a reminder for us to be careful what we looked up for him in public ;)
All good points. I'll be careful about security (in future). Where would this bug best live, if not in this component? Gerv
Reopen when you have more SQL execution requests.