On Thu, 03 Feb 2011 03:23:25 -0000, Brian Aker <email address hidden> wrote:
> We can remove the requirement that AUTO_INCREMENT generate an index, it
> is not required.
This would cause problems for InnoDB as the way it gets the max auto inc
number on startup is to do a reverse index scan reading the last record.
On Thu, 03 Feb 2011 03:23:25 -0000, Brian Aker <email address hidden> wrote:
> We can remove the requirement that AUTO_INCREMENT generate an index, it
> is not required.
This would cause problems for InnoDB as the way it gets the max auto inc
number on startup is to do a reverse index scan reading the last record.
--
Stewart Smith