Re: MAX on UNSIGNED INT Column

2005-07-06 Thread Jacob S. Barrett
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. >

Re: MAX on UNSIGNED INT Column

2005-07-06 Thread Keith Ivey
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

Re: MAX on UNSIGNED INT Column

2005-07-05 Thread Paul DuBois
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.

MAX on UNSIGNED INT Column

2005-07-05 Thread Jacob S. Barrett
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 somethin