Re: MAX on UNSIGNED INT Column
On Wednesday 06 July 2005 11:42 am, Keith Ivey <[EMAIL PROTECTED]> wrote: > 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. > > Possibly this bug, fixed in 4.1.12? > > http://bugs.mysql.com/bug.php?id=9298 Bingo. Sorry I didn't see that one when searching. I am on 4.1.10 so it looks like I will be upgrading the box this weekend. 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]
Re: MAX on UNSIGNED INT Column
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. Possibly this bug, fixed in 4.1.12? http://bugs.mysql.com/bug.php?id=9298 -- Keith Ivey <[EMAIL PROTECTED]> Smokefree DC http://www.smokefreedc.org Washington, DC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MAX on UNSIGNED INT Column
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]
MAX on UNSIGNED INT Column
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]