Bug #6958 Negative arguments to integer options wrap around
Submitted: 2 Dec 2004 19:07 Modified: 22 Feb 2005 14:49
Reporter: Marko Mäkelä
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:4.1, maybe all OS:Any (all)
Assigned to: Sergey Vojtovich Target Version:

[2 Dec 2004 19:07] Marko Mäkelä 
Description:
Negative integer arguments to SET VARIABLES are treated as positive ones, modulo 2^32,
e.g., -1 seems to be (2^32 - 1).

How to repeat:
set global innodb_autoextend_increment=-1;
show variables like 'innodb_autoextend_increment';
Notice that the variable has been set to its maximum limit.

Suggested fix:
Clip negative values to the minimum limit, and not the maximum.
[8 Feb 2005 20:26] Paul DuBois 
This looks like a server bug to me.  I'm surprised at Marko's
comment that it's correct behavior.  I don't see how users would
view this wraparound behavior as correct or expected.

I am unassigning this from myself - not a doc bug.
[9 Feb 2005 9:27] Marko Mäkelä 
Paul, I don't think that it is correct behavior. If I did, I would not have reported this
bug in the first place. I did not assign this bug to you. Maybe the person who did should
comment on this.
[18 Feb 2005 12:17] Sergey Vojtovich 
Fixed in 4.1.11, ChangeSet 1.2180
Fixed in 5.0.3
[22 Feb 2005 14:49] Paul DuBois 
Noted in 4.1.11, 5.0.3 changelogs.