Re: SQL standards in Mysql - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: SQL standards in Mysql
Date
Msg-id dcc563d10802221613s79f9967foa1c0540db9c5b7af@mail.gmail.com
Whole thread Raw
In response to Re: SQL standards in Mysql  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: SQL standards in Mysql  ("Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>)
List pgsql-sql
On Fri, Feb 22, 2008 at 1:57 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Ken Johanson wrote:
>  > Here's one Mysql developer's response to adding (fixing) the
>  > integer/bigint/tinyint types to their CAST function:
>  >
>  > http://bugs.mysql.com/bug.php?id=34562
>
>  So they are anal too, but in the opposite direction?

No, they're just hopelessly lost and making good time. Or lazy.  Or
both.  I'm not sure.

There's example after example of things in the mysql bug database that
should make anyone considering it as a database engine cringe and walk
away shaking their head.  for instance, someone JUST submitted this
bug:

http://bugs.mysql.com/bug.php?id=34231

Which is about a problem with the mysql packages including a
statically linked zlib which makes it impossible to compile php
against it.  Problem is, their inability to properly package / not
package zlib with mysql is an ongoing problem.  As far back as 2004 it
showed up.  Then was fixed, then showed up again, then was fixed.

Here's the most recent "we fixed it! Oh shit it's broken again" bug record:

http://bugs.mysql.com/bug.php?id=15255

Before that we had

http://bugs.mysql.com/bug.php?id=3700

After that we had

http://bugs.mysql.com/bug.php?id=28569

and now the latest reports.  It's like the Keystone Kops create RPM
packages reading those messages.  Pick any subject area.  Foreign
keys, SQL compliance, and on and on and you'll find dozens of the same
bugs coming and going as one person stomps it and another apparently
reinstates it.


pgsql-sql by date:

Previous
From: johnf
Date:
Subject: Re: postgresql function not accepting null values inselect statement
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: SQL standards in Mysql