package: mysql-server version: 4.0.24-2 tags: upstream confirmed severity: important forwarded: http://bugs.mysql.com/9191
I just stumbled over the following bug which seems to have been introduced between 4.0.22 and 4.0.23. bye, -christian- On 2005-03-15 Bug Database wrote: > From: Christian Hammers > Status: Open > Severity: S2 (Serious) > Showstopper: Yes > Priority: P3 (Medium) > Category: Server > Reported by: User > Reported at: > Email subject: > Email date: > Release: 4.0.22 -> 4.0.23/24 > Operating system: > > Bug description: from_unixtime(power(2,31)-1) now epoch instaed of 2038-01-19 > > Description: > "select from_unixtime(power(2,31)-1);" used to return "2038-01-19 > 04:14:07" but now > returns NULL although the timerange is valid (positive signed int32). > > (It's used where you have a fixed "date between from_unixtime(a) and > from_unixtime(b)" query and have to insert something as b that in every > case is larger than date...) > > The behaviour changed between 4.0.22 and 4.0.23 and ist still present in > 4.0.24. > > Maybe bug report #6439 is relevant here.
pgpochRsBjr7O.pgp
Description: PGP signature
