Bug #17412 stored procedure treats BIGINT UNSIGNED as BIGINT (input param)
Submitted: 15 Feb 2006 5:43 Modified: 15 Feb 2006 18:30
Reporter: Jacek Becla Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version: 5.0.15-standard OS:Linux (RedHat Enterprise 3)
Assigned to: CPU Architecture:Any

[15 Feb 2006 5:43] Jacek Becla 
Description:
stored procedure treats input parameter of type "BIGINT UNSIGNED" as BIGINT:
BIGINT is supposed to handle numbers up to 9223372036854775807,
and BIGINT UNSIGNED up to 18446744073709551615.

How to repeat:
create table X (bi BIGINT UNSIGNED);
delimiter //
CREATE PROCEDURE testBigInt (in_bigint BIGINT UNSIGNED)
BEGIN
  SELECT "I got: ", in_bigint;
  INSERT INTO X VALUES (in_bigint);
  SELECT * from X;
END
//
delimiter ;
call testBigInt(9223372036854775807);
call testBigInt(9223372036854775808);
[15 Feb 2006 11:54] Valeriy Kravchuk 
Thank you for a problem report. Please, try to repeat  with a newer version, 5.0.18, and inform about the results.
[15 Feb 2006 18:30] Jacek Becla 
As suggested I tried 5.0.18-standard and the problem is gone. I'm closing this bug