[debian-mysql] [update] Severe? mysql 64bit bug

[Eduard Boer]

Hi,

I have found a bug. I can reproduce it.
 
create table SPS (
ID CHAR(32) NOT NULL UNIQUE PRIMARY KEY,
S91 TINYINT UNSIGNED NOT NULL DEFAULT 0
);

INSERT INTO SPS (ID,S91) VALUES
('4f2271284f2271284f2271284f227128',222);

SELECT S91,S91-1,S91-222,POW(S91-223,2) FROM SPS WHERE
ID='4f2271284f2271284f2271284f227128';
 
The result is:
"1";"222";"221";"0";"A really big number"

On my 32 bit machine the result is:
"1";"222";"221";"0";"1"

This is different!
 
System information:
Linux Q6600 Quad core 8Gbyte Memory 2.6.23-1-amd64
#1
SMP Fri Dec 21 12:00:17 UTC 2007 x86_64 GNU/Linux
 
Debian testing, with the kernel from SID
$ apt-cache show mysql-server
Package: mysql-server
Priority: optional
Section: misc
Installed-Size: 60
Maintainer: Debian MySQL Maintainers
<pkg-mysql-maint at lists.alioth.debian.org>
Architecture: all
Source: mysql-dfsg-5.0
Version: 5.0.45-5
Depends: mysql-server-5.0
Filename:
pool/main/m/mysql-dfsg-5.0/mysql-server_5.0.45-5_all.deb
Size: 50318
MD5sum: 2b9d29775ce84dd5a3726857774d33d8
SHA1: 46e88182f140508bd297ff43cc0d50dd0f4acf2c
 
Best Regards,
Eduard


      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping