Re: Strange behavior with integer unsigned type...

2005-12-24 Thread Marko Domanovic
mysql 5.0.15-standard UPDATE SET = -1 when the is 0 gives me 4294967295 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.

Strange behavior with integer unsigned type...

2005-12-23 Thread Marko Domanovic
I noticed rather interesting thing... If you deduct 1 from the 0 which is stored in integer unsigned field, you get 2^32, not 0. I think that's how things are not working with version 4, and want to ask is this behavior bug or feature in mysql version 5, and is it customizable? Greetings, Mark