[Pkg-nagios-devel] Bug#287792: possible mysql bug

Christian Hammers Christian Hammers <ch@debian.org>, 287792@bugs.debian.org
Wed, 5 Jan 2005 02:39:08 +0100


reassign #287792 mysql-server
severity #287792 normal
tags #287792 + patch upstream confirmed
thanks

Hello Christian

On 2005-01-05 Christian Kujau wrote:
> sorry to bother you directly (and not using the BTS), but i am only
> *suspecting* a mysql-related bug, i am not sure though. can you have a
> quick look at debian bug #287792, please?

It is indeed a MySQL bug. from_unixtime(0) is now NULL instead of
"1970-01-01" aka the Epoch. This is the relevant upstream bug report:
	http://bugs.mysql.com/bug.php?id=7515
I reassigned the bug report to my packages and will try to backport the fix as
it might take some time until MySQL releases a new version. 

This seems to be the upstream changesets:
4.0: http://lists.mysql.com/internals/20093
     http://lists.mysql.com/internals/20112
4.1: http://lists.mysql.com/internals/20122
5.0: http://lists.mysql.com/internals/20223

bye,

-christian-