List:General Discussion« Previous MessageNext Message »
From:Marko Domanovic Date:December 24 2005 9:02am
Subject:Re: Strange behavior with integer unsigned type...
View as plain text  
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