List:General Discussion« Previous MessageNext Message »
From:Stephen Cook Date:December 31 2005 3:00am
Subject:Re: Strange behavior with integer unsigned type...
View as plain text  
Maybe it is because I am a programmer, but (unsigned) 0 - 1 = 4294967295.

What's the big deal?

Gleb Paharenko wrote:
> Hello.
> 
> 
> 
> That seems like a bug:
> 
>   http://bugs.mysql.com/bug.php?id=14543
> 
> 
> 
> 
> 
> Marko Domanovic wrote:
> 
> 
>>mysql 5.0.15-standard
> 
> 
>>UPDATE <table> SET <fieldname> = <fieldname>-1
> 
> 
>>when the <fieldname> is 0 gives me 4294967295
> 
> 
>><fieldname> is integer(10) unsigned...
> 
> 
> 
>>maybe it would be more logical the expression to evaluate as 0, insted 2^32 
> 
> 
>>.. 
> 
> 
> 
> 
> 
> 
Thread
Strange behavior with integer unsigned type...Marko Domanovic23 Dec
  • Re: Strange behavior with integer unsigned type...Gleb Paharenko23 Dec
    • Re: Strange behavior with integer unsigned type...James Harvard24 Dec
Re: Strange behavior with integer unsigned type...Marko Domanovic24 Dec
  • Re: Strange behavior with integer unsigned type...Gleb Paharenko30 Dec
    • Re: Strange behavior with integer unsigned type...Stephen Cook31 Dec