1104 - bugzilla uses non-standard sql

Status: VERIFIED DUPLICATE of bug 98304

(Bugzilla :: Bugzilla-General, enhancement)

Description

[Jay Ball]

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?

Comment 1

[Terry Weissman]

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.

Comment 2

[leger]

Setting all current Open/Normal to M4.

Comment 3

[leger]

Clearing "M" field since Webtools product is not used for 5.0 specific project
bug metrics and will mess up our queries on milestones.

Comment 4

[jay]

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/
           ......

Comment 5

[Terry Weissman]

Reassigning to [e-mail], who now has front-line responsibility for
all Bonsai and Bugzilla bugs.

Comment 6

[Terry Weissman]

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.

Comment 7

[Terry Weissman]

[e-mail] 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 .)

Comment 8

[Tara Hernandez]

God Save DBI

Comment 9

[Dave Miller [:justdave]]

Moving to real milestones...

Comment 10

[Hixie (not reading bugmail)]

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.)

Comment 11

[Dave Miller [:justdave]]

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.

Comment 12

[Matthew Tuck [:CodeMachine]]

The newer PostgreSQL bug is doing most of this.

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

Comment 13

[Matt Perry]

Verified duplicate