spamassassin-users June 2011 archive
Main Archive Page > Month Archives  > spamassassin-users archives
spamassassin-users: MySQL defects (was Re: High Performance Baye

MySQL defects (was Re: High Performance Bayes Database Configuration?)

From: David F. Skoll <dfs_at_nospam>
Date: Thu Jun 23 2011 - 11:03:09 GMT
To: users@spamassassin.apache.org

On Thu, 23 Jun 2011 10:29:43 +0200
Matus UHLAR - fantomas <uhlar@fantomas.sk> wrote:

> On 21.06.11 15:17, David F. Skoll wrote:
> >No, not really, but MySQL is broken in so many ways I try to stay
> >away from it. Many of the design flaws in
> >http://sql-info.de/mysql/gotchas.html remain unfixed. For example,
> >even in MySQL 5.0.5, 'select 1/0;' returns NULL.

> Pardon, but which of those apply when talking about using MySQL for
> bayes database?

:)

None, specifically. Our product already uses a database for other reasons
(PostgreSQL), so it would be silly to use *two* databases. And I would
certainly never pick MySQL as the main product database.

[...]

> 2003-02-31 is INVALID date and therefore inserting it into the
> database and selecting back CAN NOT return the same data.

My point is the INSERT should **fail**, not silently change your data.
Any non-toy DB will fail the INSERT.

Regards,

David.