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

[sean finney]

hi eduard,

On Friday 18 January 2008 01:42:19 pm Eduard Boer wrote:
>   create table SPS (
> S91 TINYINT UNSIGNED NOT NULL DEFAULT 0
                          ^^^
> );
>
> INSERT INTO SPS (S91) VALUES
> (222);
>
> SELECT S91,S91-1,S91-222,S91-223 FROM SPS;
>
> The result is:
> "1";"222";"221";"0";"A really big number"
>
>   it should be:
>   "1";"222";"221";"0";"-1"

but it's unsigned...  i'd say it's not a bug, or at worst merely ambiguous...


	sean
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part.
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20080118/0d8f18f4/attachment.pgp