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.
>
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
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.
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