Re: AUTO_INCREMENT when column maximum is reached
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.
Subject
Views
Written By
Posted
716
September 03, 2020 10:48AM
327
September 03, 2020 11:54AM
Re: AUTO_INCREMENT when column maximum is reached
322
September 04, 2020 06:22AM
316
September 04, 2020 10:28AM
321
September 04, 2020 10:33AM
300
September 04, 2020 03:29PM
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.