MySQL Forums
Forum List  »  InnoDB

Re: AUTO_INCREMENT when column maximum is reached
Posted by: Larry Menard
Date: September 04, 2020 06:22AM

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.

Options: ReplyQuote

Written By
Re: AUTO_INCREMENT when column maximum is reached
September 04, 2020 06:22AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.