|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: MAX on UNSIGNED INT Column
From: Paul DuBois (paul
mysql.com)
Date: Tue Jul 05 2005 - 14:23:16 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]