Bug #24176 bigint.test fails with --cursor-protocol
Submitted: 10 Nov 2006 11:32 Modified: 19 Aug 2008 17:32
Reporter: Magnus Blaudd
Status: Verified
Category:Server: PS Severity:S3 (Non-critical)
Version:5.0.30 OS:Any
Assigned to: Evgeny Potemkin Target Version:
Triage: Triaged: D2 (Serious) / R4 (High) / E4 (High)

[10 Nov 2006 11:32] Magnus Blaudd 
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 11:33] Magnus Blaudd 
cast.test also fails with similar problems
[19 Aug 2008 17: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.