MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:December 30 2005 4:26pm
Subject:Re: Strange behavior with integer unsigned type...
View as plain text  
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 
> .. 
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



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