Revisions to Out of range value for Integer

Example

edited Oct 28, 2009 at 13:13

It's not a bug, it's merely a case of integer overflow.

If you need your number-in-string value to max out, you should add code to do that, either when you do the insert, or as a trigger.

You can also experiment with small selects (untested, I don't have MySQL access here):

SELECT CAST('2123456789012345678' AS INT(11)) SELECT CAST('21234567890123456789' AS INT(11))

It's not a bug, it's merely a case of integer overflow.

If you need your number-in-string value to max out, you should add code to do that, either when you do the insert, or as a trigger.

You can also experiment with small selects (untested, I don't have MySQL access here):

SELECT CAST('2123456789012345678' AS INT(11)) SELECT CAST('21234567890123456789' AS INT(11))

Post Undeleted by csl

occurred Oct 28, 2009 at 13:05

Removed last line

edited Oct 28, 2009 at 13:05

It's not a bug, it's merely a case of integer overflow.

If you want a too big value to max out to a given value, you should write a trigger for the table.

Post Deleted by csl

occurred Oct 28, 2009 at 13:01

answered Oct 28, 2009 at 12:59

It's not a bug, it's merely a case of integer overflow.

If you want a too big value to max out to a given value, you should write a trigger for the table.

Return to Answer