Re: AUTO_INCREMENT when column maximum is reached

[Larry Menard]

Hi Peter, thanks for the response.

It fails only with the InnoDB engine though; it works fine with the MyISAM engine and in MariaDB. Is the number not magic in those environments? :-)

I guess I'm looking for is:

1) Confirmation that it is a MySQL bug and might someday be fixed? Perhaps a Bug number?

2) Anything I can to to avoid it?

I am testing a product that uses an RDBM backend data store (provided by the User, not by our product), so I test datatype limit scenarios frequently, and on certain platforms (CentOS 6, Windows *) the majority of our Users will be using MySQL. From what I can see right now, the only way to avoid this in those environments would be to recommend that our Users configure their MySQL to use MyISAM instead of InnoDB, but I'm sure that would have other consequences.

Thanks again.