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: [EMAIL PROTECTED]
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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
