Bug #24176 bigint.test fails with --cursor-protocol
Submitted: 10 Nov 2006 10:32 Modified: 19 Aug 2008 15:32
Reporter: Magnus Blåudd Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Prepared statements Severity:S3 (Non-critical)
Version:5.0.30 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[10 Nov 2006 10:32] Magnus Blåudd 
Description:
 ./mtr --cursor-protocol bigint

mysql>  select 4294967296
returns
  2147483647

The value 4294967296 is returned probably as unsigned and shows 2147483647

There is also a similar problem further down in the test where
mysql> select 1000000000001

returns 2147483647

How to repeat:
 ./mtr --cursor-protocol bigint
[10 Nov 2006 10:33] Magnus Blåudd 
cast.test also fails with similar problems
[19 Aug 2008 15:26] Kristofer Pettersson 
Flash image of execution of SELECT CAST('-1' AS UNSIGNED) using cursor-protocol.

Attachment: trace1-cursor-prot.swf (application/x-shockwave-flash, text), 174.35 KiB.