Re: Strange behavior with integer unsigned type...

[Stephen Cook]

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 
> 
> 
>>.. 
> 
> 
> 
> 
> 
>