← Back to team overview

maria-developers team mailing list archive

Re: c75f774d278: MDEV-31058 ER_KEY_NOT_FOUND upon concurrent CHANGE column autoinc and DML



On Wed, 24 May 2023 at 16:09, Sergei Golubchik <serg@xxxxxxxxxxx> wrote:

> > +set statement sql_mode= NO_AUTO_VALUE_ON_ZERO for
> > +alter table t drop a, modify b serial, algorithm=copy, lock=none;
> I don't think it should work, see my comment in the MDEV
the existing values will not be changed under NO_AUTO_VALUE_ON_ZERO,
this is why it's fine.

Yours truly,
Nikita Malyavin