Closed Bug 15124 Opened 25 years ago Closed 23 years ago

Form for SQL select queries

Categories

(Bugzilla :: Bugzilla-General, enhancement, P3)

Product:
Bugzilla
Component:
Bugzilla-General
Type:
enhancement

Tracking

()

Status:
VERIFIED WONTFIX

People

(Reporter: alecf, Assigned: justdave)

Details

I noticed that one of the links on http://www.mozilla.org/get-involved.html
looks like SQL.... it would be really cool if we could just enter SQL select
queries (or at least the WHERE clause) in a form instead of having to fill out
the bugzilla query form.
Not necessarily referring to SQL, but bug #11328 is about being able to enter
more advanced queries, which could be entered in a textual fashion.
Status: NEW → ASSIGNED
tara@tequilarista.org is the new owner of Bugzilla and Bonsai.  (For details,
see my posting in netscape.public.mozilla.webtools,
news://news.mozilla.org/38F5D90D.F40E8C1A%40geocast.com .)
Assignee: terry → tara
Status: ASSIGNED → NEW
i think it's a nice idea, but it's not terribly feasible because it would be 
really hard in the current bugzilla design to make this secure. all account 
information is stored in a bugzilla table named 'profiles'. It would be hard to 
deny access to that table.

writing filters is hard, because you don't know if the string 'profiles' refers 
to a table, or refers to a valid sql query on a product named 'profiles' or a 
bug against the profile manager. 

this might be possible using mysql permissions, but then you'd be creating a 
seperate access point into the database, which bugzilla currently doesn't have a 
notion of. 

you might be able to use groups, but then again, in order to do that, you'd need 
to have near admin access anyway to see all the tables.
Status: NEW → RESOLVED
Closed: 24 years ago
Resolution: --- → WONTFIX
verif. wontfix.  most of Bugzilla's security is based on arbitrary things in the 
database.  allowing raw SQL access would make it way to easy to circumvent some 
of these.
Status: RESOLVED → VERIFIED
moving all closed Bugzilla bugs to the new Bugzilla product.
This batch is DUPLICATE/INVALID/WORKSFORME/WONTFIX
reassigning to default owner and QA in case of the bug being reopened.
Clearing milestones, since we really shouldn't have them on these types of
resolutions.  Sorry for the spam everyone...
Assignee: tara → justdave
Status: VERIFIED → NEW
Component: Bugzilla → Bugzilla-General
Product: Webtools → Bugzilla
QA Contact: matty
Version: other → unspecified
damn, bit by bug 30731. sorry for the respam...  one more coming to complete the
status fix
Status: NEW → RESOLVED
Closed: 24 years ago → 23 years ago
completing status fix...
Status: RESOLVED → VERIFIED
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.