OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
MAX on UNSIGNED INT Column

From: Jacob S. Barrett (jbarrettpogozone.com)
Date: Tue Jul 05 2005 - 14:17:10 CDT

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.

Thanks,
Jake

--
Jacob S. Barrett
Chief Technology Officer
PogoZone LLC

  email: jbarrettpogozone.com
    web: www.pogozone.com
  voice: 360-676-8772
    fax: 360-733-3941
address: 114 W. Magnolia Street Suite 417
         Bellingham, Washington 98225

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql