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
..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
