At 12:17 -0700 7/5/05, Jacob S. Barrett wrote:
I have a column of type UNSIGNED INT which holds a 32bit counter. When the value of the field exceeds 2147483647 (signed max) the value of MAX on the column returns a negative number. If I convert the column to BIGINT the correct MAX is returned. Is this expected behavior, am I doing something wrong, is this a bug? I would rather not store a 32bit counter as a 64bit value, but I need the MAX function to work so in the mean time I will convert all these fields to BIGINT.
Please report a repeatable test case to http://bugs.mysql.com. Thanks. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
