Closed Bug 1104 Opened 23 years ago Closed 20 years ago

bugzilla uses non-standard sql

Categories

(Bugzilla :: Bugzilla-General, enhancement)

All
Solaris
enhancement
Not set
normal

Tracking

()

VERIFIED DUPLICATE of bug 98304

People

(Reporter: jay, Assigned: ian)

References

Details

bugzilla cannot be easily port to non-mysql databases such as postgress or
oracle.  while things like bitint and tinytext are trivial to port; enum,
timestamp, and datetime may not be easy.

is there anyway to start moving the perl and sql parts towards sql92?
Submit some patches?

I freely admit I am not much of an SQL expert.  I've figured out how to use
MySQL, that's all.

If you submit some patches that change the use to be more standards-like, that
would be great.

Meanwhile, though, I am not really very upset at the idea of requiring MySQL.
Setting all current Open/Normal to M4.
Clearing "M" field since Webtools product is not used for 5.0 specific project
bug metrics and will mess up our queries on milestones.
some things need to be done to initally start any porting process.  the first is
to implement bug/enhancement #1103, use DBI instead of mysql.pm.  this has other
advantages in that mysql.pm is deprecated in favor of DBI.

the next inital step is to break apart the make*.sh scripts.  ideally, each
script would have the creation routines and the mozilla specific values
separated out.  a sub-directory structure would be handy too.  if i may suggest:

bugzilla-root/
    database/
        mozilla-specific/
           fillcomponenttable.sh
           etc....
        test-database/
           fillcomponenttable.sh
           etc....
        mysql/
           makecomponenttable.sh
           etc....
        oracle/
           ......
Reassigning to dmose@mozilla.org, who now has front-line responsibility for
all Bonsai and Bugzilla bugs.
Reassigning back to me.  That stuff about me no longer being the front-line
person responsible for Bugzilla and Bonsai turned out to be short-lived.
Please pardon our confusion, and I'm very sorry about the spam.
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
God Save DBI
Assignee: tara → cyeh
Depends on: 1103
Status: NEW → ASSIGNED
Priority: P3 → P2
QA Contact: matty
Whiteboard: 3.0
Moving to real milestones...
Whiteboard: 3.0
Target Milestone: --- → Bugzilla 3.0
Taking all Bugzilla 3.0 bugs -- congratulations to MattyT for the triage, it
really was spot on. Note: I may end up pushing some of these bugs back to 3.2,
we'll see. However, I believe all these bugs should just fall out of the 
redesign. Let's hope I'm right!

(Note: I'm also resetting the priority field to "---" so that I can retriage any
that I consider important or likely to be dropped.)
Assignee: cyeh → ian
Status: ASSIGNED → NEW
Component: Bugzilla → Bugzilla 3
Priority: P2 → --
The Bugzilla 3 component is going away.  We're going to depend on the Milestones 
for this.  At the time this component was created, we didn't have milestones for 
Bugzilla.
Component: Bugzilla 3 → Bugzilla
Severity: normal → enhancement
Component: Bugzilla → Bugzilla-General
Product: Webtools → Bugzilla
Version: other → unspecified
The newer PostgreSQL bug is doing most of this.

*** This bug has been marked as a duplicate of 98304 ***
Status: NEW → RESOLVED
Closed: 20 years ago
Resolution: --- → DUPLICATE
Target Milestone: Bugzilla 3.0 → ---
Verified duplicate
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.