Re: Thoughts on MySQL and InnoDB

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: bostic(at)sleepycat(dot)com, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Thoughts on MySQL and InnoDB
Date: 2005-12-01 16:16:42
Message-ID: 438F21EA.5020300@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

On 11/29/2005 10:42 PM, Jan Wieck wrote:

> [...]
> of attention. I was shocked to learn that functions and triggers cannot
> access any tables. So all a trigger can do is check/modify the values at
> hand.

This statement was based on an article found on the MySQL site.

http://dev.mysql.com/tech-resources/articles/mysql-triggers.html

Apparently the information is outdated. The functionality was added in
5.0.10.

http://forums.mysql.com/read.php?99,33676,33676,quote=1

So I am not shocked about that any more, but more shocked that MySQL AB
feels free to make significant changes in features from one patchlevel
to another. One can't even rely on a list of supported features for 5.0.
No wonder that there is a lot of confusion. The available set of
features depends on the "release of the month". They intermix all sorts
of backward incompatible feature changes with bugfixes. I consider this
practice a classic example of sub standard software maintenance. It is
hard to believe that anyone would put a database system into production,
where every single bugfix release has to go through the full QA cycle
like a major version upgrade. The full release history horror story can
be found here:

http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Andreas Pflug 2005-12-01 17:13:15 Re: Thoughts on MySQL and InnoDB
Previous Message Robert Treat 2005-12-01 15:14:57 Re: An Elephant is Faithful 100%