[debian-mysql] Severe? mysql 64bit bug

[Eduard Boer]

Hi,

I have found a bug I think. 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,S91-223 FROM SPS WHERE
ID='4f2271284f2271284f2271284f227128';

The result is:
"1";"222";"221";"0";"18446744073709551615"


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
SHA256:
7c62a3b1aa1ce984e2911eb77b93110646319f47d031c0d612877183b3ca2781


Best Regard,
Eduard




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